Re: [sqlite] Table names starting with sqlite (not sqlite_)

2019-04-19 Thread Luuk
On 19-4-2019 20:53, Semih Hazar wrote: The bug was introduced in version 3.25.0. It was due to a LIKE pattern attempting to match against "sqlite_%%" except "_" means "match any single character to to LIKE operator, so we had to go back in and escape that character. The problem is fixed on

Re: [sqlite] Table names starting with sqlite (not sqlite_)

2019-04-19 Thread Semih Hazar
> > > The bug was introduced in version 3.25.0. It was due to a LIKE > pattern attempting to match against "sqlite_%%" except "_" means > "match any single character to to LIKE operator, so we had to go back > in and escape that character. The problem is fixed on trunk. > > You can find the

Re: [sqlite] Table names starting with sqlite (not sqlite_)

2019-04-19 Thread Richard Hipp
On 4/19/19, Luuk wrote: > > On 19-4-2019 16:19, Semih Hazar wrote: >> Hi, >> >> With 3.28.0 I'm getting an inconsistent behavior if I try to rename a >> table >> if its name starts with "sqlite". It's not "sqlite3_" by the way, which >> just gives an error since it's a reserved keyword. >> > >

Re: [sqlite] Table names starting with sqlite (not sqlite_)

2019-04-19 Thread Keith Medcalf
sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Luuk >Sent: Friday, 19 April, 2019 12:11 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Table names starting with sqlite (not sqlite_) > > >On 19-4-2019 16:19, Semih Hazar wrote: >>

Re: [sqlite] Table names starting with sqlite (not sqlite_)

2019-04-19 Thread Luuk
On 19-4-2019 16:19, Semih Hazar wrote: Hi, With 3.28.0 I'm getting an inconsistent behavior if I try to rename a table if its name starts with "sqlite". It's not "sqlite3_" by the way, which just gives an error since it's a reserved keyword. After renaming, .table command shows the new name,

[sqlite] Table names starting with sqlite (not sqlite_)

2019-04-19 Thread Semih Hazar
Hi, With 3.28.0 I'm getting an inconsistent behavior if I try to rename a table if its name starts with "sqlite". It's not "sqlite3_" by the way, which just gives an error since it's a reserved keyword. After renaming, .table command shows the new name, but a select from the table errors out. If