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 <[email protected]> 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" <[email protected]> wrote in > message news:[email protected]... > >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 > >> [email protected] > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > D. Richard Hipp > > [email protected] > > > > > > > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
