Hi,
Thanks for your help! I found the problem. It will be fixed in the next release:
Statements with IN(..) conditions can produce the wrong result or a
data conversion error (since version 1.2.120). Examples: index on id,
name, condition: id=1 and name in('Hello', 'x'); index on id, query:
select * from (select * from test) where id=1 and name in('Hello',
'World').
Regards,
Thomas
On Mon, Nov 30, 2009 at 5:35 PM, Thorsten J. Krause <[email protected]> wrote:
> 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.
>
>
>
--
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.
