Test-statement:
--EXPLAIN --ANALYZE
SELECT * FROM (
--Test dataset--------
SELECT * FROM VALUES(1)
UNION ALL
SELECT * FROM VALUES(2)
UNION ALL
SELECT * FROM VALUES(5)
-----------------------
) WHERE C1 > SOME (
SELECT C1 FROM (
--Test dataset---------
SELECT C1 FROM VALUES(1)
UNION ALL
SELECT C1 FROM VALUES(2)
UNION ALL
SELECT C1 FROM VALUES(5)
-----------------------
) WHERE C1 > 1
)
Result-set: C1(5). That is right: C(1,2,5) > SOME C(2,5)
Result-set of this statement after EXPLAIN: C1(2,5). This corresponds to
C(1,2,5) >= SOME C(2,5)
Library: h2-1.3.170.jar
Is this bug?
--
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/groups/opt_out.
