Re: [sqlite] Failure to rename table in 3.25 and 3.26

2018-12-07 Thread Philip Warner
Cool! Thanks, glad it was not my problem, and glad it was fixed so fast. On 6/12/2018 12:50 AM, Dan Kennedy wrote: On 12/03/2018 10:37 AM, Philip Warner wrote: Tables with complex triggers (possibly limited to "Insert...With", though that is not clear), fail with "no such table".

Re: [sqlite] Failure to rename table in 3.25 and 3.26

2018-12-05 Thread Dan Kennedy
On 12/03/2018 10:37 AM, Philip Warner wrote: Tables with complex triggers (possibly limited to "Insert...With", though that is not clear), fail with "no such table". Thanks for reporting this. The bug was that table and column names within WITH clauses in the schema were not being

[sqlite] Failure to rename table in 3.25 and 3.26

2018-12-02 Thread Philip Warner
Tables with complex triggers (possibly limited to "Insert...With", though that is not clear), fail with "no such table". The following produces the error in 3.26; a much simpler trigger does not produce the error. |Create Table LOG_ENTRY(|| ||    LOG_ENTRY_ID int primary key,|| ||