tuichenchuxin commented on issue #13670: URL: https://github.com/apache/shardingsphere/issues/13670#issuecomment-979829295
@ThisOnly I think we should not add negtive value on column with auto-increment. But it has really inserted, return error is not correct. `There can be only one AUTO_INCREMENT column per table, it must be indexed, and it cannot have a DEFAULT value. An AUTO_INCREMENT column works properly only if it contains only positive values. Inserting a negative number is regarded as inserting a very large positive number. This is done to avoid precision problems when numbers “wrap” over from positive to negative and also to ensure that you do not accidentally get an AUTO_INCREMENT column that contains 0.` https://dev.mysql.com/doc/refman/8.0/en/create-table.html -- 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]
