[h2] Very slow execution with subquery and connection parameter LAZY_QUERY_EXECUTION=1

[Pavel]

The example below runs less than a second. If I change connection parameter to 
LAZY_QUERY_EXECUTION=1 then it takes forever.


I tested with both 1.4.196 and 1.4.197. The same result.


@Test
public void subquery() throws Exception {
    Class.forName("org.h2.Driver");
    try (Connection conn = 
DriverManager.getConnection("jdbc:h2:mem:;LAZY_QUERY_EXECUTION=0")) {
        try (Statement stat = conn.createStatement()) {
            final int ROWS = 100000;
            stat.execute("CREATE TABLE ONE(X INTEGER , Y INTEGER )");
            try (PreparedStatement prep = conn.prepareStatement("insert into 
one values(?,?)")) {
                for (int row = 0; row < ROWS; row++) {
                    prep.setInt(1, row / 100);
                    prep.setInt(2, row);
                    prep.execute();
                }
            }
            String s1 = "SELECT COUNT (*) from one where x in ( select y from 
one where y < 100)";
            try (ResultSet rs = stat.executeQuery(s1)) {
                rs.next();
                Assert.assertEquals(rs.getInt(1), 10000);
            }
        }
    }
}

-- 
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 https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.