Re: [sqlite] Documentation update

On 30 Jan 2018, at 6:51pm, William Entriken wrote: > Hello. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.3. > Perhaps this should be > >> 8.3. I/O error while obtaining a lock leads to corruption Can you clarify your correction ? I don't see a difference.

Re: [sqlite] Documentation update

On 31 Jan 2018, at 1:11pm, Kees Nuyt wrote: > On Wed, 31 Jan 2018 13:07:17 +, Simon Slavin > wrote: >> >> Can you clarify your correction ? I don't see a difference. > > It used to be: > 8.3. I/O while obtaining a lock leads to corruption > > (the

Re: [sqlite] Documentation update

On Wed, 31 Jan 2018 13:07:17 +, Simon Slavin wrote: > > >On 30 Jan 2018, at 6:51pm, William Entriken wrote: > >> Hello. Regarding https://www.sqlite.org/howtocorrupt.html, item 8.3. >> Perhaps this should be >> >>> 8.3. I/O error while obtaining

Re: [sqlite] missing subquery flattening

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; --

Re: [sqlite] Documentation update

On 2018/01/31 3:13 PM, Simon Slavin wrote: I see. It has already been fixed. Sorry for the niggle. Simon. It's hard to stay on top of an error in the SQLite universe They disappear so darn quick. ___ sqlite-users mailing list

[sqlite] @sqlite-tool-maintainers Table Name Information?

I would think as output for a GUI for browsing sqlite databases, knowing table name is useful. But what if the SQL command given contains an alias of the table name as in a table that is self-joined? Wouldn't it also be useful to be able to get that alias? And in face default to Alias and show

Re: [sqlite] Documentation update 2

Thank YOU. Fix looks good now. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users