Re: [sqlite] regression since 3.20.0

2018-01-27 Thread Kenichi Ishigaki
2018-01-27 22:59 GMT+09:00 Richard Hipp : > On 1/26/18, Kenichi Ishigaki wrote: >> Hi, >> >> I've got a regression report from a DBIx::Class perl module maintainer >> that recent SQLite (3.20.0 and onward) returns a different result from >> the previous versions. > > Thanks for the bug report. No

Re: [sqlite] regression since 3.20.0

2018-01-27 Thread Richard Hipp
On 1/26/18, Kenichi Ishigaki wrote: > Hi, > > I've got a regression report from a DBIx::Class perl module maintainer > that recent SQLite (3.20.0 and onward) returns a different result from > the previous versions. Thanks for the bug report. Now fixed on trunk The ticket: https://www.sqlite.org

Re: [sqlite] regression since 3.20.0

2018-01-26 Thread petern
Confirmed. 3.22 build with -DSQLITE_ENABLE_STAT4 remarkably produces the other answer: cdid 1 4 5 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] regression since 3.20.0

2018-01-26 Thread Richard Hipp
On 1/26/18, petern wrote: > Kenichi. Nice report. I pasted your code into my console and do see the > correct output you expected: > > cdid > 4 > 5 You have to build with -DSQLITE_ENABLE_STAT4, apparently. > > sqlite> .version > SQLite 3.22.0 2018-01-22 18:45:57 > 0c55d179733b46d8d0ba4d88e01a25

Re: [sqlite] regression since 3.20.0

2018-01-26 Thread petern
Kenichi. Nice report. I pasted your code into my console and do see the correct output you expected: cdid 4 5 sqlite> .version SQLite 3.22.0 2018-01-22 18:45:57 0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1 zlib version 1.2.8 gcc-4.8.4 Maybe others can try it on their console

[sqlite] regression since 3.20.0

2018-01-26 Thread Kenichi Ishigaki
Hi, I've got a regression report from a DBIx::Class perl module maintainer that recent SQLite (3.20.0 and onward) returns a different result from the previous versions. https://rt.cpan.org/Public/Bug/Display.html?id=124227 Condition: CREATE TABLE cd ( cdid INTEGER PRIMARY KEY NOT NULL, genreid