That's completely right. The datastructure is not defined on my own.. It is
Spring Boots hibernate / jpa which is defining the datastructure for my
unit tests... BUT: I cannot understand why the same query is working
without the LOWER() function.
CREATE TABLE TEST (ID BIGINT, SOMEVALUE CHARACT
That's completely right. The datastructure is not defined on my own.. It is
Spring Boots hibernate / jpa which is defining the datastructure for my
unit tests... BUT: I cannot understand why the same query is working
without the LOWER() function.
CREATE TABLE TEST (ID BIGINT, SOMEVALUE CHARACT
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.
M
Hi together,
do yo also have the problem that the lower function delivers empty results
though it should return results? I am using h2 in version 2.1.214 as an
in-memory database with my spring boot application and since the upgrade
from v1.x to 2.x the lower function does not work as expected.
Hello all together,
I am using h2 in my spring boot application as an in-memory database. I am
using it now in version 2.1.214 and the lower function is nor working as
expected. Since the upgrade from version 1.x simple queries like "SELECT *
FROM ... WHERE LOWER(...) = 'xx' delivery empty resu