[MDEV-9306] Auto Increment on create can be set above column range Created: 2015-12-18  Updated: 2017-06-26

Status: Open
Project: MariaDB Server
Component/s: Data Definition - Alter Table
Affects Version/s: 5.5, 10.0, 10.1, 10.2
Fix Version/s: 10.2

Type: Bug Priority: Minor
Reporter: Michal Zubkowicz Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Such query should be blocked:

CREATE TABLE `products` (
 
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
 
  `name` varchar(255) NOT NULL,
 
  PRIMARY KEY (`id`)
 
) ENGINE=InnoDB AUTO_INCREMENT=9999999999999 DEFAULT CHARSET=utf8;


Generated at Thu Feb 08 07:33:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.