RaigorJiang opened a new issue, #32756: URL: https://github.com/apache/shardingsphere/issues/32756
## Bug Report ### Which version of ShardingSphere did you use? 5.5.1-SNAPSHOT master 2d81b4f9df907ca34187fce8827d981a164f6fbb ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-Proxy ### Expected behavior Insert success ### Actual behavior <img width="1219" alt="image" src="https://github.com/user-attachments/assets/606629ff-a642-47ea-8d03-8c126b49e37f";> ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. 1. create single table ```sql SET DEFAULT SINGLE TABLE STORAGE UNIT = ds_0; CREATE TABLE `t_private_params` ( `ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `SEID` varchar(20) COLLATE utf8_bin NOT NULL, `instance_aid` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '应用实例aid', `HAS_INJECT` int(1) DEFAULT '0', `MOC` varchar(18) COLLATE utf8_bin DEFAULT NULL, `UID` varchar(20) COLLATE utf8_bin DEFAULT NULL, `SAK` varchar(2) COLLATE utf8_bin DEFAULT NULL, `ATQA` varchar(4) COLLATE utf8_bin DEFAULT NULL, `ATS` text COLLATE utf8_bin, `CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `UPDATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=80713 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; ``` 2. execute insert ```sql INSERT INTO `t_private_params` VALUES (182,'47902139015891403483','A0000053425748544B',NULL,NULL,'65F58050',NULL,NULL,'','2023-04-23 19:09:43','2023-04-23 19:09:43'); ``` ### Proxy log ```plain java.lang.IndexOutOfBoundsException: Index -1 out of bounds for length 11 at java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:64) at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java:70) at java.base/jdk.internal.util.Preconditions.checkIndex(Preconditions.java:266) at java.base/java.util.Objects.checkIndex(Objects.java:361) at java.base/java.util.ArrayList.get(ArrayList.java:427) at org.apache.shardingsphere.infra.binder.context.segment.insert.keygen.engine.GeneratedKeyContextEngine.findGeneratedKey(GeneratedKeyContextEngine.java:95) at org.apache.shardingsphere.infra.binder.context.segment.insert.keygen.engine.GeneratedKeyContextEngine.lambda$createGenerateKeyContext$1(GeneratedKeyContextEngine.java:56) at java.base/java.util.Optional.map(Optional.java:260) at org.apache.shardingsphere.infra.binder.context.segment.insert.keygen.engine.GeneratedKeyContextEngine.createGenerateKeyContext(GeneratedKeyContextEngine.java:55) at org.apache.shardingsphere.infra.binder.context.statement.dml.InsertStatementContext.<init>(InsertStatementContext.java:102) at org.apache.shardingsphere.infra.binder.context.statement.SQLStatementContextFactory.getDMLStatementContext(SQLStatementContextFactory.java:156) at org.apache.shardingsphere.infra.binder.context.statement.SQLStatementContextFactory.newInstance(SQLStatementContextFactory.java:131) at org.apache.shardingsphere.infra.binder.engine.SQLBindEngine.bind(SQLBindEngine.java:54) at org.apache.shardingsphere.proxy.backend.handler.ProxyBackendHandlerFactory.newInstance(ProxyBackendHandlerFactory.java:91) at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.<init>(MySQLComQueryPacketExecutor.java:66) at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecutorFactory.newInstance(MySQLCommandExecutorFactory.java:84) at org.apache.shardingsphere.proxy.frontend.mysql.command.MySQLCommandExecuteEngine.getCommandExecutor(MySQLCommandExecuteEngine.java:59) at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:120) at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78) at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:60) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) ``` -- 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]
