[I] In a SQL Server environment, when Spring Batch uses a sharding data source, the auto-increment table of the batch framework encounters an execution error. [shardingsphere]

[via GitHub]

liangleiA opened a new issue, #35268:
URL: https://github.com/apache/shardingsphere/issues/35268

   The tables for Spring Batch are managed by the framework itself. In the SQL 
Server environment, only the business tables are sharded, while the framework's 
BATCH_* tables are not configured with any sharding rules. However, the 
sharding parser modifies the default execution statements.
   
   The table creation statement is as follows, with an auto-incrementing 
primary key:
   
   Original SQL (executes successfully):
   ```
   CREATE TABLE BATCH_JOB_SEQ (ID BIGINT IDENTITY);
   ```
   
   Transformed SQL (execution fails):
   ```
   INSERT INTO BATCH_JOB_SEQ(ID, id) DEFAULT VALUES;
   ```
   


-- 
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: 
notifications-unsubscr...@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org