aboutsummaryrefslogtreecommitdiff
path: root/test/join2.test
diff options
context:
space:
mode:
authordrh <>2022-04-16 23:38:29 +0000
committerdrh <>2022-04-16 23:38:29 +0000
commit6fda176ba61b0a37ca70ec9fdf3ed9e80732ab8c (patch)
treed8ade2676f9534ca2685b49335eebcf31b7675ee /test/join2.test
parent052953a4e601dc19166d0d8a66873198497f65cf (diff)
downloadsqlite-6fda176ba61b0a37ca70ec9fdf3ed9e80732ab8c.tar.gz
sqlite-6fda176ba61b0a37ca70ec9fdf3ed9e80732ab8c.zip
New test cases, one of which is failing, indicating a bug that needs fixing.
FossilOrigin-Name: bd5fd68435ff068c18d7d46b33cf7591263a03c32a917a7df7c087b08c573cc8
Diffstat (limited to 'test/join2.test')
-rw-r--r--test/join2.test6
1 files changed, 3 insertions, 3 deletions
diff --git a/test/join2.test b/test/join2.test
index 4142fd15b..e549c4934 100644
--- a/test/join2.test
+++ b/test/join2.test
@@ -78,10 +78,10 @@ ifcapable subquery {
} {1 11 111 1111 2 22 {} {} 3 33 {} {}}
do_test join2-1.7-rj {
execsql {
- SELECT * FROM
- (t2 NATURAL JOIN t3) NATURAL RIGHT JOIN t1
+ SELECT a, b, c, d FROM
+ t2 NATURAL JOIN t3 NATURAL RIGHT JOIN t1
}
- } {11 111 1111 1 {} {} {} 2 {} {} {} 3}
+ } {1 11 111 1111 2 22 {} {} 3 33 {} {}}
}
#-------------------------------------------------------------------------