I originally experienced the problem using a couple of Windows sqlite managers. It seems that ones using the latest few versions of sqlite have the problem, variously reported as: "Access violation at address xxxxxxxxx in module xxxxxxxx. Read of address 00000005", where x is dependent on the application. Of the three that I tested that had this crash, two reported it thusly, one threw up an unhandled Win32 exception and croaked - they are all, I believe using 3.6.21 or 22.
Running the sqlite.exe command line version 3.6.22 throws up the unhandled Win32 exception. Running the 3.6.17 release gracefully reports "SQL error near line 1: no such collation sequence: RMNOCASE". The errors and crashes are from the following query: SELECT Name COLLATE NOCASE FROM AddressTable WHERE Name LIKE '%_'; This revised query works on all versions listed above: SELECT Name COLLATE NOCASE AS NewName FROM AddressTable WHERE NewName LIKE '%_' ; as does: SELECT Name FROM AddressTable WHERE Name COLLATE NOCASE LIKE '%_'; I can forward you a sample database but I do not have access to the RMNOCASE collation. 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