Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Updates to requirement marks. No code changes. |
---|---|
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
484d0e58e011c2440d053a8bc4055ffa |
User & Date: | drh 2016-11-22 19:15:33.543 |
Context
2016-12-30
| ||
20:22 | Update the built-in SQLite to the latest 3.16.0 beta. check-in: 32c0710fcb user: drh tags: trunk | |
2016-11-22
| ||
19:15 | Updates to requirement marks. No code changes. check-in: 484d0e58e0 user: drh tags: trunk | |
2016-10-05
| ||
19:09 | Update the built-in SQLite to the 3.15.0 beta. check-in: ef3b86baac user: drh tags: trunk | |
Changes
Changes to test/evidence/in1.test.
1 2 3 4 5 6 7 8 9 10 | # So far, this only runs well on SQLite and MySQL. # skip this entire file if ms sql server onlyif mssql halt # skip this entire file if oracle onlyif oracle halt | < < < < < | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | # So far, this only runs well on SQLite and MySQL. # skip this entire file if ms sql server onlyif mssql halt # skip this entire file if oracle onlyif oracle halt # EVIDENCE-OF: R-52275-55503 When the right operand is an empty set, the # result of IN is false and the result of NOT IN is true, regardless of # the left operand and even if the left operand is NULL. # # EVIDENCE-OF: R-13595-45863 Note that SQLite allows the parenthesized # list of scalar values on the right-hand side of an IN or NOT IN |
︙ | ︙ |
Changes to test/evidence/in2.test.
|
| < < < < | 1 2 3 4 5 6 7 | # EVIDENCE-OF: R-52275-55503 When the right operand is an empty set, the # result of IN is false and the result of NOT IN is true, regardless of # the left operand and even if the left operand is NULL. # # EVIDENCE-OF: R-13595-45863 Note that SQLite allows the parenthesized |
︙ | ︙ | |||
289 290 291 292 293 294 295 | SELECT 1 FROM t1 WHERE NULL NOT IN ( NULL, 1.0 ) ---- query I nosort SELECT 1 FROM t1 WHERE NULL NOT IN ( NULL, '1' ) ---- | | | > < | 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 | SELECT 1 FROM t1 WHERE NULL NOT IN ( NULL, 1.0 ) ---- query I nosort SELECT 1 FROM t1 WHERE NULL NOT IN ( NULL, '1' ) ---- # EVIDENCE-OF: R-35033-20570 The subquery on the right of an IN or NOT # IN operator must be a scalar subquery if the left expression is not a # row value expression. query I nosort SELECT 1 FROM t1 WHERE 1 IN (SELECT 1) ---- 1 1 1 statement error SELECT 1 FROM t1 WHERE 1 IN (SELECT 1,2) statement error SELECT 1 FROM t1 WHERE 1 IN (SELECT x,y FROM t1) statement error SELECT 1 FROM t1 WHERE 1 IN (SELECT * FROM t1) statement error SELECT 1 FROM t1 WHERE 1 IN (SELECT min(x),max(x) FROM t1) |