Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a test case problem in wherelimit.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
3012df8b2c0b19d27260f389147a96c5 |
| User & Date: | dan 2018-05-15 09:09:00 |
Context
|
2018-05-16
| ||
| 12:19 | Correct output for the fullkey column of json_each() when the total JSON input is a simple value, not an array or object. check-in: b45b1885 user: drh tags: trunk | |
|
2018-05-15
| ||
| 11:45 | Merge latest trunk changes with this branch. check-in: ae86cf60 user: dan tags: begin-concurrent | |
| 09:09 | Fix a test case problem in wherelimit.test. check-in: 3012df8b user: dan tags: trunk | |
|
2018-05-14
| ||
| 22:46 | Make more aggressive use of automatic indexes when processing materalized views and subqueries. check-in: 172f5bd2 user: drh tags: trunk | |
Changes
Changes to test/wherelimit.test.
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 |
do_test wherelimit-0.2 {
catchsql {DELETE FROM t1 WHERE x=1 ORDER BY x}
} {1 {ORDER BY without LIMIT on DELETE}}
do_test wherelimit-0.3 {
catchsql {UPDATE t1 SET y=1 WHERE x=1 ORDER BY x}
} {1 {ORDER BY without LIMIT on UPDATE}}
execsql { DROP TABLE t1 }
# no AS on table sources
do_test wherelimit-0.4 {
catchsql {DELETE FROM t1 AS a WHERE x=1}
} {1 {near "AS": syntax error}}
do_test wherelimit-0.5 {
catchsql {UPDATE t1 AS a SET y=1 WHERE x=1}
} {1 {near "AS": syntax error}}
# OFFSET w/o LIMIT
do_test wherelimit-0.6 {
catchsql {DELETE FROM t1 WHERE x=1 OFFSET 2}
} {1 {near "OFFSET": syntax error}}
do_test wherelimit-0.7 {
catchsql {UPDATE t1 SET y=1 WHERE x=1 OFFSET 2}
} {1 {near "OFFSET": syntax error}}
# check deletes w/o where clauses but with limit/offsets
create_test_data 5
do_test wherelimit-1.0 {
execsql {SELECT count(*) FROM t1}
} {25}
do_test wherelimit-1.1 {
|
| | | > | < > | < > > > > > |
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 |
do_test wherelimit-0.2 {
catchsql {DELETE FROM t1 WHERE x=1 ORDER BY x}
} {1 {ORDER BY without LIMIT on DELETE}}
do_test wherelimit-0.3 {
catchsql {UPDATE t1 SET y=1 WHERE x=1 ORDER BY x}
} {1 {ORDER BY without LIMIT on UPDATE}}
# no AS on table sources
#
# UPDATE: As of version 3.24, AS clauses are allowed as part of
# UPDATE or DELETE statements.
do_test wherelimit-0.4 {
catchsql {DELETE FROM t1 AS a WHERE a.x=1}
} {0 {}}
do_test wherelimit-0.5.1 {
catchsql {UPDATE t1 AS a SET y=1 WHERE x=1}
} {0 {}}
do_test wherelimit-0.5.2 {
catchsql {UPDATE t1 AS a SET y=1 WHERE t1.x=1}
} {1 {no such column: t1.x}}
# OFFSET w/o LIMIT
do_test wherelimit-0.6 {
catchsql {DELETE FROM t1 WHERE x=1 OFFSET 2}
} {1 {near "OFFSET": syntax error}}
do_test wherelimit-0.7 {
catchsql {UPDATE t1 SET y=1 WHERE x=1 OFFSET 2}
} {1 {near "OFFSET": syntax error}}
execsql { DROP TABLE t1 }
# check deletes w/o where clauses but with limit/offsets
create_test_data 5
do_test wherelimit-1.0 {
execsql {SELECT count(*) FROM t1}
} {25}
do_test wherelimit-1.1 {
|