Re: [sqlite] operation unexpectedly applied to both main and temp?

An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [sqlite] operation unexpectedly applied to both main and temp? I find the .explain/explain functionality very helpful in clearing up what happens and why. Note the error when creating main.t. Note the database nu

Re: [sqlite] operation unexpectedly applied to both main and temp?

lto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Mark Brand Gesendet: Mittwoch, 29. März 2017 02:55 An: sqlite-users@mailinglists.sqlite.org Betreff: Re: [sqlite] operation unexpectedly applied to both main and temp? On 29/03/17 02:38, Simon Slavin wrote: > On 29 Mar 2017, at

Re: [sqlite] operation unexpectedly applied to both main and temp?

On 29/03/17 02:38, Simon Slavin wrote: On 29 Mar 2017, at 1:34am, Domingo Alvarez Duarte wrote: It seems sqlite look first if there is a temp.table before main.table and without qualification temp.table is used. You got it. It’s not obvious that this is what SQLite