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

[sqlite] Something broke between version 3.15 and 3.19.3

2017-06-10 Thread Balaji Ramanathan
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 summary view of my data. The views combined in this summary view contain about