Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add test cases to unionvtab.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
6c9128e1a53f8cf26de9ef1bc07051f2 |
| User & Date: | dan 2017-07-18 18:50:37 |
Context
|
2017-07-18
| ||
| 19:51 | Have unionvtab support constraints on the column that corresponds to the INTEGER PRIMARY KEY field of the underlying source tables in the same way as rowid. check-in: 4a6c416f user: dan tags: trunk | |
| 18:50 | Add test cases to unionvtab.test. check-in: 6c9128e1 user: dan tags: trunk | |
| 18:19 | Add the union-vtab extension - still experimental and under active development. check-in: 948f9504 user: drh tags: trunk | |
Changes
Changes to test/unionvtab.test.
233 234 235 236 237 238 239 240 241 242 |
do_execsql_test 3.7.4 { SELECT count(*) FROM uu WHERE rowid >= 73 } {128}
do_execsql_test 3.7.5 { SELECT count(*) FROM uu WHERE rowid >= 74 } {127}
do_execsql_test 3.7.6 { SELECT count(*) FROM uu WHERE rowid >= 75 } {100}
do_execsql_test 3.7.7 { SELECT count(*) FROM uu WHERE rowid >= 76 } {25}
do_execsql_test 3.7.8 { SELECT count(*) FROM uu WHERE rowid >= 99 } {2}
do_execsql_test 3.7.9 { SELECT count(*) FROM uu WHERE rowid >= 100 } {1}
do_execsql_test 3.7.10 { SELECT count(*) FROM uu WHERE rowid >= 101 } {0}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 |
do_execsql_test 3.7.4 { SELECT count(*) FROM uu WHERE rowid >= 73 } {128}
do_execsql_test 3.7.5 { SELECT count(*) FROM uu WHERE rowid >= 74 } {127}
do_execsql_test 3.7.6 { SELECT count(*) FROM uu WHERE rowid >= 75 } {100}
do_execsql_test 3.7.7 { SELECT count(*) FROM uu WHERE rowid >= 76 } {25}
do_execsql_test 3.7.8 { SELECT count(*) FROM uu WHERE rowid >= 99 } {2}
do_execsql_test 3.7.9 { SELECT count(*) FROM uu WHERE rowid >= 100 } {1}
do_execsql_test 3.7.10 { SELECT count(*) FROM uu WHERE rowid >= 101 } {0}
set L [expr 9223372036854775807]
set S [expr -9223372036854775808]
do_execsql_test 3.8.1 { SELECT count(*) FROM uu WHERE rowid >= $S } {300}
do_execsql_test 3.8.2 { SELECT count(*) FROM uu WHERE rowid > $S } {300}
do_execsql_test 3.8.3 { SELECT count(*) FROM uu WHERE rowid <= $S } {0}
do_execsql_test 3.8.4 { SELECT count(*) FROM uu WHERE rowid < $S } {0}
do_execsql_test 3.9.1 { SELECT count(*) FROM uu WHERE rowid >= $L } {0}
do_execsql_test 3.9.2 { SELECT count(*) FROM uu WHERE rowid > $L } {0}
do_execsql_test 3.9.3 { SELECT count(*) FROM uu WHERE rowid <= $L } {300}
do_execsql_test 3.9.4 { SELECT count(*) FROM uu WHERE rowid < $L } {300}
#-------------------------------------------------------------------------
#
do_execsql_test 4.0 {
CREATE TABLE s1(k INTEGER PRIMARY KEY, v);
INSERT INTO s1 VALUES($S, 'one');
INSERT INTO s1 VALUES($S+1, 'two');
INSERT INTO s1 VALUES($S+2, 'three');
CREATE TABLE l1(k INTEGER PRIMARY KEY, v);
INSERT INTO l1 VALUES($L, 'six');
INSERT INTO l1 VALUES($L-1, 'five');
INSERT INTO l1 VALUES($L-2, 'four');
CREATE VIRTUAL TABLE temp.sl USING unionvtab(
"SELECT NULL, 'l1', 0, 9223372036854775807
UNION ALL
SELECT NULL, 's1', -9223372036854775808, -1"
);
}
do_execsql_test 4.1 {
SELECT * FROM sl;
} {
-9223372036854775808 one -9223372036854775807 two -9223372036854775806 three
9223372036854775805 four 9223372036854775806 five 9223372036854775807 six
}
foreach {k v} {
-9223372036854775808 one -9223372036854775807 two -9223372036854775806 three
9223372036854775805 four 9223372036854775806 five 9223372036854775807 six
} {
do_execsql_test 4.2.$v { SELECT * FROM sl WHERE rowid=$k } [list $k $v]
}
do_execsql_test 4.3.1 {
SELECT * FROM sl WHERE rowid>-9223372036854775808
} {
-9223372036854775807 two -9223372036854775806 three
9223372036854775805 four 9223372036854775806 five 9223372036854775807 six
}
do_execsql_test 4.3.2 {
SELECT * FROM sl WHERE rowid>=-9223372036854775808
} {
-9223372036854775808 one -9223372036854775807 two -9223372036854775806 three
9223372036854775805 four 9223372036854775806 five 9223372036854775807 six
}
do_execsql_test 4.3.3 {
SELECT * FROM sl WHERE rowid<=-9223372036854775808
} {
-9223372036854775808 one
}
do_execsql_test 4.3.4 {
SELECT * FROM sl WHERE rowid<-9223372036854775808
} { }
do_execsql_test 4.4.1 {
SELECT * FROM sl WHERE rowid<9223372036854775807
} {
-9223372036854775808 one -9223372036854775807 two -9223372036854775806 three
9223372036854775805 four 9223372036854775806 five
}
do_execsql_test 4.4.2 {
SELECT * FROM sl WHERE rowid<=9223372036854775807
} {
-9223372036854775808 one -9223372036854775807 two -9223372036854775806 three
9223372036854775805 four 9223372036854775806 five 9223372036854775807 six
}
do_execsql_test 4.3.3 {
SELECT * FROM sl WHERE rowid>=9223372036854775807
} {
9223372036854775807 six
}
do_execsql_test 4.4.4 {
SELECT * FROM sl WHERE rowid>9223372036854775807
} { }
finish_test
|