aboutsummaryrefslogtreecommitdiff
path: root/testdata/tcl/wherelimit2.test
diff options
context:
space:
mode:
authorJan Mercl <0xjnml@gmail.com>2020-08-26 23:31:54 +0200
committerJan Mercl <0xjnml@gmail.com>2020-08-26 23:31:54 +0200
commite662a135d139be00d9539517df0976318adbdfa1 (patch)
treea3f39f3ad0b653020dbd24f23ca5e32ac86fce3b /testdata/tcl/wherelimit2.test
parent43c865ce5d35eb463e4a05f65e8e388364480711 (diff)
release 1.4.0v1.4.0
Diffstat (limited to 'testdata/tcl/wherelimit2.test')
-rw-r--r--testdata/tcl/wherelimit2.test16
1 files changed, 10 insertions, 6 deletions
diff --git a/testdata/tcl/wherelimit2.test b/testdata/tcl/wherelimit2.test
index 83c04b1..8e39127 100644
--- a/testdata/tcl/wherelimit2.test
+++ b/testdata/tcl/wherelimit2.test
@@ -218,18 +218,22 @@ do_execsql_test 4.1 {
ROLLBACK;
} {3 4 5 6}
-do_catchsql_test 4.2 {
- DELETE FROM x1 INDEXED BY x1bc WHERE d=3 LIMIT 1;
-} {1 {no query solution}}
+# 2020-06-03: Query planner improved so that a solution is possible.
+#
+#do_catchsql_test 4.2 {
+# DELETE FROM x1 INDEXED BY x1bc WHERE d=3 LIMIT 1;
+#} {1 {no query solution}}
do_execsql_test 4.3 {
DELETE FROM x1 INDEXED BY x1bc WHERE b=3 LIMIT 1;
SELECT a FROM x1;
} {1 2 3 4 6}
-do_catchsql_test 4.4 {
- UPDATE x1 INDEXED BY x1bc SET d=5 WHERE d=3 LIMIT 1;
-} {1 {no query solution}}
+# 2020-06-03: Query planner improved so that a solution is possible.
+#
+#do_catchsql_test 4.4 {
+# UPDATE x1 INDEXED BY x1bc SET d=5 WHERE d=3 LIMIT 1;
+#} {1 {no query solution}}
do_execsql_test 4.5 {
UPDATE x1 INDEXED BY x1bc SET d=5 WHERE b=2 LIMIT 1;