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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.