SQLite

Check-in [1d4759c17c]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:simple test cases for carray_asc.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | carray_asc
Files: files | file ages | folders
SHA1: 1d4759c17c32f5ee693f7ff6e70e555f613dbcda
User & Date: drh 2017-02-15 17:47:49.138
Context
2017-02-15
17:47
simple test cases for carray_asc. (Leaf check-in: 1d4759c17c user: drh tags: carray_asc)
16:11
Add the companion "carray_asc" table-valued function to the carray extension. (check-in: a2b4f60b33 user: drh tags: carray_asc)
Changes
Unified Diff Ignore Whitespace Patch
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 {