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.
