SQLite Forum

Here are the query plans:

```
SQLite 3.35.5 2021-04-19 18:32:05 1b256d97b553a9611efca188a3d995a2fff712759044ba480f9a0c9e98fae886
clang-12.0.5
QUERY PLAN
`--COMPOUND QUERY
   |--LEFT-MOST SUBQUERY
   |  |--MATERIALIZE 1
   |  |  `--SCAN CONSTANT ROW
   |  |--MATERIALIZE 2
   |  |  `--SCAN CONSTANT ROW
   |  |--SCAN SUBQUERY 1
   |  |--SCAN SUBQUERY 2
   |  `--SCAN SUBQUERY 2
   `--UNION ALL
      |--SCAN SUBQUERY 1
      |--SCAN SUBQUERY 2
      `--SCAN SUBQUERY 2
done
SQLite 3.32.3 2020-06-18 14:16:19 02c344aceaea0d177dd42e62c8541e3cab4a26c757ba33b3a31a43ccc7d4aapl
clang-12.0.5
QUERY PLAN
|--MATERIALIZE 1
|  `--SCAN CONSTANT ROW
|--MATERIALIZE 2
|  `--SCAN CONSTANT ROW
|--MATERIALIZE 4
|  `--COMPOUND QUERY
|     |--LEFT-MOST SUBQUERY
|     |  |--CO-ROUTINE 2
|     |  |  `--SCAN CONSTANT ROW
|     |  `--SCAN SUBQUERY 2
|     `--UNION ALL
|        |--CO-ROUTINE 2
|        |  `--SCAN CONSTANT ROW
|        `--SCAN SUBQUERY 2
|--SCAN SUBQUERY 1
|--SCAN SUBQUERY 2
`--SCAN SUBQUERY 4
done
```

Looks like the compound query is in the wrong place.