Re: Bug regarding rewritableAsMultiValues introduced in 8.0.29
Posted by: Gustaf Sörensen
Date: January 26, 2023 12:54PM

Yes, sorry bad description. Exactly, the query is not failing but runs slow.
When ran batched it does not get properly rewritten to multi values due to the bug highlighted by the test.

We are doing batched inserts something like this:

PreparedStatement preparedStatement = connection.prepareStatement(
"INSERT INTO test (a_value, bvalue) VALUES (?, ?)"
);
IntStream.range(0, 1000).forEach(i -> {
preparedStatement.setInt(1, 80);
preparedStatement.setString(2, "abc");
preparedStatement.addBatch();
});
preparedStatement.executeBatch();

With 8.0.28:
Creates a single 1000 row multi value insert towards the db
With 8.0.29:
Creates 1000 inserts towards the db.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.