Re: [sqlite] possible ordering issue since 3.7.15

2013-04-15 Thread kenichi ishigaki
Thank you for clarification. I'll forward this to the original reporter and add a note about this to our library. Regards, Kenichi Ishigaki 2013/4/14 Jay A. Kreibich : > On Sat, Apr 13, 2013 at 11:25:41PM +0700, Dan Kennedy scratched on the wall: >> On 04/13/2013 11:22 PM,

Re: [sqlite] possible ordering issue since 3.7.15

2013-04-13 Thread Jay A. Kreibich
On Sat, Apr 13, 2013 at 11:25:41PM +0700, Dan Kennedy scratched on the wall: > On 04/13/2013 11:22 PM, kenichi ishigaki wrote: > >Hi. > > > >I received a report that the result of the following SQL has changed > >since 3.7.15. > >I haven't looked into the sqlite source yet, but can we call this a

Re: [sqlite] possible ordering issue since 3.7.15

2013-04-13 Thread Walter Hurry
On Sun, 14 Apr 2013 01:22:46 +0900, kenichi ishigaki wrote: > Hi. > > I received a report that the result of the following SQL has changed > since 3.7.15. > I haven't looked into the sqlite source yet, but can we call this a bug? > > Regards, > > Kenichi Ishigaki > > - > create table cd

Re: [sqlite] possible ordering issue since 3.7.15

2013-04-13 Thread Dan Kennedy
On 04/13/2013 11:22 PM, kenichi ishigaki wrote: Hi. I received a report that the result of the following SQL has changed since 3.7.15. I haven't looked into the sqlite source yet, but can we call this a bug? No. No "ORDER BY" clause means that the results are delivered in an undefined order.

[sqlite] possible ordering issue since 3.7.15

2013-04-13 Thread kenichi ishigaki
Hi. I received a report that the result of the following SQL has changed since 3.7.15. I haven't looked into the sqlite source yet, but can we call this a bug? Regards, Kenichi Ishigaki - create table cd (id integer primary key, title unique, year); insert into cd (title, year) values