Overview
Artifact ID: | 81eff856130d83cc737fbfa1bc737154e9c26bc07ae52fb8a31141e203b8d6e4 |
---|---|
Ticket: | ce8717f0885af975dbdce9cedb342d5822901a12
LIKE malfunctions for UNIQUE COLLATE NOCASE column |
User & Date: | mrigger 2019-06-14 10:01:47 |
Changes
- icomment:
Consider this example: <pre> CREATE TABLE t0(c0 INT UNIQUE COLLATE NOCASE); INSERT INTO t0(c0) VALUES ('.1%'); SELECT * FROM t0 WHERE t0.c0 LIKE '.1%'; -- expected: '.1%', actual: no row is fetched </pre> Although the LIKE expression should yield 1 (see below), no row is fetched: <pre> SELECT t0.c0 LIKE '.1%' FROM t0; -- 1 </pre> It seems that this problem only applies to COLLATE NOCASE as well as to numeric columns (INT, REAL, and NUMERIC).
- login: "mrigger"
- mimetype: "text/x-fossil-wiki"
- severity changed to: "Critical"
- status changed to: "Open"
- title changed to: "LIKE malfunctions for UNIQUE COLLATE NOCASE column"
- type changed to: "Code_Defect"