Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | New test case for ticket [b899b6042f97f52d]. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
9d91ee5ee3f316a8804b02eb3c34b175 |
| User & Date: | drh 2017-09-11 23:46:59 |
Context
|
2017-09-12
| ||
| 00:24 | Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. check-in: d7b7f038 user: drh tags: trunk | |
|
2017-09-11
| ||
| 23:46 | New test case for ticket [b899b6042f97f52d]. check-in: 9d91ee5e user: drh tags: trunk | |
| 20:54 | Add support for new operators in virtual tables: !=, IS, IS NOT, IS NULL, and NOTNULL. check-in: 3b7dbe9d user: drh tags: trunk | |
Changes
Changes to test/whereF.test.
180 180 # Segfault on correlated subquery... 181 181 # 182 182 ifcapable json1 { 183 183 do_execsql_test 6.1 { 184 184 CREATE TABLE t6(x); 185 185 SELECT * FROM t6 WHERE 1 IN (SELECT value FROM json_each(x)); 186 186 } {} 187 + 188 + do_execsql_test 6.2 { 189 + DROP TABLE t6; 190 + CREATE TABLE t6(a,b,c); 191 + INSERT INTO t6 VALUES 192 + (0,null,'{"a":0,"b":[3,4,5],"c":{"x":4.5,"y":7.8}}'), 193 + (1,null,'{"a":1,"b":[3,4,5],"c":{"x":4.5,"y":7.8}}'), 194 + (2,null,'{"a":9,"b":[3,4,5],"c":{"x":4.5,"y":7.8}}'); 195 + SELECT * FROM t6 196 + WHERE (EXISTS (SELECT 1 FROM json_each(t6.c) AS x WHERE x.value=1)); 197 + } {1 {} {{"a":1,"b":[3,4,5],"c":{"x":4.5,"y":7.8}}}} 198 + 187 199 } 188 200 189 201 finish_test