As for version 3.8.6, when executing: sqlite> explain query plan with a as ( SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 ) select * from a, a a1, a a2, a a3, a a4, a a5, a a6, a a7, a a8, a a9, a a10, a a11, a a12, a a13, a a14, a a15;
I got output: <compound stuff> 0|0|0|SCAN SUBQUERY 1 0|1|1|SCAN SUBQUERY 32 AS a1 0|2|2|SCAN SUBQUERY 63 AS a2 0|3|3|SCAN SUBQUERY 94 AS a3 0|4|4|SCAN SUBQUERY 125 AS a4 0|5|5|SCAN SUBQUERY 156 AS a5 0|6|6|SCAN SUBQUERY 187 AS a6 0|7|7|SCAN SUBQUERY 218 AS a7 0|8|8|SCAN SUBQUERY 249 AS a8 0|9|9|SCAN SUBQUERY 24 AS a9 0|10|10|SCAN SUBQUERY 55 AS a10 0|11|11|SCAN SUBQUERY 86 AS a11 0|12|12|SCAN SUBQUERY 117 AS a12 0|13|13|SCAN SUBQUERY 148 AS a13 0|14|14|SCAN SUBQUERY 179 AS a14 0|15|15|SCAN SUBQUERY 210 AS a15 Which is wrong: every subquery_id after "SCAN SUBQUERY" is displayed mod 256, while displayed normally in other lines, involving subquery_id -- Best regards, Alexander Kass