Hi,
i think we just found a bug in releases 1.2.122 / 1.2.124,
respectively. 1.1.118 is working fine.
I couldn't find any specific bugtracking software so i'll just post
here.
Data conversion error converting "'abc' (ID INT NOT NULL)"
To reproduce, create table:
CREATE TABLE test1 (
ID INT PRIMARY KEY,
NAME VARCHAR(255),
SOMESTRING VARCHAR(255),
SOMENUMBER INT
);
INSERT INTO test1 VALUES(1, 'Hello World1', 'Some String', 212);
INSERT INTO test1 VALUES(2, 'Abc', 'Some String', 212);
INSERT INTO test1 VALUES(3, 'DEF', 'Some String', 212);
INSERT INTO test1 VALUES(4, 'Lalilu', 'Some String', 212);
INSERT INTO test1 VALUES(5, 'Wo drückt der Schuh', 'Some String',
212);
INSERT INTO test1 VALUES(6, 'lilakuh', 'Some String', 212);
and execute
SELECT * FROM (SELECT * FROM TEST1) WHERE (( ID >= 1 AND ID <= 500))
AND (( NAME IN ('abc', 'lalilu', 'lilakuh'))) LIMIT 50;
Sincerly yours,
Thorsten J. Krause
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
