Regression in version 3.4.0 when running executeQuery() on DELETE .. RETURNING statements

try (Statement s = connection.createStatement()) {

    s.executeUpdate("create table t (i int primary key)");

    try (ResultSet rs = s.executeQuery("""

        delete from t

        where false

        returning i

        """)) {

        while (rs.next())

            System.out.println(rs.getInt(1));

    }

    finally {

        s.executeUpdate("drop table t");

    }

}

0

Statement.executeQuery() command does NOT return a result-set as expected. Either use Statement.execute(), Statement.executeUpdate(), or correct command

null

java.sql.SQLException: Statement.executeQuery() command does NOT return a result-set as expected. Either use Statement.execute(), Statement.executeUpdate(), or correct command

	at org.mariadb.jdbc.Statement.executeQuery(Statement.java:171)

	at org.jooq.testscripts.JDBC.main(JDBC.java:42)