SQLite

Check-in [06e1fab752]
Login

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

Overview
Comment:Another test case for the intarray($PTR,$N) virtual table.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | prototype-int-array
Files: files | file ages | folders
SHA1: 06e1fab7527c6b4330a58f8d8873afaf2d67ae86
User & Date: drh 2016-06-29 05:08:01.847
Context
2016-06-29
06:19
Add the ability to have a table-valued function on the RHS of an IN operator. (check-in: ba1b441b60 user: drh tags: prototype-int-array)
05:08
Another test case for the intarray($PTR,$N) virtual table. (check-in: 06e1fab752 user: drh tags: prototype-int-array)
05:00
Add a prototype intarray($PTR,$N) table valued function. (check-in: 233b33382d user: drh tags: prototype-int-array)
Changes
Unified Diff Ignore Whitespace Patch
Changes to test/tabfunc01.test.
151
152
153
154
155
156
157























158
159
160
  sqlite3_column_int $VM 0
} 11
do_test tabfunc01-621 {
  sqlite3_step $VM
  sqlite3_column_int $VM 0
} 22
sqlite3_finalize $VM























catch {sqlite3_bind_intarray}

finish_test







>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>



151
152
153
154
155
156
157
158
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
  sqlite3_column_int $VM 0
} 11
do_test tabfunc01-621 {
  sqlite3_step $VM
  sqlite3_column_int $VM 0
} 22
sqlite3_finalize $VM

do_test tabfunc01-650 {
  db eval {
    DROP TABLE IF EXISTS t6;
    CREATE TABLE t6(x INTEGER PRIMARY KEY, y BLOB);
    WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
      INSERT INTO t6(x,y) SELECT x, randomblob(x) FROM c;
  }
  set TAIL {}
  set VM [sqlite3_prepare db {
     SELECT length(y) FROM t6 WHERE x IN (SELECT value FROM intarray(?1,3));
  } -1 TAIL]
  string trim $TAIL
} {}
do_test tabfunc01-660 {
  sqlite3_bind_intarray $VM 1 11 22 33 44 55
  sqlite3_step $VM
} SQLITE_ROW
do_test tabfunc01-661 {
  sqlite3_column_int $VM 0
} 11
sqlite3_finalize $VM

catch {sqlite3_bind_intarray}

finish_test