Hi all,
I have a table with respective values :
create table testCaseIn (colNum int, colDec decimal);
insert into testCaseIn (colNum, colDec) values (1,-1.00);
insert into testCaseIn (colNum, colDec) values (2,0.10);
insert into testCaseIn (colNum, colDec) values (3,10.00);
Ran these statements and got the results :
#1 : Single value in the IN function
select * from testCaseIn where colDec in (0.1);
==> result : (2,0.1)
#2 : More than 1 value in the IN function
select * from testCaseIn where colDec in (0.1, -1);
==> result : none
==> expected result : (2,0.1), (1,-1)
#3 : Single where condition
select * from testCaseIn where colDec = 0.1;
==> result : (2,0.1)
#4 : OR condition
select * from testCaseIn where colDec = 0.1 or colDec = 10;
==> result : none
==> expected result : (2,0.1), (3,10)
Doesn't seem like anything with more than 1 value in the IN function nor
the OR condition works. Kindly advise. Thanks!
--
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/d/optout.
