Version 1.3.174.
Change of COLLATION influences how strings are checked for equality.
SET COLLATION en STRENGTH PRIMARY;
CREATE TABLE TBL_IGN_CASE ( STR VARCHAR(100) PRIMARY KEY );
INSERT INTO TBL_IGN_CASE ( STR ) VALUES ('E-12345');
INSERT INTO TBL_IGN_CASE ( STR ) VALUES ('E12345');
> Unique index or primary key violation: "PRIMARY_KEY_4 ON
PUBLIC.TBL_IGN_CASE(STR) VALUES ( /* 2 */ CAST('E12345' AS
VARCHAR_IGNORECASE) )"; SQL statement:
INSERT INTO TBL_IGN_CASE ( STR ) VALUES ('E12345') [23505-174] 23505/23505
Such query ` SELECT true FROM TBL_IGN_CASE WHERE 'E-12345' = 'E12345' `
returns `true`.
Is it expected behaviour?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
