That was a good hint, I realized that my data structure is not optimized.. I am using a JAVA application and the tables are automatically created on startup. Therefore I never looked for the whole TEST CASE..The datatype Character (JAVA) is mapped to CHARACTER(255) and it is filled by blanks. Maybe this could be a temporary fix for my solution to make it to CHARACTER(1).... But the same code worked with h2 in version 1.x....
CREATE TABLE TEST (ID BIGINT, SOMEVALUE CHARACTER(255)); INSERT INTO TEST (ID, SOMEVALUE) VALUES(1, 'Y'); SELECT * FROM TEST WHERE LOWER(SOMEVALUE) = 'y'; delivers empty result but SELECT * FROM TEST WHERE SOMEVALUE = 'Y'; is fine.. is the function LOWER attended to recognize blanks? Evgenij Ryazanov schrieb am Montag, 4. Juli 2022 um 12:44:56 UTC+2: > Hello! > > You need to provide a complete test case. Something like > > CREATE TABLE XXX(XYZ VARCHAR(100), …); > INSERT INTO XXX(XYZ, …) VALUES (…); > SELECT * FROM XXX WHERE LOWER(XYZ) = 'somevalue'; > -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/3f2d8c39-ac74-4d45-ab57-64d0db88e0a7n%40googlegroups.com.
