Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-12 Thread Balaji Ramanathan
I am glad you were able to fix it quickly. I assume the next version of SQLite (3.19.4 or 3.20 or whatever) will include the fix? Thank you. Balaji Ramanathan On 6/11/17, Balaji Ramanathan wrote: > > Everything was working fine under 3.15. I just use the

Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-12 Thread Balaji Ramanathan
Thank you very much, Simon. I was able to downgrade to 3.18 using your instructions and everything seems to work now. Balaji Ramanathan On 11 Jun 2017, at 2:56pm, Balaji Ramanathan wrote: > This is going to sound stupid, but I would like to know how to > download

Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-11 Thread Richard Hipp
On 6/11/17, Balaji Ramanathan wrote: > > Everything was working fine under 3.15. I just use the commandline > tool (sqlite.exe) to interact with my database. I am not a programmer and > don't have a need for programmatic access to this database. I recently >

Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-11 Thread Simon Slavin
On 11 Jun 2017, at 2:56pm, Balaji Ramanathan wrote: > This is going to sound stupid, but I would like to know how to > download older versions of sqlite. Although the download page gives links only for the current version of SQLite, several older versions are

Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-11 Thread Balaji Ramanathan
Thank you very much, Dr. Hipp. I am glad I was not imagining a problem that nobody else could reproduce. If you need any additional details or if you can think of any other way I can help with the investigation, please let me know. Balaji Ramanathan PS: This is going to sound stupid, but I

Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-11 Thread Bart Smissaert
explain query plan select * from TripDetails Causes problems as well. RBS On Sun, Jun 11, 2017 at 5:27 AM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: > Hi, > > I maintain a personal database on sqlite. It is quite small, with > about 30 tables, and an equal number of views.

Re: [sqlite] Something broke between version 3.15 and 3.19.3

2017-06-10 Thread Richard Hipp
On 6/11/17, Balaji Ramanathan wrote: > Hi, > > I maintain a personal database on sqlite. It is quite small, with > about 30 tables, and an equal number of views. One of these views is an > inner join of the contents of about 15 of these views, producing a