/ Ticket Change Details
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference
Overview

Artifact ID: 81eff856130d83cc737fbfa1bc737154e9c26bc07ae52fb8a31141e203b8d6e4
Ticket: ce8717f0885af975dbdce9cedb342d5822901a12
LIKE malfunctions for UNIQUE COLLATE NOCASE column
User & Date: mrigger 2019-06-14 10:01:47
Changes

  1. Change icomment to:

    Consider this example:

    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
    

    Although the LIKE expression should yield 1 (see below), no row is fetched:

    SELECT t0.c0 LIKE '.1%' FROM t0; -- 1
    

    It seems that this problem only applies to COLLATE NOCASE as well as to numeric columns (INT, REAL, and NUMERIC).

  2. Change login to "mrigger"
  3. Change mimetype to "text/x-fossil-wiki"
  4. Change severity to "Critical"
  5. Change status to "Open"
  6. Change title to "LIKE malfunctions for UNIQUE COLLATE NOCASE column"
  7. Change type to "Code_Defect"