aboutsummaryrefslogtreecommitdiff
path: root/test/join5.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/join5.test')
-rw-r--r--test/join5.test13
1 files changed, 7 insertions, 6 deletions
diff --git a/test/join5.test b/test/join5.test
index 12fe56cb9..043c626d4 100644
--- a/test/join5.test
+++ b/test/join5.test
@@ -264,9 +264,10 @@ do_eqp_test 7.2 {
t2.x = t1.x AND (t2.y=? OR (t2.y=? AND t2.z IS NOT NULL))
);
} {
- 0 0 0 {SCAN TABLE t1}
- 0 1 1 {SEARCH TABLE t2 USING INDEX t2xy (x=? AND y=?)}
- 0 1 1 {SEARCH TABLE t2 USING INDEX t2xy (x=? AND y=?)}
+ QUERY PLAN
+ |--SCAN TABLE t1
+ |--SEARCH TABLE t2 USING INDEX t2xy (x=? AND y=?)
+ `--SEARCH TABLE t2 USING INDEX t2xy (x=? AND y=?)
}
do_execsql_test 7.3 {
@@ -285,9 +286,9 @@ do_execsql_test 7.3 {
do_eqp_test 7.4 {
SELECT * FROM t3 LEFT JOIN t4 ON (t4.x = t3.x) WHERE (t4.y = ? OR t4.z = ?);
} {
- 0 0 0 {SCAN TABLE t3}
- 0 1 1 {SEARCH TABLE t4 USING INDEX t4xz (x=?)}
+ QUERY PLAN
+ |--SCAN TABLE t3
+ `--SEARCH TABLE t4 USING INDEX t4xz (x=?)
}
finish_test
-