summaryrefslogtreecommitdiffstats
path: root/test/join5.test
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-16 17:30:13 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-04-16 17:30:13 +0000
commit5e33abd9c783fe2b9deae602544f1f6f0889958a (patch)
tree120f37dcc1339c59c97cd336badef4633015ec23 /test/join5.test
parentAdding upstream version 3.45.2. (diff)
downloadsqlite3-5e33abd9c783fe2b9deae602544f1f6f0889958a.tar.xz
sqlite3-5e33abd9c783fe2b9deae602544f1f6f0889958a.zip
Adding upstream version 3.45.3.upstream/3.45.3
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'test/join5.test')
-rw-r--r--test/join5.test8
1 files changed, 6 insertions, 2 deletions
diff --git a/test/join5.test b/test/join5.test
index 44c8b71..703c256 100644
--- a/test/join5.test
+++ b/test/join5.test
@@ -370,8 +370,12 @@ do_execsql_test 9.1 {
ANALYZE sqlite_schema;
INSERT INTO sqlite_stat1 VALUES('t1','t1x1','648 324 81 81 81 81 81 81 81081 81 81 81');
ANALYZE sqlite_schema;
- SELECT a FROM (SELECT a FROM t1 NATURAL LEFT JOIN t1) NATURAL LEFT JOIN t1 WHERE (rowid,1)<=(5,0);
-} {1}
+}
+do_catchsql_test 9.2 {
+ SELECT a FROM
+ (SELECT a FROM t1 NATURAL LEFT JOIN t1) NATURAL LEFT JOIN t1
+ WHERE (rowid,1)<=(5,0);
+} {0 1}
# 2022-03-02 https://sqlite.org/forum/info/50a1bbe08ce4c29c
# Bloom-filter pulldown is incompatible with skip-scan.