PageRenderTime 28ms CodeModel.GetById 2ms app.highlight 18ms RepoModel.GetById 1ms app.codeStats 1ms

/mysql-test/suite/engines/funcs/r/ai_overflow_error.result

https://bitbucket.org/Habibutsu/mysql
Unknown | 1081 lines | 1081 code | 0 blank | 0 comment | 0 complexity | 3b4a92d2d8937446f91aafe66ca6baaa MD5 | raw file
   1DROP TABLE IF EXISTS t1;
   2SET SQL_MODE='TRADITIONAL';
   3CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NULL KEY );
   4SHOW CREATE TABLE t1;
   5Table	Create Table
   6t1	CREATE TABLE `t1` (
   7  `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
   8  PRIMARY KEY (`c1`)
   9) ENGINE=ENGINE DEFAULT CHARSET=latin1
  10INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  11ERROR 22003: Out of range value for column 'c1' at row 1
  12INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  13ERROR 22003: Out of range value for column 'c1' at row 1
  14SELECT * FROM t1;
  15c1
  16DROP TABLE t1;
  17SHOW TABLES;
  18Tables_in_test
  19SET SQL_MODE='';
  20SET SQL_MODE='TRADITIONAL';
  21CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NULL KEY );
  22SHOW CREATE TABLE t1;
  23Table	Create Table
  24t1	CREATE TABLE `t1` (
  25  `c1` smallint(6) NOT NULL AUTO_INCREMENT,
  26  PRIMARY KEY (`c1`)
  27) ENGINE=ENGINE DEFAULT CHARSET=latin1
  28INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  29ERROR 22003: Out of range value for column 'c1' at row 1
  30INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  31ERROR 22003: Out of range value for column 'c1' at row 1
  32SELECT * FROM t1;
  33c1
  34DROP TABLE t1;
  35SHOW TABLES;
  36Tables_in_test
  37SET SQL_MODE='';
  38SET SQL_MODE='TRADITIONAL';
  39CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NULL KEY );
  40SHOW CREATE TABLE t1;
  41Table	Create Table
  42t1	CREATE TABLE `t1` (
  43  `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
  44  PRIMARY KEY (`c1`)
  45) ENGINE=ENGINE DEFAULT CHARSET=latin1
  46INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  47ERROR 22003: Out of range value for column 'c1' at row 1
  48INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  49ERROR 22003: Out of range value for column 'c1' at row 1
  50SELECT * FROM t1;
  51c1
  52DROP TABLE t1;
  53SHOW TABLES;
  54Tables_in_test
  55SET SQL_MODE='';
  56SET SQL_MODE='TRADITIONAL';
  57CREATE TABLE t1(c1 INT   AUTO_INCREMENT NULL KEY );
  58SHOW CREATE TABLE t1;
  59Table	Create Table
  60t1	CREATE TABLE `t1` (
  61  `c1` int(11) NOT NULL AUTO_INCREMENT,
  62  PRIMARY KEY (`c1`)
  63) ENGINE=ENGINE DEFAULT CHARSET=latin1
  64INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  65ERROR 22003: Out of range value for column 'c1' at row 1
  66INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  67ERROR 22003: Out of range value for column 'c1' at row 1
  68SELECT * FROM t1;
  69c1
  70DROP TABLE t1;
  71SHOW TABLES;
  72Tables_in_test
  73SET SQL_MODE='';
  74SET SQL_MODE='TRADITIONAL';
  75CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NULL KEY );
  76SHOW CREATE TABLE t1;
  77Table	Create Table
  78t1	CREATE TABLE `t1` (
  79  `c1` int(11) NOT NULL AUTO_INCREMENT,
  80  PRIMARY KEY (`c1`)
  81) ENGINE=ENGINE DEFAULT CHARSET=latin1
  82INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  83ERROR 22003: Out of range value for column 'c1' at row 1
  84INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  85ERROR 22003: Out of range value for column 'c1' at row 1
  86SELECT * FROM t1;
  87c1
  88DROP TABLE t1;
  89SHOW TABLES;
  90Tables_in_test
  91SET SQL_MODE='';
  92SET SQL_MODE='TRADITIONAL';
  93CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NULL KEY );
  94SHOW CREATE TABLE t1;
  95Table	Create Table
  96t1	CREATE TABLE `t1` (
  97  `c1` bigint(20) NOT NULL AUTO_INCREMENT,
  98  PRIMARY KEY (`c1`)
  99) ENGINE=ENGINE DEFAULT CHARSET=latin1
 100INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 101ERROR 22003: Out of range value for column 'c1' at row 1
 102INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 103ERROR 22003: Out of range value for column 'c1' at row 1
 104SELECT * FROM t1;
 105c1
 106DROP TABLE t1;
 107SHOW TABLES;
 108Tables_in_test
 109SET SQL_MODE='';
 110SET SQL_MODE='TRADITIONAL';
 111CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL KEY );
 112SHOW CREATE TABLE t1;
 113Table	Create Table
 114t1	CREATE TABLE `t1` (
 115  `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
 116  PRIMARY KEY (`c1`)
 117) ENGINE=ENGINE DEFAULT CHARSET=latin1
 118INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 119ERROR 22003: Out of range value for column 'c1' at row 1
 120INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 121ERROR 22003: Out of range value for column 'c1' at row 1
 122SELECT * FROM t1;
 123c1
 124DROP TABLE t1;
 125SHOW TABLES;
 126Tables_in_test
 127SET SQL_MODE='';
 128SET SQL_MODE='TRADITIONAL';
 129CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL KEY );
 130SHOW CREATE TABLE t1;
 131Table	Create Table
 132t1	CREATE TABLE `t1` (
 133  `c1` smallint(6) NOT NULL AUTO_INCREMENT,
 134  PRIMARY KEY (`c1`)
 135) ENGINE=ENGINE DEFAULT CHARSET=latin1
 136INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 137ERROR 22003: Out of range value for column 'c1' at row 1
 138INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 139ERROR 22003: Out of range value for column 'c1' at row 1
 140SELECT * FROM t1;
 141c1
 142DROP TABLE t1;
 143SHOW TABLES;
 144Tables_in_test
 145SET SQL_MODE='';
 146SET SQL_MODE='TRADITIONAL';
 147CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL KEY );
 148SHOW CREATE TABLE t1;
 149Table	Create Table
 150t1	CREATE TABLE `t1` (
 151  `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
 152  PRIMARY KEY (`c1`)
 153) ENGINE=ENGINE DEFAULT CHARSET=latin1
 154INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 155ERROR 22003: Out of range value for column 'c1' at row 1
 156INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 157ERROR 22003: Out of range value for column 'c1' at row 1
 158SELECT * FROM t1;
 159c1
 160DROP TABLE t1;
 161SHOW TABLES;
 162Tables_in_test
 163SET SQL_MODE='';
 164SET SQL_MODE='TRADITIONAL';
 165CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL KEY );
 166SHOW CREATE TABLE t1;
 167Table	Create Table
 168t1	CREATE TABLE `t1` (
 169  `c1` int(11) NOT NULL AUTO_INCREMENT,
 170  PRIMARY KEY (`c1`)
 171) ENGINE=ENGINE DEFAULT CHARSET=latin1
 172INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 173ERROR 22003: Out of range value for column 'c1' at row 1
 174INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 175ERROR 22003: Out of range value for column 'c1' at row 1
 176SELECT * FROM t1;
 177c1
 178DROP TABLE t1;
 179SHOW TABLES;
 180Tables_in_test
 181SET SQL_MODE='';
 182SET SQL_MODE='TRADITIONAL';
 183CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL KEY );
 184SHOW CREATE TABLE t1;
 185Table	Create Table
 186t1	CREATE TABLE `t1` (
 187  `c1` int(11) NOT NULL AUTO_INCREMENT,
 188  PRIMARY KEY (`c1`)
 189) ENGINE=ENGINE DEFAULT CHARSET=latin1
 190INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 191ERROR 22003: Out of range value for column 'c1' at row 1
 192INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 193ERROR 22003: Out of range value for column 'c1' at row 1
 194SELECT * FROM t1;
 195c1
 196DROP TABLE t1;
 197SHOW TABLES;
 198Tables_in_test
 199SET SQL_MODE='';
 200SET SQL_MODE='TRADITIONAL';
 201CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL KEY );
 202SHOW CREATE TABLE t1;
 203Table	Create Table
 204t1	CREATE TABLE `t1` (
 205  `c1` bigint(20) NOT NULL AUTO_INCREMENT,
 206  PRIMARY KEY (`c1`)
 207) ENGINE=ENGINE DEFAULT CHARSET=latin1
 208INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 209ERROR 22003: Out of range value for column 'c1' at row 1
 210INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 211ERROR 22003: Out of range value for column 'c1' at row 1
 212SELECT * FROM t1;
 213c1
 214DROP TABLE t1;
 215SHOW TABLES;
 216Tables_in_test
 217SET SQL_MODE='';
 218SET SQL_MODE='TRADITIONAL';
 219CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NULL UNIQUE KEY );
 220SHOW CREATE TABLE t1;
 221Table	Create Table
 222t1	CREATE TABLE `t1` (
 223  `c1` tinyint(4) AUTO_INCREMENT,
 224  UNIQUE KEY `c1` (`c1`)
 225) ENGINE=ENGINE DEFAULT CHARSET=latin1
 226INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 227ERROR 22003: Out of range value for column 'c1' at row 1
 228INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 229ERROR 22003: Out of range value for column 'c1' at row 1
 230SELECT * FROM t1;
 231c1
 232DROP TABLE t1;
 233SHOW TABLES;
 234Tables_in_test
 235SET SQL_MODE='';
 236SET SQL_MODE='TRADITIONAL';
 237CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NULL UNIQUE KEY );
 238SHOW CREATE TABLE t1;
 239Table	Create Table
 240t1	CREATE TABLE `t1` (
 241  `c1` smallint(6) AUTO_INCREMENT,
 242  UNIQUE KEY `c1` (`c1`)
 243) ENGINE=ENGINE DEFAULT CHARSET=latin1
 244INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 245ERROR 22003: Out of range value for column 'c1' at row 1
 246INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 247ERROR 22003: Out of range value for column 'c1' at row 1
 248SELECT * FROM t1;
 249c1
 250DROP TABLE t1;
 251SHOW TABLES;
 252Tables_in_test
 253SET SQL_MODE='';
 254SET SQL_MODE='TRADITIONAL';
 255CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NULL UNIQUE KEY );
 256SHOW CREATE TABLE t1;
 257Table	Create Table
 258t1	CREATE TABLE `t1` (
 259  `c1` mediumint(9) AUTO_INCREMENT,
 260  UNIQUE KEY `c1` (`c1`)
 261) ENGINE=ENGINE DEFAULT CHARSET=latin1
 262INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 263ERROR 22003: Out of range value for column 'c1' at row 1
 264INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 265ERROR 22003: Out of range value for column 'c1' at row 1
 266SELECT * FROM t1;
 267c1
 268DROP TABLE t1;
 269SHOW TABLES;
 270Tables_in_test
 271SET SQL_MODE='';
 272SET SQL_MODE='TRADITIONAL';
 273CREATE TABLE t1(c1 INT   AUTO_INCREMENT NULL UNIQUE KEY );
 274SHOW CREATE TABLE t1;
 275Table	Create Table
 276t1	CREATE TABLE `t1` (
 277  `c1` int(11) AUTO_INCREMENT,
 278  UNIQUE KEY `c1` (`c1`)
 279) ENGINE=ENGINE DEFAULT CHARSET=latin1
 280INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 281ERROR 22003: Out of range value for column 'c1' at row 1
 282INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 283ERROR 22003: Out of range value for column 'c1' at row 1
 284SELECT * FROM t1;
 285c1
 286DROP TABLE t1;
 287SHOW TABLES;
 288Tables_in_test
 289SET SQL_MODE='';
 290SET SQL_MODE='TRADITIONAL';
 291CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NULL UNIQUE KEY );
 292SHOW CREATE TABLE t1;
 293Table	Create Table
 294t1	CREATE TABLE `t1` (
 295  `c1` int(11) AUTO_INCREMENT,
 296  UNIQUE KEY `c1` (`c1`)
 297) ENGINE=ENGINE DEFAULT CHARSET=latin1
 298INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 299ERROR 22003: Out of range value for column 'c1' at row 1
 300INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 301ERROR 22003: Out of range value for column 'c1' at row 1
 302SELECT * FROM t1;
 303c1
 304DROP TABLE t1;
 305SHOW TABLES;
 306Tables_in_test
 307SET SQL_MODE='';
 308SET SQL_MODE='TRADITIONAL';
 309CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NULL UNIQUE KEY );
 310SHOW CREATE TABLE t1;
 311Table	Create Table
 312t1	CREATE TABLE `t1` (
 313  `c1` bigint(20) AUTO_INCREMENT,
 314  UNIQUE KEY `c1` (`c1`)
 315) ENGINE=ENGINE DEFAULT CHARSET=latin1
 316INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 317ERROR 22003: Out of range value for column 'c1' at row 1
 318INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 319ERROR 22003: Out of range value for column 'c1' at row 1
 320SELECT * FROM t1;
 321c1
 322DROP TABLE t1;
 323SHOW TABLES;
 324Tables_in_test
 325SET SQL_MODE='';
 326SET SQL_MODE='TRADITIONAL';
 327CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL UNIQUE KEY );
 328SHOW CREATE TABLE t1;
 329Table	Create Table
 330t1	CREATE TABLE `t1` (
 331  `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
 332  UNIQUE KEY `c1` (`c1`)
 333) ENGINE=ENGINE DEFAULT CHARSET=latin1
 334INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 335ERROR 22003: Out of range value for column 'c1' at row 1
 336INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 337ERROR 22003: Out of range value for column 'c1' at row 1
 338SELECT * FROM t1;
 339c1
 340DROP TABLE t1;
 341SHOW TABLES;
 342Tables_in_test
 343SET SQL_MODE='';
 344SET SQL_MODE='TRADITIONAL';
 345CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL UNIQUE KEY );
 346SHOW CREATE TABLE t1;
 347Table	Create Table
 348t1	CREATE TABLE `t1` (
 349  `c1` smallint(6) NOT NULL AUTO_INCREMENT,
 350  UNIQUE KEY `c1` (`c1`)
 351) ENGINE=ENGINE DEFAULT CHARSET=latin1
 352INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 353ERROR 22003: Out of range value for column 'c1' at row 1
 354INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 355ERROR 22003: Out of range value for column 'c1' at row 1
 356SELECT * FROM t1;
 357c1
 358DROP TABLE t1;
 359SHOW TABLES;
 360Tables_in_test
 361SET SQL_MODE='';
 362SET SQL_MODE='TRADITIONAL';
 363CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL UNIQUE KEY );
 364SHOW CREATE TABLE t1;
 365Table	Create Table
 366t1	CREATE TABLE `t1` (
 367  `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
 368  UNIQUE KEY `c1` (`c1`)
 369) ENGINE=ENGINE DEFAULT CHARSET=latin1
 370INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 371ERROR 22003: Out of range value for column 'c1' at row 1
 372INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 373ERROR 22003: Out of range value for column 'c1' at row 1
 374SELECT * FROM t1;
 375c1
 376DROP TABLE t1;
 377SHOW TABLES;
 378Tables_in_test
 379SET SQL_MODE='';
 380SET SQL_MODE='TRADITIONAL';
 381CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL UNIQUE KEY );
 382SHOW CREATE TABLE t1;
 383Table	Create Table
 384t1	CREATE TABLE `t1` (
 385  `c1` int(11) NOT NULL AUTO_INCREMENT,
 386  UNIQUE KEY `c1` (`c1`)
 387) ENGINE=ENGINE DEFAULT CHARSET=latin1
 388INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 389ERROR 22003: Out of range value for column 'c1' at row 1
 390INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 391ERROR 22003: Out of range value for column 'c1' at row 1
 392SELECT * FROM t1;
 393c1
 394DROP TABLE t1;
 395SHOW TABLES;
 396Tables_in_test
 397SET SQL_MODE='';
 398SET SQL_MODE='TRADITIONAL';
 399CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL UNIQUE KEY );
 400SHOW CREATE TABLE t1;
 401Table	Create Table
 402t1	CREATE TABLE `t1` (
 403  `c1` int(11) NOT NULL AUTO_INCREMENT,
 404  UNIQUE KEY `c1` (`c1`)
 405) ENGINE=ENGINE DEFAULT CHARSET=latin1
 406INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 407ERROR 22003: Out of range value for column 'c1' at row 1
 408INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 409ERROR 22003: Out of range value for column 'c1' at row 1
 410SELECT * FROM t1;
 411c1
 412DROP TABLE t1;
 413SHOW TABLES;
 414Tables_in_test
 415SET SQL_MODE='';
 416SET SQL_MODE='TRADITIONAL';
 417CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL UNIQUE KEY );
 418SHOW CREATE TABLE t1;
 419Table	Create Table
 420t1	CREATE TABLE `t1` (
 421  `c1` bigint(20) NOT NULL AUTO_INCREMENT,
 422  UNIQUE KEY `c1` (`c1`)
 423) ENGINE=ENGINE DEFAULT CHARSET=latin1
 424INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 425ERROR 22003: Out of range value for column 'c1' at row 1
 426INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 427ERROR 22003: Out of range value for column 'c1' at row 1
 428SELECT * FROM t1;
 429c1
 430DROP TABLE t1;
 431SHOW TABLES;
 432Tables_in_test
 433SET SQL_MODE='';
 434SET SQL_MODE='TRADITIONAL';
 435CREATE TABLE t1(c1 TINYINT   AUTO_INCREMENT NOT NULL PRIMARY KEY );
 436SHOW CREATE TABLE t1;
 437Table	Create Table
 438t1	CREATE TABLE `t1` (
 439  `c1` tinyint(4) NOT NULL AUTO_INCREMENT,
 440  PRIMARY KEY (`c1`)
 441) ENGINE=ENGINE DEFAULT CHARSET=latin1
 442INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 443ERROR 22003: Out of range value for column 'c1' at row 1
 444INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 445ERROR 22003: Out of range value for column 'c1' at row 1
 446SELECT * FROM t1;
 447c1
 448DROP TABLE t1;
 449SHOW TABLES;
 450Tables_in_test
 451SET SQL_MODE='';
 452SET SQL_MODE='TRADITIONAL';
 453CREATE TABLE t1(c1 SMALLINT   AUTO_INCREMENT NOT NULL PRIMARY KEY );
 454SHOW CREATE TABLE t1;
 455Table	Create Table
 456t1	CREATE TABLE `t1` (
 457  `c1` smallint(6) NOT NULL AUTO_INCREMENT,
 458  PRIMARY KEY (`c1`)
 459) ENGINE=ENGINE DEFAULT CHARSET=latin1
 460INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 461ERROR 22003: Out of range value for column 'c1' at row 1
 462INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 463ERROR 22003: Out of range value for column 'c1' at row 1
 464SELECT * FROM t1;
 465c1
 466DROP TABLE t1;
 467SHOW TABLES;
 468Tables_in_test
 469SET SQL_MODE='';
 470SET SQL_MODE='TRADITIONAL';
 471CREATE TABLE t1(c1 MEDIUMINT   AUTO_INCREMENT NOT NULL PRIMARY KEY );
 472SHOW CREATE TABLE t1;
 473Table	Create Table
 474t1	CREATE TABLE `t1` (
 475  `c1` mediumint(9) NOT NULL AUTO_INCREMENT,
 476  PRIMARY KEY (`c1`)
 477) ENGINE=ENGINE DEFAULT CHARSET=latin1
 478INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 479ERROR 22003: Out of range value for column 'c1' at row 1
 480INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 481ERROR 22003: Out of range value for column 'c1' at row 1
 482SELECT * FROM t1;
 483c1
 484DROP TABLE t1;
 485SHOW TABLES;
 486Tables_in_test
 487SET SQL_MODE='';
 488SET SQL_MODE='TRADITIONAL';
 489CREATE TABLE t1(c1 INT   AUTO_INCREMENT NOT NULL PRIMARY KEY );
 490SHOW CREATE TABLE t1;
 491Table	Create Table
 492t1	CREATE TABLE `t1` (
 493  `c1` int(11) NOT NULL AUTO_INCREMENT,
 494  PRIMARY KEY (`c1`)
 495) ENGINE=ENGINE DEFAULT CHARSET=latin1
 496INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 497ERROR 22003: Out of range value for column 'c1' at row 1
 498INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 499ERROR 22003: Out of range value for column 'c1' at row 1
 500SELECT * FROM t1;
 501c1
 502DROP TABLE t1;
 503SHOW TABLES;
 504Tables_in_test
 505SET SQL_MODE='';
 506SET SQL_MODE='TRADITIONAL';
 507CREATE TABLE t1(c1 INTEGER   AUTO_INCREMENT NOT NULL PRIMARY KEY );
 508SHOW CREATE TABLE t1;
 509Table	Create Table
 510t1	CREATE TABLE `t1` (
 511  `c1` int(11) NOT NULL AUTO_INCREMENT,
 512  PRIMARY KEY (`c1`)
 513) ENGINE=ENGINE DEFAULT CHARSET=latin1
 514INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 515ERROR 22003: Out of range value for column 'c1' at row 1
 516INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 517ERROR 22003: Out of range value for column 'c1' at row 1
 518SELECT * FROM t1;
 519c1
 520DROP TABLE t1;
 521SHOW TABLES;
 522Tables_in_test
 523SET SQL_MODE='';
 524SET SQL_MODE='TRADITIONAL';
 525CREATE TABLE t1(c1 BIGINT   AUTO_INCREMENT NOT NULL PRIMARY KEY );
 526SHOW CREATE TABLE t1;
 527Table	Create Table
 528t1	CREATE TABLE `t1` (
 529  `c1` bigint(20) NOT NULL AUTO_INCREMENT,
 530  PRIMARY KEY (`c1`)
 531) ENGINE=ENGINE DEFAULT CHARSET=latin1
 532INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 533ERROR 22003: Out of range value for column 'c1' at row 1
 534INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 535ERROR 22003: Out of range value for column 'c1' at row 1
 536SELECT * FROM t1;
 537c1
 538DROP TABLE t1;
 539SHOW TABLES;
 540Tables_in_test
 541SET SQL_MODE='';
 542SET SQL_MODE='TRADITIONAL';
 543CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
 544SHOW CREATE TABLE t1;
 545Table	Create Table
 546t1	CREATE TABLE `t1` (
 547  `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
 548  PRIMARY KEY (`c1`)
 549) ENGINE=ENGINE DEFAULT CHARSET=latin1
 550INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 551ERROR 22003: Out of range value for column 'c1' at row 1
 552INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 553ERROR 22003: Out of range value for column 'c1' at row 1
 554SELECT * FROM t1;
 555c1
 556DROP TABLE t1;
 557SHOW TABLES;
 558Tables_in_test
 559SET SQL_MODE='';
 560SET SQL_MODE='TRADITIONAL';
 561CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
 562SHOW CREATE TABLE t1;
 563Table	Create Table
 564t1	CREATE TABLE `t1` (
 565  `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 566  PRIMARY KEY (`c1`)
 567) ENGINE=ENGINE DEFAULT CHARSET=latin1
 568INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 569ERROR 22003: Out of range value for column 'c1' at row 1
 570INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 571ERROR 22003: Out of range value for column 'c1' at row 1
 572SELECT * FROM t1;
 573c1
 574DROP TABLE t1;
 575SHOW TABLES;
 576Tables_in_test
 577SET SQL_MODE='';
 578SET SQL_MODE='TRADITIONAL';
 579CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
 580SHOW CREATE TABLE t1;
 581Table	Create Table
 582t1	CREATE TABLE `t1` (
 583  `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 584  PRIMARY KEY (`c1`)
 585) ENGINE=ENGINE DEFAULT CHARSET=latin1
 586INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 587ERROR 22003: Out of range value for column 'c1' at row 1
 588INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 589ERROR 22003: Out of range value for column 'c1' at row 1
 590SELECT * FROM t1;
 591c1
 592DROP TABLE t1;
 593SHOW TABLES;
 594Tables_in_test
 595SET SQL_MODE='';
 596SET SQL_MODE='TRADITIONAL';
 597CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
 598SHOW CREATE TABLE t1;
 599Table	Create Table
 600t1	CREATE TABLE `t1` (
 601  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
 602  PRIMARY KEY (`c1`)
 603) ENGINE=ENGINE DEFAULT CHARSET=latin1
 604INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 605ERROR 22003: Out of range value for column 'c1' at row 1
 606INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 607ERROR 22003: Out of range value for column 'c1' at row 1
 608SELECT * FROM t1;
 609c1
 610DROP TABLE t1;
 611SHOW TABLES;
 612Tables_in_test
 613SET SQL_MODE='';
 614SET SQL_MODE='TRADITIONAL';
 615CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
 616SHOW CREATE TABLE t1;
 617Table	Create Table
 618t1	CREATE TABLE `t1` (
 619  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
 620  PRIMARY KEY (`c1`)
 621) ENGINE=ENGINE DEFAULT CHARSET=latin1
 622INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 623ERROR 22003: Out of range value for column 'c1' at row 1
 624INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 625ERROR 22003: Out of range value for column 'c1' at row 1
 626SELECT * FROM t1;
 627c1
 628DROP TABLE t1;
 629SHOW TABLES;
 630Tables_in_test
 631SET SQL_MODE='';
 632SET SQL_MODE='TRADITIONAL';
 633CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
 634SHOW CREATE TABLE t1;
 635Table	Create Table
 636t1	CREATE TABLE `t1` (
 637  `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 638  PRIMARY KEY (`c1`)
 639) ENGINE=ENGINE DEFAULT CHARSET=latin1
 640INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 641ERROR 22003: Out of range value for column 'c1' at row 1
 642INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 643ERROR 22003: Out of range value for column 'c1' at row 1
 644SELECT * FROM t1;
 645c1
 646DROP TABLE t1;
 647SHOW TABLES;
 648Tables_in_test
 649SET SQL_MODE='';
 650SET SQL_MODE='TRADITIONAL';
 651CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
 652SHOW CREATE TABLE t1;
 653Table	Create Table
 654t1	CREATE TABLE `t1` (
 655  `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
 656  PRIMARY KEY (`c1`)
 657) ENGINE=ENGINE DEFAULT CHARSET=latin1
 658INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 659ERROR 22003: Out of range value for column 'c1' at row 1
 660INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 661ERROR 22003: Out of range value for column 'c1' at row 1
 662SELECT * FROM t1;
 663c1
 664DROP TABLE t1;
 665SHOW TABLES;
 666Tables_in_test
 667SET SQL_MODE='';
 668SET SQL_MODE='TRADITIONAL';
 669CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
 670SHOW CREATE TABLE t1;
 671Table	Create Table
 672t1	CREATE TABLE `t1` (
 673  `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 674  PRIMARY KEY (`c1`)
 675) ENGINE=ENGINE DEFAULT CHARSET=latin1
 676INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 677ERROR 22003: Out of range value for column 'c1' at row 1
 678INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 679ERROR 22003: Out of range value for column 'c1' at row 1
 680SELECT * FROM t1;
 681c1
 682DROP TABLE t1;
 683SHOW TABLES;
 684Tables_in_test
 685SET SQL_MODE='';
 686SET SQL_MODE='TRADITIONAL';
 687CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
 688SHOW CREATE TABLE t1;
 689Table	Create Table
 690t1	CREATE TABLE `t1` (
 691  `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 692  PRIMARY KEY (`c1`)
 693) ENGINE=ENGINE DEFAULT CHARSET=latin1
 694INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 695ERROR 22003: Out of range value for column 'c1' at row 1
 696INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 697ERROR 22003: Out of range value for column 'c1' at row 1
 698SELECT * FROM t1;
 699c1
 700DROP TABLE t1;
 701SHOW TABLES;
 702Tables_in_test
 703SET SQL_MODE='';
 704SET SQL_MODE='TRADITIONAL';
 705CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
 706SHOW CREATE TABLE t1;
 707Table	Create Table
 708t1	CREATE TABLE `t1` (
 709  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
 710  PRIMARY KEY (`c1`)
 711) ENGINE=ENGINE DEFAULT CHARSET=latin1
 712INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 713ERROR 22003: Out of range value for column 'c1' at row 1
 714INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 715ERROR 22003: Out of range value for column 'c1' at row 1
 716SELECT * FROM t1;
 717c1
 718DROP TABLE t1;
 719SHOW TABLES;
 720Tables_in_test
 721SET SQL_MODE='';
 722SET SQL_MODE='TRADITIONAL';
 723CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
 724SHOW CREATE TABLE t1;
 725Table	Create Table
 726t1	CREATE TABLE `t1` (
 727  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
 728  PRIMARY KEY (`c1`)
 729) ENGINE=ENGINE DEFAULT CHARSET=latin1
 730INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 731ERROR 22003: Out of range value for column 'c1' at row 1
 732INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 733ERROR 22003: Out of range value for column 'c1' at row 1
 734SELECT * FROM t1;
 735c1
 736DROP TABLE t1;
 737SHOW TABLES;
 738Tables_in_test
 739SET SQL_MODE='';
 740SET SQL_MODE='TRADITIONAL';
 741CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
 742SHOW CREATE TABLE t1;
 743Table	Create Table
 744t1	CREATE TABLE `t1` (
 745  `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 746  PRIMARY KEY (`c1`)
 747) ENGINE=ENGINE DEFAULT CHARSET=latin1
 748INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 749ERROR 22003: Out of range value for column 'c1' at row 1
 750INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 751ERROR 22003: Out of range value for column 'c1' at row 1
 752SELECT * FROM t1;
 753c1
 754DROP TABLE t1;
 755SHOW TABLES;
 756Tables_in_test
 757SET SQL_MODE='';
 758SET SQL_MODE='TRADITIONAL';
 759CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
 760SHOW CREATE TABLE t1;
 761Table	Create Table
 762t1	CREATE TABLE `t1` (
 763  `c1` tinyint(3) unsigned AUTO_INCREMENT,
 764  UNIQUE KEY `c1` (`c1`)
 765) ENGINE=ENGINE DEFAULT CHARSET=latin1
 766INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 767ERROR 22003: Out of range value for column 'c1' at row 1
 768INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 769ERROR 22003: Out of range value for column 'c1' at row 1
 770SELECT * FROM t1;
 771c1
 772DROP TABLE t1;
 773SHOW TABLES;
 774Tables_in_test
 775SET SQL_MODE='';
 776SET SQL_MODE='TRADITIONAL';
 777CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
 778SHOW CREATE TABLE t1;
 779Table	Create Table
 780t1	CREATE TABLE `t1` (
 781  `c1` smallint(5) unsigned AUTO_INCREMENT,
 782  UNIQUE KEY `c1` (`c1`)
 783) ENGINE=ENGINE DEFAULT CHARSET=latin1
 784INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 785ERROR 22003: Out of range value for column 'c1' at row 1
 786INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 787ERROR 22003: Out of range value for column 'c1' at row 1
 788SELECT * FROM t1;
 789c1
 790DROP TABLE t1;
 791SHOW TABLES;
 792Tables_in_test
 793SET SQL_MODE='';
 794SET SQL_MODE='TRADITIONAL';
 795CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
 796SHOW CREATE TABLE t1;
 797Table	Create Table
 798t1	CREATE TABLE `t1` (
 799  `c1` mediumint(8) unsigned AUTO_INCREMENT,
 800  UNIQUE KEY `c1` (`c1`)
 801) ENGINE=ENGINE DEFAULT CHARSET=latin1
 802INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 803ERROR 22003: Out of range value for column 'c1' at row 1
 804INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 805ERROR 22003: Out of range value for column 'c1' at row 1
 806SELECT * FROM t1;
 807c1
 808DROP TABLE t1;
 809SHOW TABLES;
 810Tables_in_test
 811SET SQL_MODE='';
 812SET SQL_MODE='TRADITIONAL';
 813CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
 814SHOW CREATE TABLE t1;
 815Table	Create Table
 816t1	CREATE TABLE `t1` (
 817  `c1` int(10) unsigned AUTO_INCREMENT,
 818  UNIQUE KEY `c1` (`c1`)
 819) ENGINE=ENGINE DEFAULT CHARSET=latin1
 820INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 821ERROR 22003: Out of range value for column 'c1' at row 1
 822INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 823ERROR 22003: Out of range value for column 'c1' at row 1
 824SELECT * FROM t1;
 825c1
 826DROP TABLE t1;
 827SHOW TABLES;
 828Tables_in_test
 829SET SQL_MODE='';
 830SET SQL_MODE='TRADITIONAL';
 831CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
 832SHOW CREATE TABLE t1;
 833Table	Create Table
 834t1	CREATE TABLE `t1` (
 835  `c1` int(10) unsigned AUTO_INCREMENT,
 836  UNIQUE KEY `c1` (`c1`)
 837) ENGINE=ENGINE DEFAULT CHARSET=latin1
 838INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 839ERROR 22003: Out of range value for column 'c1' at row 1
 840INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 841ERROR 22003: Out of range value for column 'c1' at row 1
 842SELECT * FROM t1;
 843c1
 844DROP TABLE t1;
 845SHOW TABLES;
 846Tables_in_test
 847SET SQL_MODE='';
 848SET SQL_MODE='TRADITIONAL';
 849CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
 850SHOW CREATE TABLE t1;
 851Table	Create Table
 852t1	CREATE TABLE `t1` (
 853  `c1` bigint(20) unsigned AUTO_INCREMENT,
 854  UNIQUE KEY `c1` (`c1`)
 855) ENGINE=ENGINE DEFAULT CHARSET=latin1
 856INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 857ERROR 22003: Out of range value for column 'c1' at row 1
 858INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 859ERROR 22003: Out of range value for column 'c1' at row 1
 860SELECT * FROM t1;
 861c1
 862DROP TABLE t1;
 863SHOW TABLES;
 864Tables_in_test
 865SET SQL_MODE='';
 866SET SQL_MODE='TRADITIONAL';
 867CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
 868SHOW CREATE TABLE t1;
 869Table	Create Table
 870t1	CREATE TABLE `t1` (
 871  `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
 872  UNIQUE KEY `c1` (`c1`)
 873) ENGINE=ENGINE DEFAULT CHARSET=latin1
 874INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 875ERROR 22003: Out of range value for column 'c1' at row 1
 876INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 877ERROR 22003: Out of range value for column 'c1' at row 1
 878SELECT * FROM t1;
 879c1
 880DROP TABLE t1;
 881SHOW TABLES;
 882Tables_in_test
 883SET SQL_MODE='';
 884SET SQL_MODE='TRADITIONAL';
 885CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
 886SHOW CREATE TABLE t1;
 887Table	Create Table
 888t1	CREATE TABLE `t1` (
 889  `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 890  UNIQUE KEY `c1` (`c1`)
 891) ENGINE=ENGINE DEFAULT CHARSET=latin1
 892INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 893ERROR 22003: Out of range value for column 'c1' at row 1
 894INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 895ERROR 22003: Out of range value for column 'c1' at row 1
 896SELECT * FROM t1;
 897c1
 898DROP TABLE t1;
 899SHOW TABLES;
 900Tables_in_test
 901SET SQL_MODE='';
 902SET SQL_MODE='TRADITIONAL';
 903CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
 904SHOW CREATE TABLE t1;
 905Table	Create Table
 906t1	CREATE TABLE `t1` (
 907  `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 908  UNIQUE KEY `c1` (`c1`)
 909) ENGINE=ENGINE DEFAULT CHARSET=latin1
 910INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 911ERROR 22003: Out of range value for column 'c1' at row 1
 912INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 913ERROR 22003: Out of range value for column 'c1' at row 1
 914SELECT * FROM t1;
 915c1
 916DROP TABLE t1;
 917SHOW TABLES;
 918Tables_in_test
 919SET SQL_MODE='';
 920SET SQL_MODE='TRADITIONAL';
 921CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
 922SHOW CREATE TABLE t1;
 923Table	Create Table
 924t1	CREATE TABLE `t1` (
 925  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
 926  UNIQUE KEY `c1` (`c1`)
 927) ENGINE=ENGINE DEFAULT CHARSET=latin1
 928INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 929ERROR 22003: Out of range value for column 'c1' at row 1
 930INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 931ERROR 22003: Out of range value for column 'c1' at row 1
 932SELECT * FROM t1;
 933c1
 934DROP TABLE t1;
 935SHOW TABLES;
 936Tables_in_test
 937SET SQL_MODE='';
 938SET SQL_MODE='TRADITIONAL';
 939CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
 940SHOW CREATE TABLE t1;
 941Table	Create Table
 942t1	CREATE TABLE `t1` (
 943  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
 944  UNIQUE KEY `c1` (`c1`)
 945) ENGINE=ENGINE DEFAULT CHARSET=latin1
 946INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 947ERROR 22003: Out of range value for column 'c1' at row 1
 948INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 949ERROR 22003: Out of range value for column 'c1' at row 1
 950SELECT * FROM t1;
 951c1
 952DROP TABLE t1;
 953SHOW TABLES;
 954Tables_in_test
 955SET SQL_MODE='';
 956SET SQL_MODE='TRADITIONAL';
 957CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
 958SHOW CREATE TABLE t1;
 959Table	Create Table
 960t1	CREATE TABLE `t1` (
 961  `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 962  UNIQUE KEY `c1` (`c1`)
 963) ENGINE=ENGINE DEFAULT CHARSET=latin1
 964INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 965ERROR 22003: Out of range value for column 'c1' at row 1
 966INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 967ERROR 22003: Out of range value for column 'c1' at row 1
 968SELECT * FROM t1;
 969c1
 970DROP TABLE t1;
 971SHOW TABLES;
 972Tables_in_test
 973SET SQL_MODE='';
 974SET SQL_MODE='TRADITIONAL';
 975CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
 976SHOW CREATE TABLE t1;
 977Table	Create Table
 978t1	CREATE TABLE `t1` (
 979  `c1` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
 980  PRIMARY KEY (`c1`)
 981) ENGINE=ENGINE DEFAULT CHARSET=latin1
 982INSERT INTO t1 VALUES(111111111111111111111111111111111111);
 983ERROR 22003: Out of range value for column 'c1' at row 1
 984INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
 985ERROR 22003: Out of range value for column 'c1' at row 1
 986SELECT * FROM t1;
 987c1
 988DROP TABLE t1;
 989SHOW TABLES;
 990Tables_in_test
 991SET SQL_MODE='';
 992SET SQL_MODE='TRADITIONAL';
 993CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
 994SHOW CREATE TABLE t1;
 995Table	Create Table
 996t1	CREATE TABLE `t1` (
 997  `c1` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
 998  PRIMARY KEY (`c1`)
 999) ENGINE=ENGINE DEFAULT CHARSET=latin1
