aboutsummaryrefslogtreecommitdiff
path: root/test/selectA.test
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2018-05-02 18:00:17 +0000
committerdrh <drh@noemail.net>2018-05-02 18:00:17 +0000
commitb3f0276b9e4fd6465aaefa6e527d3f7a19a59b8c (patch)
treec9f50dc49d86bbddef84d7e52539152f908e1b4c /test/selectA.test
parent84a01debf9cd527e422d4bc3cbd0149b8a3b9e34 (diff)
downloadsqlite-b3f0276b9e4fd6465aaefa6e527d3f7a19a59b8c.tar.gz
sqlite-b3f0276b9e4fd6465aaefa6e527d3f7a19a59b8c.zip
Fix test cases so that they work with the new EXPLAIN QUERY PLAN output
format. Only some of the cases have been fixed. This is an incremental check-in. FossilOrigin-Name: 5f0e803e33aa557865d5fc830d9202d628de9a94c9757058ca48f1a560702cd3
Diffstat (limited to 'test/selectA.test')
-rw-r--r--test/selectA.test13
1 files changed, 8 insertions, 5 deletions
diff --git a/test/selectA.test b/test/selectA.test
index 78d04be15..838e5f432 100644
--- a/test/selectA.test
+++ b/test/selectA.test
@@ -1336,11 +1336,14 @@ do_eqp_test 4.1.2 {
SELECT a, b FROM t4 WHERE f()==f()
ORDER BY 1,2
} {
- 1 0 0 {SCAN TABLE t5 USING INDEX i2}
- 1 0 0 {USE TEMP B-TREE FOR RIGHT PART OF ORDER BY}
- 2 0 0 {SCAN TABLE t4 USING INDEX i1}
- 2 0 0 {USE TEMP B-TREE FOR RIGHT PART OF ORDER BY}
- 0 0 0 {COMPOUND SUBQUERIES 1 AND 2 (UNION ALL)}
+ QUERY PLAN
+ `--MERGE (UNION ALL)
+ |--LEFT
+ | |--SCAN TABLE t5 USING INDEX i2
+ | `--USE TEMP B-TREE FOR RIGHT PART OF ORDER BY
+ `--RIGHT
+ |--SCAN TABLE t4 USING INDEX i1
+ `--USE TEMP B-TREE FOR RIGHT PART OF ORDER BY
}
do_execsql_test 4.1.3 {