Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

That's great! I'm an end-user and cannot compile it to check myself. Thanks to shane, drh, Hub Dog for the rapid fix. I will have to dig around to figure out how/when that shows up in a release. That leaves the question about the change of syntax between 3.5.4 and 3.6.17. In the earlier it was

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

I can confirm that the crash problem has been fixed by http://www.sqlite.org/src/info/1258875e07 checked-in . Now executing following sql will report no such collation sequence: RMNOCASE instead of crash. SELECT Surname || ', ' || Given COLLATE NOCASE AS Person , Adr.Name COLLATE NOCASE AS

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

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 wrote: > I just discovered that attachments can be sent through this newsgroup so I >

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

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:

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

and a crash by 3.6.21. Tom - Original Message - From: "Pavel Ivanov" <paiva...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Thursday, January 21, 2010 9:36 AM Subject: Re: [sqlite] SQL Crash with sqlite 3.

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

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 x in module . Read of address 0005", where x is dependent on the

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

> 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

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

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

[sqlite] SQL Crash with sqlite 3.6.22 commandline

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 ,