Re: [sqlite] SQLITE touches unchanged expression indexes on update

2018-09-15 Thread Richard Hipp
On 9/11/18, Deon Brewis wrote: > It seems like there is an opportunity for improvement on updates if an index > contains expressions. This enhancement did not make the cutoff for 3.25.0. But as 3.25.0 is now out, I have started the next release cycle and you can find this enhancement on the late

Re: [sqlite] Version 3.25.0

2018-09-15 Thread Thomas Kurz
Thank you very much for the ALTER TABLE RENAME COLUMN support. That already helps very much! - Original Message - From: D. Richard Hipp To: sqlite-annou...@mailinglists.sqlite.org Sent: Saturday, September 15, 2018, 20:46:24 Subject: [sqlite-announce] Version 3.25.0 SQLite version 3

Re: [sqlite] [SQLITE]select from a table and use its data to select from another one

2018-09-15 Thread Maziar Parsijani
Hi, Really thanks to all with your complete answers. The best answer is from Keith Medcalf. On Sat, Sep 15, 2018 at 1:45 AM Rob Richardson wrote: > Double quotes can be used to specify that you mean a database object when > the name of the object might be confused with a keyword. For example, m