Petern wrote:
I think your left join reduction regression change happens on any
vtable
hidden column filter reference to an outer scope column. A CTE
duplicates
your finding below...
Hello Peter, from your message I realize that generate_series is no
longer essentiall since SQLite offers CTE's. The query below uses no
extension (and is not relevant for the issue). Hope I did not miss
anything. E. Pasma
WITH
t1(x) AS (VALUES(1),(2)),
t2(x,y) AS (VALUES(1,4)),
rec_serie AS (
SELECT x, y AS value
FROM t1 JOIN t2 USING (x)
UNION ALL
SELECT x, value+1
FROM rec_serie
WHERE value<5
ORDER BY x
)
SELECT * FROM rec_serie
;
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
