Mark Brand wrote:
On 26/01/18 19:35, Clemens Ladisch wrote:
Mark Brand wrote:
Shouldn't we expect subquery flattening to happen in V2 below?
-- no flattening
CREATE VIEW V2 AS
SELECT * FROM X
LEFT JOIN (
SELECT * FROM X
LEFT JOIN Y ON Y.a = X.a
) Z
ON Z.a =
On 26/01/18 19:35, Clemens Ladisch wrote:
Mark Brand wrote:
Shouldn't we expect subquery flattening to happen in V2 below?
-- no flattening
CREATE VIEW V2 AS
SELECT * FROM X
LEFT JOIN (
SELECT * FROM X
LEFT JOIN Y ON Y.a = X.a
) Z
ON Z.a = X.a;
--
Mark Brand wrote:
> Shouldn't we expect subquery flattening to happen in V2 below?
>
> -- no flattening
> CREATE VIEW V2 AS
> SELECT * FROM X
> LEFT JOIN (
> SELECT * FROM X
> LEFT JOIN Y ON Y.a = X.a
> ) Z
> ON Z.a = X.a;
>
> -- manually flattened version of V2
>
Hi,
Shouldn't we expect subquery flattening to happen in V2 below?
Mark
CREATE TABLE X ( a PRIMARY KEY, b ) WITHOUT ROWID;
CREATE TABLE Y ( a PRIMARY KEY ) WITHOUT ROWID;
/*
WITH RECURSIVE Q AS (
SELECT 1 a
UNION ALL SELECT a + 1 FROM Q
WHERE a < 10
)
INSERT INTO X (a, b)
4 matches
Mail list logo