Re: [sqlite] View is not flattened when inside an IN sub-query

On 11/18/17, E.Pasma wrote: > I found that in the > SQLite3 timeline Thanks for watching the timeline! -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] View is not flattened when inside an IN sub-query

Thanks very much for finding this worth a change. I found that in the SQLite3 timeline and I tested the change. As written in an other topic: .. Just sit tight and again wait and see if Dr Hipp agrees the behavior should change or not. It is comforting that this is even true for an

[sqlite] View is not flattened when inside an IN sub-query (incl complete sql)

Hello, below are two equivalent delete statements. The difference is that the second version uses views, actually sub-queries, on the base tables. These are simple one to one views that could be flattened out, as in http://www.sqlite.org/optoverview.html#flattening The second query plan

[sqlite] View is not flattened when inside an IN sub-query

Hello, below are two equivalent delete statements. The difference is that the second version uses views, actually sub-queries, on the base tables. These are simple one to one views that could be flattened out, as in http://www.sqlite.org/optoverview.html#flattening The second query plan