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: |
06e1fab7527c6b4330a58f8d8873afaf |
| 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
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
|