Hi, I don't know yet what the problem could be, but I have a slightly simpler test case:
drop table test; create table test(id int); insert into test values(1); select * from test where id in (select id from test); select * from test where id in (select id from test order by null); In theory, "order by" should have no effect here (the database would still be free to return the rows in any order). But of course it should work (the last two queries should return the same result). Regards, Thomas On Wednesday, July 1, 2015, Quentin Farizon <[email protected]> wrote: > Hello, > > I have a certain query that is working in H2 1.3.173 but not in H2 1.4.187. > > Here is the test case (it is part of a bigger use case, it's normal that > these queries don't necessarily make sense functionally) : > > CREATE TABLE MY_TABLE (MY_DOUBLE DOUBLE); > INSERT INTO MY_TABLE VALUES (1.0); > INSERT INTO MY_TABLE VALUES (2.0); > INSERT INTO MY_TABLE VALUES (3.0); > INSERT INTO MY_TABLE VALUES (4.0); > > // Works in 1.3 and 1.4, returns values randomly ordered > SELECT MY_DOUBLE FROM MY_TABLE ORDER BY RAND(); > > // Works in 1.3 and 1.4, returns values > SELECT * FROM MY_TABLE WHERE MY_DOUBLE IN (SELECT MY_DOUBLE FROM MY_TABLE); > > // In 1.3, it returns all values, in 1.4 it returns nothing > SELECT * FROM MY_TABLE WHERE MY_DOUBLE IN (SELECT MY_DOUBLE FROM MY_TABLE > ORDER BY RAND()); > > Do you have an idea concerning this issue ? > > Best regards, > Quentin > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
