[sqlite] SQL Crash with sqlite 3.6.22 commandline

[Hub Dog]

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