1000INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1001ERROR 22003: Out of range value for column 'c1' at row 1
1002INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1003ERROR 22003: Out of range value for column 'c1' at row 1
1004SELECT * FROM t1;
1005c1
1006DROP TABLE t1;
1007SHOW TABLES;
1008Tables_in_test
1009SET SQL_MODE='';
1010SET SQL_MODE='TRADITIONAL';
1011CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1012SHOW CREATE TABLE t1;
1013Table	Create Table
1014t1	CREATE TABLE `t1` (
1015  `c1` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
1016  PRIMARY KEY (`c1`)
1017) ENGINE=ENGINE DEFAULT CHARSET=latin1
1018INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1019ERROR 22003: Out of range value for column 'c1' at row 1
1020INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1021ERROR 22003: Out of range value for column 'c1' at row 1
1022SELECT * FROM t1;
1023c1
1024DROP TABLE t1;
1025SHOW TABLES;
1026Tables_in_test
1027SET SQL_MODE='';
1028SET SQL_MODE='TRADITIONAL';
1029CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1030SHOW CREATE TABLE t1;
1031Table	Create Table
1032t1	CREATE TABLE `t1` (
1033  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1034  PRIMARY KEY (`c1`)
1035) ENGINE=ENGINE DEFAULT CHARSET=latin1
1036INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1037ERROR 22003: Out of range value for column 'c1' at row 1
1038INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1039ERROR 22003: Out of range value for column 'c1' at row 1
1040SELECT * FROM t1;
1041c1
1042DROP TABLE t1;
1043SHOW TABLES;
1044Tables_in_test
1045SET SQL_MODE='';
1046SET SQL_MODE='TRADITIONAL';
1047CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1048SHOW CREATE TABLE t1;
1049Table	Create Table
1050t1	CREATE TABLE `t1` (
1051  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
1052  PRIMARY KEY (`c1`)
1053) ENGINE=ENGINE DEFAULT CHARSET=latin1
1054INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1055ERROR 22003: Out of range value for column 'c1' at row 1
1056INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1057ERROR 22003: Out of range value for column 'c1' at row 1
1058SELECT * FROM t1;
1059c1
1060DROP TABLE t1;
1061SHOW TABLES;
1062Tables_in_test
1063SET SQL_MODE='';
1064SET SQL_MODE='TRADITIONAL';
1065CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
1066SHOW CREATE TABLE t1;
1067Table	Create Table
1068t1	CREATE TABLE `t1` (
1069  `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1070  PRIMARY KEY (`c1`)
1071) ENGINE=ENGINE DEFAULT CHARSET=latin1
1072INSERT INTO t1 VALUES(111111111111111111111111111111111111);
1073ERROR 22003: Out of range value for column 'c1' at row 1
1074INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
1075ERROR 22003: Out of range value for column 'c1' at row 1
1076SELECT * FROM t1;
1077c1
1078DROP TABLE t1;
1079SHOW TABLES;
1080Tables_in_test
1081SET SQL_MODE='';