PageRenderTime 63ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/mysql-test/suite/engines/funcs/t/ai_overflow_error.test

https://bitbucket.org/Habibutsu/mysql
Unknown | 784 lines | 783 code | 1 blank | 0 comment | 0 complexity | f2f731cafc980b8310595fa88898b6bd MD5 | raw file
Possible License(s): GPL-2.0, BSD-3-Clause
  1. --disable_warnings
  2. DROP TABLE IF EXISTS t1;
  3. --enable_warnings
  4. SET SQL_MODE='TRADITIONAL';
  5. CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL KEY );
  6. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  7. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  8. SHOW CREATE TABLE t1;
  9. --error 1264
  10. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  11. --error 1264
  12. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  13. SELECT * FROM t1;
  14. DROP TABLE t1;
  15. SHOW TABLES;
  16. SET SQL_MODE='';
  17. SET SQL_MODE='TRADITIONAL';
  18. CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL KEY );
  19. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  20. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  21. SHOW CREATE TABLE t1;
  22. --error 1264
  23. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  24. --error 1264
  25. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  26. SELECT * FROM t1;
  27. DROP TABLE t1;
  28. SHOW TABLES;
  29. SET SQL_MODE='';
  30. SET SQL_MODE='TRADITIONAL';
  31. CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL KEY );
  32. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  33. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  34. SHOW CREATE TABLE t1;
  35. --error 1264
  36. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  37. --error 1264
  38. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  39. SELECT * FROM t1;
  40. DROP TABLE t1;
  41. SHOW TABLES;
  42. SET SQL_MODE='';
  43. SET SQL_MODE='TRADITIONAL';
  44. CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL KEY );
  45. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  46. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  47. SHOW CREATE TABLE t1;
  48. --error 1264
  49. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  50. --error 1264
  51. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  52. SELECT * FROM t1;
  53. DROP TABLE t1;
  54. SHOW TABLES;
  55. SET SQL_MODE='';
  56. SET SQL_MODE='TRADITIONAL';
  57. CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL KEY );
  58. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  59. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  60. SHOW CREATE TABLE t1;
  61. --error 1264
  62. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  63. --error 1264
  64. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  65. SELECT * FROM t1;
  66. DROP TABLE t1;
  67. SHOW TABLES;
  68. SET SQL_MODE='';
  69. SET SQL_MODE='TRADITIONAL';
  70. CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL KEY );
  71. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  72. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  73. SHOW CREATE TABLE t1;
  74. --error 1264
  75. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  76. --error 1264
  77. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  78. SELECT * FROM t1;
  79. DROP TABLE t1;
  80. SHOW TABLES;
  81. SET SQL_MODE='';
  82. SET SQL_MODE='TRADITIONAL';
  83. CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL KEY );
  84. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  85. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  86. SHOW CREATE TABLE t1;
  87. --error 1264
  88. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  89. --error 1264
  90. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  91. SELECT * FROM t1;
  92. DROP TABLE t1;
  93. SHOW TABLES;
  94. SET SQL_MODE='';
  95. SET SQL_MODE='TRADITIONAL';
  96. CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL KEY );
  97. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  98. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  99. SHOW CREATE TABLE t1;
  100. --error 1264
  101. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  102. --error 1264
  103. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  104. SELECT * FROM t1;
  105. DROP TABLE t1;
  106. SHOW TABLES;
  107. SET SQL_MODE='';
  108. SET SQL_MODE='TRADITIONAL';
  109. CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL KEY );
  110. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  111. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  112. SHOW CREATE TABLE t1;
  113. --error 1264
  114. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  115. --error 1264
  116. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  117. SELECT * FROM t1;
  118. DROP TABLE t1;
  119. SHOW TABLES;
  120. SET SQL_MODE='';
  121. SET SQL_MODE='TRADITIONAL';
  122. CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL KEY );
  123. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  124. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  125. SHOW CREATE TABLE t1;
  126. --error 1264
  127. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  128. --error 1264
  129. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  130. SELECT * FROM t1;
  131. DROP TABLE t1;
  132. SHOW TABLES;
  133. SET SQL_MODE='';
  134. SET SQL_MODE='TRADITIONAL';
  135. CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL KEY );
  136. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  137. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  138. SHOW CREATE TABLE t1;
  139. --error 1264
  140. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  141. --error 1264
  142. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  143. SELECT * FROM t1;
  144. DROP TABLE t1;
  145. SHOW TABLES;
  146. SET SQL_MODE='';
  147. SET SQL_MODE='TRADITIONAL';
  148. CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL KEY );
  149. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  150. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  151. SHOW CREATE TABLE t1;
  152. --error 1264
  153. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  154. --error 1264
  155. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  156. SELECT * FROM t1;
  157. DROP TABLE t1;
  158. SHOW TABLES;
  159. SET SQL_MODE='';
  160. SET SQL_MODE='TRADITIONAL';
  161. CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NULL UNIQUE KEY );
  162. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  163. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  164. SHOW CREATE TABLE t1;
  165. --error 1264
  166. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  167. --error 1264
  168. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  169. SELECT * FROM t1;
  170. DROP TABLE t1;
  171. SHOW TABLES;
  172. SET SQL_MODE='';
  173. SET SQL_MODE='TRADITIONAL';
  174. CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NULL UNIQUE KEY );
  175. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  176. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  177. SHOW CREATE TABLE t1;
  178. --error 1264
  179. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  180. --error 1264
  181. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  182. SELECT * FROM t1;
  183. DROP TABLE t1;
  184. SHOW TABLES;
  185. SET SQL_MODE='';
  186. SET SQL_MODE='TRADITIONAL';
  187. CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NULL UNIQUE KEY );
  188. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  189. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  190. SHOW CREATE TABLE t1;
  191. --error 1264
  192. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  193. --error 1264
  194. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  195. SELECT * FROM t1;
  196. DROP TABLE t1;
  197. SHOW TABLES;
  198. SET SQL_MODE='';
  199. SET SQL_MODE='TRADITIONAL';
  200. CREATE TABLE t1(c1 INT AUTO_INCREMENT NULL UNIQUE KEY );
  201. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  202. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  203. SHOW CREATE TABLE t1;
  204. --error 1264
  205. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  206. --error 1264
  207. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  208. SELECT * FROM t1;
  209. DROP TABLE t1;
  210. SHOW TABLES;
  211. SET SQL_MODE='';
  212. SET SQL_MODE='TRADITIONAL';
  213. CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NULL UNIQUE KEY );
  214. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  215. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  216. SHOW CREATE TABLE t1;
  217. --error 1264
  218. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  219. --error 1264
  220. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  221. SELECT * FROM t1;
  222. DROP TABLE t1;
  223. SHOW TABLES;
  224. SET SQL_MODE='';
  225. SET SQL_MODE='TRADITIONAL';
  226. CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NULL UNIQUE KEY );
  227. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  228. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  229. SHOW CREATE TABLE t1;
  230. --error 1264
  231. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  232. --error 1264
  233. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  234. SELECT * FROM t1;
  235. DROP TABLE t1;
  236. SHOW TABLES;
  237. SET SQL_MODE='';
  238. SET SQL_MODE='TRADITIONAL';
  239. CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
  240. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  241. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  242. SHOW CREATE TABLE t1;
  243. --error 1264
  244. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  245. --error 1264
  246. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  247. SELECT * FROM t1;
  248. DROP TABLE t1;
  249. SHOW TABLES;
  250. SET SQL_MODE='';
  251. SET SQL_MODE='TRADITIONAL';
  252. CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
  253. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  254. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  255. SHOW CREATE TABLE t1;
  256. --error 1264
  257. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  258. --error 1264
  259. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  260. SELECT * FROM t1;
  261. DROP TABLE t1;
  262. SHOW TABLES;
  263. SET SQL_MODE='';
  264. SET SQL_MODE='TRADITIONAL';
  265. CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
  266. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  267. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  268. SHOW CREATE TABLE t1;
  269. --error 1264
  270. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  271. --error 1264
  272. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  273. SELECT * FROM t1;
  274. DROP TABLE t1;
  275. SHOW TABLES;
  276. SET SQL_MODE='';
  277. SET SQL_MODE='TRADITIONAL';
  278. CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL UNIQUE KEY );
  279. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  280. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  281. SHOW CREATE TABLE t1;
  282. --error 1264
  283. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  284. --error 1264
  285. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  286. SELECT * FROM t1;
  287. DROP TABLE t1;
  288. SHOW TABLES;
  289. SET SQL_MODE='';
  290. SET SQL_MODE='TRADITIONAL';
  291. CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL UNIQUE KEY );
  292. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  293. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  294. SHOW CREATE TABLE t1;
  295. --error 1264
  296. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  297. --error 1264
  298. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  299. SELECT * FROM t1;
  300. DROP TABLE t1;
  301. SHOW TABLES;
  302. SET SQL_MODE='';
  303. SET SQL_MODE='TRADITIONAL';
  304. CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL UNIQUE KEY );
  305. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  306. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  307. SHOW CREATE TABLE t1;
  308. --error 1264
  309. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  310. --error 1264
  311. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  312. SELECT * FROM t1;
  313. DROP TABLE t1;
  314. SHOW TABLES;
  315. SET SQL_MODE='';
  316. SET SQL_MODE='TRADITIONAL';
  317. CREATE TABLE t1(c1 TINYINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
  318. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  319. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  320. SHOW CREATE TABLE t1;
  321. --error 1264
  322. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  323. --error 1264
  324. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  325. SELECT * FROM t1;
  326. DROP TABLE t1;
  327. SHOW TABLES;
  328. SET SQL_MODE='';
  329. SET SQL_MODE='TRADITIONAL';
  330. CREATE TABLE t1(c1 SMALLINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
  331. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  332. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  333. SHOW CREATE TABLE t1;
  334. --error 1264
  335. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  336. --error 1264
  337. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  338. SELECT * FROM t1;
  339. DROP TABLE t1;
  340. SHOW TABLES;
  341. SET SQL_MODE='';
  342. SET SQL_MODE='TRADITIONAL';
  343. CREATE TABLE t1(c1 MEDIUMINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
  344. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  345. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  346. SHOW CREATE TABLE t1;
  347. --error 1264
  348. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  349. --error 1264
  350. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  351. SELECT * FROM t1;
  352. DROP TABLE t1;
  353. SHOW TABLES;
  354. SET SQL_MODE='';
  355. SET SQL_MODE='TRADITIONAL';
  356. CREATE TABLE t1(c1 INT AUTO_INCREMENT NOT NULL PRIMARY KEY );
  357. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  358. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  359. SHOW CREATE TABLE t1;
  360. --error 1264
  361. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  362. --error 1264
  363. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  364. SELECT * FROM t1;
  365. DROP TABLE t1;
  366. SHOW TABLES;
  367. SET SQL_MODE='';
  368. SET SQL_MODE='TRADITIONAL';
  369. CREATE TABLE t1(c1 INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY );
  370. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  371. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  372. SHOW CREATE TABLE t1;
  373. --error 1264
  374. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  375. --error 1264
  376. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  377. SELECT * FROM t1;
  378. DROP TABLE t1;
  379. SHOW TABLES;
  380. SET SQL_MODE='';
  381. SET SQL_MODE='TRADITIONAL';
  382. CREATE TABLE t1(c1 BIGINT AUTO_INCREMENT NOT NULL PRIMARY KEY );
  383. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  384. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  385. SHOW CREATE TABLE t1;
  386. --error 1264
  387. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  388. --error 1264
  389. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  390. SELECT * FROM t1;
  391. DROP TABLE t1;
  392. SHOW TABLES;
  393. SET SQL_MODE='';
  394. SET SQL_MODE='TRADITIONAL';
  395. CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL KEY );
  396. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  397. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  398. SHOW CREATE TABLE t1;
  399. --error 1264
  400. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  401. --error 1264
  402. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  403. SELECT * FROM t1;
  404. DROP TABLE t1;
  405. SHOW TABLES;
  406. SET SQL_MODE='';
  407. SET SQL_MODE='TRADITIONAL';
  408. CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL KEY );
  409. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  410. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  411. SHOW CREATE TABLE t1;
  412. --error 1264
  413. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  414. --error 1264
  415. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  416. SELECT * FROM t1;
  417. DROP TABLE t1;
  418. SHOW TABLES;
  419. SET SQL_MODE='';
  420. SET SQL_MODE='TRADITIONAL';
  421. CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL KEY );
  422. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  423. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  424. SHOW CREATE TABLE t1;
  425. --error 1264
  426. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  427. --error 1264
  428. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  429. SELECT * FROM t1;
  430. DROP TABLE t1;
  431. SHOW TABLES;
  432. SET SQL_MODE='';
  433. SET SQL_MODE='TRADITIONAL';
  434. CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL KEY );
  435. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  436. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  437. SHOW CREATE TABLE t1;
  438. --error 1264
  439. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  440. --error 1264
  441. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  442. SELECT * FROM t1;
  443. DROP TABLE t1;
  444. SHOW TABLES;
  445. SET SQL_MODE='';
  446. SET SQL_MODE='TRADITIONAL';
  447. CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL KEY );
  448. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  449. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  450. SHOW CREATE TABLE t1;
  451. --error 1264
  452. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  453. --error 1264
  454. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  455. SELECT * FROM t1;
  456. DROP TABLE t1;
  457. SHOW TABLES;
  458. SET SQL_MODE='';
  459. SET SQL_MODE='TRADITIONAL';
  460. CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL KEY );
  461. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  462. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  463. SHOW CREATE TABLE t1;
  464. --error 1264
  465. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  466. --error 1264
  467. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  468. SELECT * FROM t1;
  469. DROP TABLE t1;
  470. SHOW TABLES;
  471. SET SQL_MODE='';
  472. SET SQL_MODE='TRADITIONAL';
  473. CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
  474. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  475. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  476. SHOW CREATE TABLE t1;
  477. --error 1264
  478. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  479. --error 1264
  480. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  481. SELECT * FROM t1;
  482. DROP TABLE t1;
  483. SHOW TABLES;
  484. SET SQL_MODE='';
  485. SET SQL_MODE='TRADITIONAL';
  486. CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
  487. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  488. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  489. SHOW CREATE TABLE t1;
  490. --error 1264
  491. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  492. --error 1264
  493. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  494. SELECT * FROM t1;
  495. DROP TABLE t1;
  496. SHOW TABLES;
  497. SET SQL_MODE='';
  498. SET SQL_MODE='TRADITIONAL';
  499. CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
  500. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  501. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  502. SHOW CREATE TABLE t1;
  503. --error 1264
  504. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  505. --error 1264
  506. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  507. SELECT * FROM t1;
  508. DROP TABLE t1;
  509. SHOW TABLES;
  510. SET SQL_MODE='';
  511. SET SQL_MODE='TRADITIONAL';
  512. CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
  513. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  514. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  515. SHOW CREATE TABLE t1;
  516. --error 1264
  517. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  518. --error 1264
  519. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  520. SELECT * FROM t1;
  521. DROP TABLE t1;
  522. SHOW TABLES;
  523. SET SQL_MODE='';
  524. SET SQL_MODE='TRADITIONAL';
  525. CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL KEY );
  526. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  527. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  528. SHOW CREATE TABLE t1;
  529. --error 1264
  530. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  531. --error 1264
  532. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  533. SELECT * FROM t1;
  534. DROP TABLE t1;
  535. SHOW TABLES;
  536. SET SQL_MODE='';
  537. SET SQL_MODE='TRADITIONAL';
  538. CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL KEY );
  539. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  540. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  541. SHOW CREATE TABLE t1;
  542. --error 1264
  543. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  544. --error 1264
  545. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  546. SELECT * FROM t1;
  547. DROP TABLE t1;
  548. SHOW TABLES;
  549. SET SQL_MODE='';
  550. SET SQL_MODE='TRADITIONAL';
  551. CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
  552. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  553. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  554. SHOW CREATE TABLE t1;
  555. --error 1264
  556. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  557. --error 1264
  558. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  559. SELECT * FROM t1;
  560. DROP TABLE t1;
  561. SHOW TABLES;
  562. SET SQL_MODE='';
  563. SET SQL_MODE='TRADITIONAL';
  564. CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
  565. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  566. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  567. SHOW CREATE TABLE t1;
  568. --error 1264
  569. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  570. --error 1264
  571. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  572. SELECT * FROM t1;
  573. DROP TABLE t1;
  574. SHOW TABLES;
  575. SET SQL_MODE='';
  576. SET SQL_MODE='TRADITIONAL';
  577. CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
  578. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  579. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  580. SHOW CREATE TABLE t1;
  581. --error 1264
  582. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  583. --error 1264
  584. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  585. SELECT * FROM t1;
  586. DROP TABLE t1;
  587. SHOW TABLES;
  588. SET SQL_MODE='';
  589. SET SQL_MODE='TRADITIONAL';
  590. CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
  591. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  592. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  593. SHOW CREATE TABLE t1;
  594. --error 1264
  595. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  596. --error 1264
  597. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  598. SELECT * FROM t1;
  599. DROP TABLE t1;
  600. SHOW TABLES;
  601. SET SQL_MODE='';
  602. SET SQL_MODE='TRADITIONAL';
  603. CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
  604. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  605. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  606. SHOW CREATE TABLE t1;
  607. --error 1264
  608. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  609. --error 1264
  610. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  611. SELECT * FROM t1;
  612. DROP TABLE t1;
  613. SHOW TABLES;
  614. SET SQL_MODE='';
  615. SET SQL_MODE='TRADITIONAL';
  616. CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NULL UNIQUE KEY );
  617. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  618. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  619. SHOW CREATE TABLE t1;
  620. --error 1264
  621. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  622. --error 1264
  623. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  624. SELECT * FROM t1;
  625. DROP TABLE t1;
  626. SHOW TABLES;
  627. SET SQL_MODE='';
  628. SET SQL_MODE='TRADITIONAL';
  629. CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
  630. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  631. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  632. SHOW CREATE TABLE t1;
  633. --error 1264
  634. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  635. --error 1264
  636. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  637. SELECT * FROM t1;
  638. DROP TABLE t1;
  639. SHOW TABLES;
  640. SET SQL_MODE='';
  641. SET SQL_MODE='TRADITIONAL';
  642. CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
  643. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  644. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  645. SHOW CREATE TABLE t1;
  646. --error 1264
  647. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  648. --error 1264
  649. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  650. SELECT * FROM t1;
  651. DROP TABLE t1;
  652. SHOW TABLES;
  653. SET SQL_MODE='';
  654. SET SQL_MODE='TRADITIONAL';
  655. CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
  656. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  657. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  658. SHOW CREATE TABLE t1;
  659. --error 1264
  660. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  661. --error 1264
  662. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  663. SELECT * FROM t1;
  664. DROP TABLE t1;
  665. SHOW TABLES;
  666. SET SQL_MODE='';
  667. SET SQL_MODE='TRADITIONAL';
  668. CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
  669. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  670. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  671. SHOW CREATE TABLE t1;
  672. --error 1264
  673. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  674. --error 1264
  675. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  676. SELECT * FROM t1;
  677. DROP TABLE t1;
  678. SHOW TABLES;
  679. SET SQL_MODE='';
  680. SET SQL_MODE='TRADITIONAL';
  681. CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
  682. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  683. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  684. SHOW CREATE TABLE t1;
  685. --error 1264
  686. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  687. --error 1264
  688. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  689. SELECT * FROM t1;
  690. DROP TABLE t1;
  691. SHOW TABLES;
  692. SET SQL_MODE='';
  693. SET SQL_MODE='TRADITIONAL';
  694. CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL UNIQUE KEY );
  695. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  696. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  697. SHOW CREATE TABLE t1;
  698. --error 1264
  699. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  700. --error 1264
  701. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  702. SELECT * FROM t1;
  703. DROP TABLE t1;
  704. SHOW TABLES;
  705. SET SQL_MODE='';
  706. SET SQL_MODE='TRADITIONAL';
  707. CREATE TABLE t1(c1 TINYINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
  708. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  709. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  710. SHOW CREATE TABLE t1;
  711. --error 1264
  712. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  713. --error 1264
  714. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  715. SELECT * FROM t1;
  716. DROP TABLE t1;
  717. SHOW TABLES;
  718. SET SQL_MODE='';
  719. SET SQL_MODE='TRADITIONAL';
  720. CREATE TABLE t1(c1 SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
  721. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  722. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  723. SHOW CREATE TABLE t1;
  724. --error 1264
  725. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  726. --error 1264
  727. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  728. SELECT * FROM t1;
  729. DROP TABLE t1;
  730. SHOW TABLES;
  731. SET SQL_MODE='';
  732. SET SQL_MODE='TRADITIONAL';
  733. CREATE TABLE t1(c1 MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
  734. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  735. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  736. SHOW CREATE TABLE t1;
  737. --error 1264
  738. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  739. --error 1264
  740. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  741. SELECT * FROM t1;
  742. DROP TABLE t1;
  743. SHOW TABLES;
  744. SET SQL_MODE='';
  745. SET SQL_MODE='TRADITIONAL';
  746. CREATE TABLE t1(c1 INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
  747. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  748. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  749. SHOW CREATE TABLE t1;
  750. --error 1264
  751. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  752. --error 1264
  753. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  754. SELECT * FROM t1;
  755. DROP TABLE t1;
  756. SHOW TABLES;
  757. SET SQL_MODE='';
  758. SET SQL_MODE='TRADITIONAL';
  759. CREATE TABLE t1(c1 INTEGER UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
  760. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  761. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  762. SHOW CREATE TABLE t1;
  763. --error 1264
  764. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  765. --error 1264
  766. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  767. SELECT * FROM t1;
  768. DROP TABLE t1;
  769. SHOW TABLES;
  770. SET SQL_MODE='';
  771. SET SQL_MODE='TRADITIONAL';
  772. CREATE TABLE t1(c1 BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY );
  773. let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  774. --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  775. SHOW CREATE TABLE t1;
  776. --error 1264
  777. INSERT INTO t1 VALUES(111111111111111111111111111111111111);
  778. --error 1264
  779. INSERT INTO t1 VALUES(-1111111111111111111111111111111111111);
  780. SELECT * FROM t1;
  781. DROP TABLE t1;
  782. SHOW TABLES;
  783. SET SQL_MODE='';