Can you verify that changes for ticket http://www.sqlite.org/src/info/1258875e07 checked-in yesterday resolve your issue?
Thanks. -Shane On Fri, Jan 22, 2010 at 9:51 AM, ve3meo <holden_fam...@sympatico.ca> wrote: > I just discovered that attachments can be sent through this newsgroup so I > have attached a small database with which you should be able to reproduce > the problem. The one table in it has a field collated RMNOCASE. The > following query produces these results in three different versions of > sqlite: > > 3.5.4 works perfectly > 3.6.17 gracefully reports an error - missing RMNOCASE collation > 3.6.21 crash > > SELECT > Name COLLATE NOCASE > FROM > AddressTable > WHERE > Name LIKE '%_'; > > 3.5.4 carried the COLLATE NOCASE override at the beginning of the SELECT > through to the comparison in the WHEN. The later ones do not, and they > 'progress' from reporting an error to a crash. > > This regression renders queries, on databases having collations unavailable > to the sqlite in use, that were developed on older versions of sqlite > problematic when run from newer versions. > > Regards, > Tom > > "D. Richard Hipp" <d...@hwaci.com> wrote in > message news:41371dfd-279f-429d-9186-476efb63e...@hwaci.com... > >I am unable to reproduce this problem. Using the script below, with > > RMNOCASE changed to just NOCASE, everything works fine on the SQLite > > command-line shell on the website on Linux. I also tried various > > other versions of SQLite with the same result. > > > > > > On Jan 21, 2010, at 8:00 AM, Hub Dog wrote: > > > >> I hava a table. The table schema is > >> > >> CREATE TABLE AddressTable > >> ( > >> AddressID INTEGER PRIMARY KEY , > >> AddressType INTEGER , > >> Name TEXT COLLATE RMNOCASE , > >> Street1 TEXT , > >> Street2 TEXT , > >> City TEXT , > >> State TEXT , > >> Zip TEXT , > >> Country TEXT , > >> Phone1 TEXT , > >> Phone2 TEXT , > >> Fax TEXT , > >> Email TEXT , > >> URL TEXT , > >> Latitude INTEGER , > >> Longitude INTEGER , > >> Note BLOB > >> ) ;. > >> > >> if I execute following sql to query data , the sqlite 3.6.22 command > >> line > >> downloaded from www.sqlite.org will crash. > >> > >> SELECT > >> Adr.Name COLLATE NOCASE AS AddressName > >> FROM > >> AddressTable AS Adr > >> WHERE > >> Adr.Name LIKE '%_'. > >> > >> if I change the Adr.Name to AddressName , the sql execute result is > >> ok. > >> > >> SELECT > >> Adr.Name COLLATE NOCASE AS AddressName > >> FROM > >> AddressTable AS Adr > >> WHERE > >> AddressName LIKE '%_' ; > >> > >> it seems the crash was related with the collate RMNOCASE of > >> AddressTable > >> table's field Name. > >> in default sqlite command line, there is no rmnocase collation. so I > >> mapped > >> it to the default nocase collation. > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > D. Richard Hipp > > d...@hwaci.com > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users