Hi, I finally found and fix the problem, will commit it soon.
Regards, Thomas On Wednesday, July 1, 2015, Thomas Mueller <[email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','[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]. >> 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. >> > -- 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.
