/ Check-in [06e1fab7]
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 | SQL 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
Context
2016-06-29
06:19
Add the ability to have a table-valued function on the RHS of an IN operator. check-in: ba1b441b user: drh tags: prototype-int-array
05:08
Another test case for the intarray($PTR,$N) virtual table. check-in: 06e1fab7 user: drh tags: prototype-int-array
05:00
Add a prototype intarray($PTR,$N) table valued function. check-in: 233b3338 user: drh tags: prototype-int-array
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to test/tabfunc01.test.

   151    151     sqlite3_column_int $VM 0
   152    152   } 11
   153    153   do_test tabfunc01-621 {
   154    154     sqlite3_step $VM
   155    155     sqlite3_column_int $VM 0
   156    156   } 22
   157    157   sqlite3_finalize $VM
          158  +
          159  +do_test tabfunc01-650 {
          160  +  db eval {
          161  +    DROP TABLE IF EXISTS t6;
          162  +    CREATE TABLE t6(x INTEGER PRIMARY KEY, y BLOB);
          163  +    WITH RECURSIVE c(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM c WHERE x<100)
          164  +      INSERT INTO t6(x,y) SELECT x, randomblob(x) FROM c;
          165  +  }
          166  +  set TAIL {}
          167  +  set VM [sqlite3_prepare db {
          168  +     SELECT length(y) FROM t6 WHERE x IN (SELECT value FROM intarray(?1,3));
          169  +  } -1 TAIL]
          170  +  string trim $TAIL
          171  +} {}
          172  +do_test tabfunc01-660 {
          173  +  sqlite3_bind_intarray $VM 1 11 22 33 44 55
          174  +  sqlite3_step $VM
          175  +} SQLITE_ROW
          176  +do_test tabfunc01-661 {
          177  +  sqlite3_column_int $VM 0
          178  +} 11
          179  +sqlite3_finalize $VM
          180  +
   158    181   catch {sqlite3_bind_intarray}
   159    182   
   160    183   finish_test