huifer commented on issue #23389:
URL:
https://github.com/apache/shardingsphere/issues/23389#issuecomment-1374367170
My current guess is that I am using the following code when producing the
database tables
```
"CREATE TABLE `" + item + "` (\n"
+ " `id` bigint NOT NULL AUTO_INCREMENT,\n"
+ " `device_id` varchar(255) DEFAULT NULL,\n"
+ " `time` datetime DEFAULT NULL,\n"
+ " `v1` varchar(255) DEFAULT NULL,\n"
+ " `v2` varchar(255) DEFAULT NULL,\n"
+ " `v3` varchar(255) DEFAULT NULL,\n"
+ " `v4` varchar(255) DEFAULT NULL,\n"
+ " `v5` varchar(255) DEFAULT NULL,\n"
+ " PRIMARY KEY (`id`)\n"
+ ") ENGINE=InnoDB AUTO_INCREMENT=818114806320992257 DEFAULT
CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;"
```
caused the ID to self-increment, but in sharding I configured the snowflake
algorithm and I think he should override my ID self-increment
--
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]
