View with CTE no longer works
I have recently upgraded my Debian and sqlite3 was automatically upgraded to version 3.36.0. In previous versions this example works:
CREATE TABLE Foobar ( id INTEGER PRIMARY KEY ); INSERT INTO Foobar VALUES (1); -- "Factor" is not yet defined CREATE VIEW FoobarV AS SELECT id*(SELECT * FROM Factor) FROM Foobar; -- But now I define it WITH Factor AS (SELECT 8) SELECT * FROM FoobarV;
But now it doesn't:
Error: near line 9: no such table: main.Factor
Is it a bug?