Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add extra test cases related to the previous commit. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
3c690b2b05b7338f3325c50a0750c602 |
| User & Date: | dan 2019-08-10 14:35:06 |
Context
|
2019-08-10
| ||
| 15:06 | Fix the sqliteExprImpliesExpr() routine so that it recognizes that "(NULL IS FALSE) IS FALSE" doe not imply "NULL NOT NULL". Ticket [9080b6227fabb466] (check-in: da01ba4fa4 user: drh tags: trunk) | |
| 14:35 | Add extra test cases related to the previous commit. (check-in: 3c690b2b05 user: dan tags: trunk) | |
| 14:16 | Remove two incorrect assert() statements from the logic used to derive column names and types from subqueries. (check-in: 712e477148 user: drh tags: trunk) | |
Changes
Changes to test/window4.tcl.
381 382 383 384 385 386 387 388 389 390 |
execsql_test 11.4 {
SELECT * FROM (
SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8
) sub;
}
finish_test
|
> > > > > > > > > > > > > > > > > > > > |
381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 |
execsql_test 11.4 {
SELECT * FROM (
SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8
) sub;
}
execsql_test 12.0 {
DROP TABLE IF EXISTS t2;
CREATE TABLE t2(a INTEGER);
INSERT INTO t2 VALUES(1), (2), (3);
}
execsql_test 12.1 {
SELECT (SELECT min(a) OVER ()) FROM t2
}
execsql_float_test 12.2 {
SELECT (SELECT avg(a)) FROM t2 ORDER BY 1
}
execsql_float_test 12.3 {
SELECT
(SELECT avg(a) UNION SELECT min(a) OVER ())
FROM t2 GROUP BY a
ORDER BY 1
}
finish_test
|
Changes to test/window4.test.
1319 1320 1321 1322 1323 1324 1325 1326 1327 |
} {0 1 2}
do_execsql_test 11.4 {
SELECT * FROM (
SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8
) sub;
} {0 1 2}
finish_test
|
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > |
1319 1320 1321 1322 1323 1324 1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 |
} {0 1 2}
do_execsql_test 11.4 {
SELECT * FROM (
SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8
) sub;
} {0 1 2}
do_execsql_test 12.0 {
DROP TABLE IF EXISTS t2;
CREATE TABLE t2(a INTEGER);
INSERT INTO t2 VALUES(1), (2), (3);
} {}
do_execsql_test 12.1 {
SELECT (SELECT min(a) OVER ()) FROM t2
} {1 2 3}
do_test 12.2 {
set myres {}
foreach r [db eval {SELECT (SELECT avg(a)) FROM t2 ORDER BY 1}] {
lappend myres [format %.4f [set r]]
}
set res2 {2.0000}
set i 0
foreach r [set myres] r2 [set res2] {
if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
error "list element [set i] does not match: got=[set r] expected=[set r2]"
}
incr i
}
set {} {}
} {}
do_test 12.3 {
set myres {}
foreach r [db eval {SELECT
(SELECT avg(a) UNION SELECT min(a) OVER ())
FROM t2 GROUP BY a
ORDER BY 1}] {
lappend myres [format %.4f [set r]]
}
set res2 {1.0000 2.0000 3.0000}
set i 0
foreach r [set myres] r2 [set res2] {
if {[set r]<([set r2]-0.0001) || [set r]>([set r2]+0.0001)} {
error "list element [set i] does not match: got=[set r] expected=[set r2]"
}
incr i
}
set {} {}
} {}
finish_test
|