TeslaCN commented on issue #21272:
URL:
https://github.com/apache/shardingsphere/issues/21272#issuecomment-1263011202
I've test the openGauss JDBC Driver, it does return a result like the actual
behavior in this issue.
```java
Connection connection =
DriverManager.getConnection("jdbc:opengauss://127.0.0.1:5433/postgres?loggerLevel=OFF",
"omm", "Password@123");
Statement statement = connection.createStatement();
statement.executeUpdate("drop table if exists t_order");
statement.executeUpdate(
"create table t_order (order_id bigint primary key, user_id
bigint not null, order_time timestamp not null, order_value varchar not null)");
PreparedStatement preparedStatement =
connection.prepareStatement("insert into t_order (user_id, order_time,
order_value, order_id) values (?, ?, ?, ?)");
int rows = 10;
for (int i = 0; i < rows; i++) {
preparedStatement.setLong(1, i);
preparedStatement.setTimestamp(2, new
Timestamp(System.currentTimeMillis()));
preparedStatement.setString(3, "");
preparedStatement.setLong(4,
ThreadLocalRandom.current().nextLong());
preparedStatement.addBatch();
}
int[] result = preparedStatement.executeBatch();
System.out.println(Arrays.toString(result));
statement.executeUpdate("drop table t_order");
preparedStatement.close();
statement.close();
connection.close();
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
