PageRenderTime 47ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

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