> I am unable to reproduce this problem. Using the script below, with > RMNOCASE changed to just NOCASE
Probably that's exactly the point of crash in the OP's test case. He created table when RMNOCASE collation existed but then tries to execute query when that collation is not registered and unknown. Pavel On Thu, Jan 21, 2010 at 9:30 AM, D. Richard Hipp <d...@hwaci.com> wrote: > 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
