Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | simple test cases for carray_asc. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | carray_asc |
| Files: | files | file ages | folders |
| SHA1: |
1d4759c17c32f5ee693f7ff6e70e555f |
| User & Date: | drh 2017-02-15 17:47:49 |
Context
|
2017-02-15
| ||
| 17:47 | simple test cases for carray_asc. Leaf check-in: 1d4759c1 user: drh tags: carray_asc | |
| 16:11 | Add the companion "carray_asc" table-valued function to the carray extension. check-in: a2b4f60b user: drh tags: carray_asc | |
Changes
Changes to test/tabfunc01.test.
159 160 161 162 163 164 165 166 167 168 169 170 171 172 |
}
} {(005) (007) (013) (017) (023)}
do_test tabfunc01-702 {
db eval {
SELECT b FROM t600 WHERE a IN carray($PTR1,4,'int32');
}
} {(005) (007) (013) (017)}
do_catchsql_test tabfunc01-710 {
SELECT b FROM t600 WHERE a IN carray($PTR1,5,'int33');
} {1 {unknown datatype: 'int33'}}
do_test tabfunc01-720 {
set PTR2 [int64array_addr 5 7 13 17 23]
db eval {
|
> > > > > > > > > > > > > > > > > > > > > > > > > |
159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 |
}
} {(005) (007) (013) (017) (023)}
do_test tabfunc01-702 {
db eval {
SELECT b FROM t600 WHERE a IN carray($PTR1,4,'int32');
}
} {(005) (007) (013) (017)}
do_test tabfunc01-703 {
db eval {
SELECT value FROM carray($PTR1, 5) ORDER BY value;
}
} {5 7 13 17 23}
do_test tabfunc01-703x {db status sort} 1
do_test tabfunc01-704 {
db eval {
SELECT value FROM carray_asc($PTR1, 5) ORDER BY value;
}
} {5 7 13 17 23}
do_test tabfunc01-704x {db status sort} 0
do_test tabfunc01-705 {
db eval {
SELECT value FROM carray($PTR1, 5) ORDER BY value DESC;
}
} {23 17 13 7 5}
do_test tabfunc01-705x {db status sort} 1
do_test tabfunc01-706 {
db eval {
SELECT value FROM carray_asc($PTR1, 5) ORDER BY value DESC;
}
} {23 17 13 7 5}
do_test tabfunc01-706x {db status sort} 1
do_catchsql_test tabfunc01-710 {
SELECT b FROM t600 WHERE a IN carray($PTR1,5,'int33');
} {1 {unknown datatype: 'int33'}}
do_test tabfunc01-720 {
set PTR2 [int64array_addr 5 7 13 17 23]
db eval {
|