github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/auto_increment/auto_increment.result (about) 1 drop table if exists auto_increment01; 2 create table auto_increment01(col1 int auto_increment primary key)auto_increment = 0; 3 select * from auto_increment01; 4 col1 5 Insert into auto_increment01 values(); 6 select last_insert_id(); 7 last_insert_id() 8 1 9 Select * from auto_increment01; 10 col1 11 1 12 Insert into auto_increment01 values(1); 13 Duplicate entry '1' for key 'col1' 14 Select * from auto_increment01; 15 col1 16 1 17 drop table auto_increment01; 18 Drop table if exists auto_increment02; 19 [unknown result because it is related to issue#10836] 20 Create table auto_increment02(col1 int auto_increment unique key)auto_increment = 10; 21 [unknown result because it is related to issue#10836] 22 Insert into auto_increment02 values(); 23 [unknown result because it is related to issue#10836] 24 Select * from auto_increment02; 25 [unknown result because it is related to issue#10836] 26 Insert into auto_increment02 values(10); 27 [unknown result because it is related to issue#10836] 28 insert into auto_increment02 values(100); 29 [unknown result because it is related to issue#10836] 30 select last_insert_id(); 31 [unknown result because it is related to issue#10836] 32 Select * from auto_increment02; 33 [unknown result because it is related to issue#10836] 34 Drop table auto_increment02; 35 [unknown result because it is related to issue#10836] 36 Drop table if exists auto_increment03; 37 create table auto_increment03(col1 int auto_increment primary key) auto_increment = 10000; 38 Insert into auto_increment03 values(); 39 select last_insert_id(); 40 last_insert_id() 41 10000 42 Insert into auto_increment03 values(10000); 43 Duplicate entry '10000' for key 'col1' 44 Insert into auto_increment03 values(10000); 45 Duplicate entry '10000' for key 'col1' 46 Select * from auto_increment03; 47 col1 48 10000 49 Drop table auto_increment03; 50 Drop table if exists auto_increment04; 51 Create table auto_increment04(col1 int primary key auto_increment) auto_increment = 10; 52 insert into auto_increment04 values(); 53 Select * from auto_increment04; 54 col1 55 10 56 Insert into auto_increment04 values(); 57 select last_insert_id(); 58 last_insert_id() 59 11 60 Insert into auto_increment04 values(100); 61 Insert into auto_increment04 values(200); 62 Insert into auto_increment04 values(10); 63 Duplicate entry '10' for key 'col1' 64 Insert into auto_increment04 values(11); 65 Duplicate entry '11' for key 'col1' 66 Select * from auto_increment04; 67 col1 68 10 69 11 70 100 71 200 72 Drop table auto_increment04; 73 Drop table if exists auto_increment05; 74 Create table auto_increment05(col1 int unique key auto_increment) auto_increment = 10000; 75 Insert into auto_increment05 values(); 76 Insert into auto_increment05 values(); 77 Insert into auto_increment05 values(); 78 select last_insert_id(); 79 last_insert_id() 80 10002 81 Select * from auto_increment05; 82 col1 83 10000 84 10001 85 10002 86 Insert into auto_increment05 values(10001); 87 Duplicate entry '10001' for key '__mo_index_idx_col' 88 Insert into auto_increment05 values(10002); 89 Duplicate entry '10002' for key '__mo_index_idx_col' 90 Select * from auto_increment05; 91 col1 92 10000 93 10001 94 10002 95 Drop table auto_increment05; 96 Drop table if exists auto_increment06; 97 Create table auto_increment06(col1 int auto_increment primary key) auto_increment = 2147483646; 98 Insert into auto_increment06 values(); 99 Insert into auto_increment06 values(); 100 Insert into auto_increment06 values(); 101 Data truncation: data out of range: data type int, value 2147483648 102 select last_insert_id(); 103 last_insert_id() 104 2147483647 105 Select * from auto_increment06; 106 col1 107 2147483646 108 2147483647 109 Insert into auto_increment06 values(10001); 110 Insert into auto_increment06 values(10002); 111 Select * from auto_increment06; 112 col1 113 2147483646 114 2147483647 115 10001 116 10002 117 Drop table auto_increment06; 118 Drop table if exists auto_increment07; 119 Create table auto_increment07(col1 smallint auto_increment primary key) auto_increment = 32766; 120 Insert into auto_increment07 values(); 121 Insert into auto_increment07 values(); 122 Insert into auto_increment07 values(); 123 Data truncation: data out of range: data type smallint, value 32768 124 select last_insert_id(); 125 last_insert_id() 126 32767 127 Select * from auto_increment07; 128 col1 129 32766 130 32767 131 Drop table auto_increment07; 132 Drop table if exists auto_increment08; 133 Create table auto_increment08(col1 bigint auto_increment primary key) auto_increment = 9223372036854775806; 134 Insert into auto_increment08 values(); 135 Insert into auto_increment08 values(); 136 Insert into auto_increment08 values(); 137 Data truncation: data out of range: data type bigint, value 9223372036854775808 138 select last_insert_id(); 139 last_insert_id() 140 9223372036854775807 141 Select * from auto_increment08; 142 col1 143 9223372036854775806 144 9223372036854775807 145 Drop table auto_increment08; 146 Drop table if exists auto_increment09; 147 Create table auto_increment09(col1 tinyint unsigned auto_increment primary key) auto_increment = 254; 148 Insert into auto_increment09 values(); 149 Insert into auto_increment09 values(); 150 Insert into auto_increment09 values(); 151 Data truncation: data out of range: data type tinyint unsigned, value 256 152 select last_insert_id(); 153 last_insert_id() 154 255 155 Select * from auto_increment09; 156 col1 157 254 158 255 159 Drop table auto_increment09; 160 Drop table if exists auto_increment10; 161 [unknown result because it is related to issue#10834] 162 Create table auto_increment10(col1 int auto_increment, col2 int, unique index(col1)) auto_increment = 254; 163 [unknown result because it is related to issue#10834] 164 Insert into auto_increment10(col2) values(100); 165 [unknown result because it is related to issue#10834] 166 Insert into auto_increment10(col2) values(200); 167 [unknown result because it is related to issue#10834] 168 insert into auto_increment10(col2) values(100); 169 [unknown result because it is related to issue#10834] 170 select last_insert_id(); 171 [unknown result because it is related to issue#10834] 172 Select * from auto_increment10; 173 [unknown result because it is related to issue#10834] 174 Drop table auto_increment10; 175 [unknown result because it is related to issue#10834] 176 Drop table if exists auto_increment11; 177 Create table auto_increment11(col1 int auto_increment primary key) auto_increment = 100; 178 insert into auto_increment11 values(); 179 Insert into auto_increment11 values(); 180 Insert into auto_increment11 values(); 181 select last_insert_id(); 182 last_insert_id() 183 102 184 Select * from auto_increment11; 185 col1 186 100 187 101 188 102 189 Delete from auto_increment11 where col1 = 100; 190 Update auto_increment11 set col1 = 200 where col1 = 101; 191 Select * from auto_increment11; 192 col1 193 102 194 200 195 Drop table auto_increment11; 196 Drop table if exists auto_increment12; 197 [unknown result because it is related to issue#10842] 198 create table auto_increment12(col1 int auto_increment primary key)auto_increment = 10; 199 [unknown result because it is related to issue#10842] 200 Insert into auto_increment12 values(); 201 [unknown result because it is related to issue#10842] 202 Insert into auto_increment12 values(); 203 [unknown result because it is related to issue#10842] 204 Select * from auto_increment12; 205 [unknown result because it is related to issue#10842] 206 Insert into auto_increment12 values(16.898291); 207 [unknown result because it is related to issue#10842] 208 insert into auto_increment12 values(124312.4321424324); 209 [unknown result because it is related to issue#10842] 210 insert into auto_increment12 values(); 211 [unknown result because it is related to issue#10842] 212 select last_insert_id(); 213 [unknown result because it is related to issue#10842] 214 Select * from auto_increment12; 215 [unknown result because it is related to issue#10842] 216 Drop table auto_increment12; 217 [unknown result because it is related to issue#10842] 218 Drop table if exists auto_increment10; 219 Create table auto_increment13(col1 int auto_increment primary key)auto_increment = 30000; 220 Insert into auto_increment13 values(); 221 Insert into auto_increment13 values(); 222 select * from auto_increment13; 223 col1 224 30000 225 30001 226 Truncate table auto_increment13; 227 Insert into auto_increment13 values(); 228 select last_insert_id(); 229 last_insert_id() 230 1 231 Insert into auto_increment13 values(10000); 232 Select * from auto_increment13; 233 col1 234 1 235 10000 236 Drop table auto_increment13; 237 Drop table if exists auto_increment14; 238 Create table auto_increment14(col1 int primary key auto_increment, col2 varchar(10))auto_increment = 100; 239 insert into auto_increment14 values (-2147483648, 'aaa'); 240 select * from auto_increment14 order by c; 241 invalid input: column c does not exist 242 insert into auto_increment14 values (-2147483649, 'aaa'); 243 Data truncation: data out of range: data type int32, value '-2147483649' 244 Insert into auto_increment14 values(); 245 Insert into auto_increment14 values(); 246 Select last_insert_id(); 247 last_insert_id() 248 101 249 insert into auto_increment14(col2) values ('22222'); 250 select * from auto_increment14 order by col1; 251 col1 col2 252 -2147483648 aaa 253 100 null 254 101 null 255 102 22222 256 select * from auto_increment14 order by col1 desc; 257 col1 col2 258 102 22222 259 101 null 260 100 null 261 -2147483648 aaa 262 Drop table auto_increment14; 263 drop table if exists auto_increment15; 264 create table auto_increment15( 265 a int primary key auto_increment, 266 b bigint auto_increment, 267 c int auto_increment, 268 d int auto_increment, 269 e bigint auto_increment 270 ); 271 show create table auto_increment15; 272 Table Create Table 273 auto_increment15 CREATE TABLE `auto_increment15` (\n`a` INT NOT NULL AUTO_INCREMENT,\n`b` BIGINT NOT NULL AUTO_INCREMENT,\n`c` INT NOT NULL AUTO_INCREMENT,\n`d` INT NOT NULL AUTO_INCREMENT,\n`e` BIGINT NOT NULL AUTO_INCREMENT,\nPRIMARY KEY (`a`)\n) 274 insert into auto_increment15 values (),(),(),(); 275 select * from auto_increment15 order by a; 276 a b c d e 277 1 1 1 1 1 278 2 2 2 2 2 279 3 3 3 3 3 280 4 4 4 4 4 281 insert into auto_increment15 values (NULL, NULL, NULL, NULL, NULL); 282 select * from auto_increment15 order by a; 283 a b c d e 284 1 1 1 1 1 285 2 2 2 2 2 286 3 3 3 3 3 287 4 4 4 4 4 288 5 5 5 5 5 289 insert into auto_increment15(b,c,d) values (NULL,NULL,NULL); 290 select * from auto_increment15 order by a; 291 a b c d e 292 1 1 1 1 1 293 2 2 2 2 2 294 3 3 3 3 3 295 4 4 4 4 4 296 5 5 5 5 5 297 6 6 6 6 6 298 insert into auto_increment15(a,b) values (100, 400); 299 select * from auto_increment15 order by a; 300 a b c d e 301 1 1 1 1 1 302 2 2 2 2 2 303 3 3 3 3 3 304 4 4 4 4 4 305 5 5 5 5 5 306 6 6 6 6 6 307 100 400 7 7 7 308 insert into auto_increment15(c,d,e) values (200, 200, 200); 309 select * from auto_increment15; 310 a b c d e 311 1 1 1 1 1 312 2 2 2 2 2 313 3 3 3 3 3 314 4 4 4 4 4 315 5 5 5 5 5 316 6 6 6 6 6 317 100 400 7 7 7 318 101 401 200 200 200 319 insert into auto_increment15(c,d,e) values (200, 400, 600); 320 select * from auto_increment15; 321 a b c d e 322 1 1 1 1 1 323 2 2 2 2 2 324 3 3 3 3 3 325 4 4 4 4 4 326 5 5 5 5 5 327 6 6 6 6 6 328 100 400 7 7 7 329 101 401 200 200 200 330 102 402 200 400 600 331 Drop table auto_increment15; 332 Drop table if exists auto_increment16; 333 Create table auto_increment16(col1 int auto_increment)auto_increment < 0; 334 SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 70 near " < 0;"; 335 Drop table auto_increment16; 336 no such table auto_increment.auto_increment16 337 drop table if exists auto_increment01; 338 [unknown result because it is related to issue#10903] 339 create temporary table auto_increment01(col1 int auto_increment primary key)auto_increment = 0; 340 [unknown result because it is related to issue#10903] 341 select * from auto_increment01; 342 [unknown result because it is related to issue#10903] 343 Insert into auto_increment01 values(); 344 [unknown result because it is related to issue#10903] 345 select last_insert_id(); 346 [unknown result because it is related to issue#10903] 347 Select * from auto_increment01; 348 [unknown result because it is related to issue#10903] 349 Insert into auto_increment01 values(1); 350 [unknown result because it is related to issue#10903] 351 Select * from auto_increment01; 352 [unknown result because it is related to issue#10903] 353 drop table auto_increment01; 354 [unknown result because it is related to issue#10903] 355 Drop table if exists auto_increment02; 356 [unknown result because it is related to issue#10836] 357 Create temporary table auto_increment02(col1 int auto_increment unique key)auto_increment = 10; 358 [unknown result because it is related to issue#10836] 359 Insert into auto_increment02 values(); 360 [unknown result because it is related to issue#10836] 361 select last_insert_id(); 362 [unknown result because it is related to issue#10836] 363 Select * from auto_increment02; 364 [unknown result because it is related to issue#10836] 365 Insert into auto_increment02 values(10); 366 [unknown result because it is related to issue#10836] 367 insert into auto_increment02 values(100); 368 [unknown result because it is related to issue#10836] 369 Select * from auto_increment02; 370 [unknown result because it is related to issue#10836] 371 Drop table auto_increment02; 372 [unknown result because it is related to issue#10836] 373 Drop table if exists auto_increment03; 374 [unknown result because it is related to issue#10903] 375 create temporary table auto_increment03(col1 int auto_increment primary key) auto_increment = 10000; 376 [unknown result because it is related to issue#10903] 377 Insert into auto_increment03 values(); 378 [unknown result because it is related to issue#10903] 379 Insert into auto_increment03 values(10000); 380 [unknown result because it is related to issue#10903] 381 Insert into auto_increment03 values(10000); 382 [unknown result because it is related to issue#10903] 383 Insert into auto_increment03 values(); 384 [unknown result because it is related to issue#10903] 385 select last_insert_id(); 386 [unknown result because it is related to issue#10903] 387 Select * from auto_increment03; 388 [unknown result because it is related to issue#10903] 389 Drop table auto_increment03; 390 [unknown result because it is related to issue#10903] 391 Drop table if exists auto_increment04; 392 [unknown result because it is related to issue#10903] 393 Create temporary table auto_increment04(col1 int primary key auto_increment) auto_increment = 10; 394 [unknown result because it is related to issue#10903] 395 insert into auto_increment04 values(); 396 [unknown result because it is related to issue#10903] 397 Select * from auto_increment04; 398 [unknown result because it is related to issue#10903] 399 Insert into auto_increment04 values(); 400 [unknown result because it is related to issue#10903] 401 select last_insert_id(); 402 [unknown result because it is related to issue#10903] 403 Insert into auto_increment04 values(100); 404 [unknown result because it is related to issue#10903] 405 Insert into auto_increment04 values(200); 406 [unknown result because it is related to issue#10903] 407 Insert into auto_increment04 values(10); 408 [unknown result because it is related to issue#10903] 409 Insert into auto_increment04 values(11); 410 [unknown result because it is related to issue#10903] 411 Select * from auto_increment04; 412 [unknown result because it is related to issue#10903] 413 Drop table auto_increment04; 414 [unknown result because it is related to issue#10903] 415 Drop table if exists auto_increment05; 416 [unknown result because it is related to issue#10834] 417 Create temporary table auto_increment05(col1 int unique key auto_increment) auto_increment = 10000; 418 [unknown result because it is related to issue#10834] 419 Insert into auto_increment05 values(); 420 [unknown result because it is related to issue#10834] 421 Insert into auto_increment05 values(); 422 [unknown result because it is related to issue#10834] 423 Insert into auto_increment05 values(); 424 [unknown result because it is related to issue#10834] 425 select last_insert_id(); 426 [unknown result because it is related to issue#10834] 427 Select * from auto_increment05; 428 [unknown result because it is related to issue#10834] 429 Insert into auto_increment05 values(10001); 430 [unknown result because it is related to issue#10834] 431 Insert into auto_increment05 values(10002); 432 [unknown result because it is related to issue#10834] 433 Select * from auto_increment05; 434 [unknown result because it is related to issue#10834] 435 Drop table auto_increment05; 436 [unknown result because it is related to issue#10834] 437 Drop table if exists auto_increment06; 438 [unknown result because it is related to issue#10834] 439 Create temporary table auto_increment06(col1 int unsigned auto_increment primary key) auto_increment = 2147483646; 440 [unknown result because it is related to issue#10834] 441 Insert into auto_increment06 values(); 442 [unknown result because it is related to issue#10834] 443 Insert into auto_increment06 values(); 444 [unknown result because it is related to issue#10834] 445 Insert into auto_increment06 values(); 446 [unknown result because it is related to issue#10834] 447 select last_insert_id(); 448 [unknown result because it is related to issue#10834] 449 Select * from auto_increment06; 450 [unknown result because it is related to issue#10834] 451 Insert into auto_increment06 values(10001); 452 [unknown result because it is related to issue#10834] 453 Insert into auto_increment06 values(10002); 454 [unknown result because it is related to issue#10834] 455 Select * from auto_increment06; 456 [unknown result because it is related to issue#10834] 457 Drop table auto_increment06; 458 [unknown result because it is related to issue#10834] 459 Drop table if exists auto_increment07; 460 [unknown result because it is related to issue#10834] 461 Create table auto_increment07(col1 smallint unsigned auto_increment primary key) auto_increment = 65534; 462 [unknown result because it is related to issue#10834] 463 Insert into auto_increment07 values(); 464 [unknown result because it is related to issue#10834] 465 Insert into auto_increment07 values(); 466 [unknown result because it is related to issue#10834] 467 Insert into auto_increment07 values(); 468 [unknown result because it is related to issue#10834] 469 Insert into auto_increment07 values(); 470 [unknown result because it is related to issue#10834] 471 select last_insert_id(); 472 [unknown result because it is related to issue#10834] 473 Select * from auto_increment07; 474 [unknown result because it is related to issue#10834] 475 Drop table auto_increment07; 476 [unknown result because it is related to issue#10834] 477 Drop table if exists auto_increment08; 478 [unknown result because it is related to issue#10834] 479 Create table auto_increment08(col1 bigint unsigned auto_increment primary key) auto_increment = 9223372036854775806; 480 [unknown result because it is related to issue#10834] 481 Insert into auto_increment08 values(); 482 [unknown result because it is related to issue#10834] 483 Insert into auto_increment08 values(); 484 [unknown result because it is related to issue#10834] 485 Insert into auto_increment08 values(); 486 [unknown result because it is related to issue#10834] 487 select last_insert_id(); 488 [unknown result because it is related to issue#10834] 489 Select * from auto_increment08; 490 [unknown result because it is related to issue#10834] 491 Drop table auto_increment08; 492 [unknown result because it is related to issue#10834] 493 Drop table if exists auto_increment09; 494 [unknown result because it is related to issue#10834] 495 Create table auto_increment09(col1 tinyint auto_increment primary key) auto_increment = 254; 496 [unknown result because it is related to issue#10834] 497 Insert into auto_increment09 values(); 498 [unknown result because it is related to issue#10834] 499 Insert into auto_increment09 values(); 500 [unknown result because it is related to issue#10834] 501 Insert into auto_increment09 values(); 502 [unknown result because it is related to issue#10834] 503 select last_insert_id(); 504 [unknown result because it is related to issue#10834] 505 Select * from auto_increment09; 506 [unknown result because it is related to issue#10834] 507 Drop table auto_increment09; 508 [unknown result because it is related to issue#10834] 509 Drop table if exists auto_increment10; 510 [unknown result because it is related to issue#10834] 511 Create temporary table auto_increment10(col1 int auto_increment, col2 int, unique index(col1)) auto_increment = 3267183; 512 [unknown result because it is related to issue#10834] 513 Insert into auto_increment10(col2) values(100); 514 [unknown result because it is related to issue#10834] 515 Insert into auto_increment10(col2) values(200); 516 [unknown result because it is related to issue#10834] 517 insert into auto_increment10(col2) values(100); 518 [unknown result because it is related to issue#10834] 519 select last_insert_id(); 520 [unknown result because it is related to issue#10834] 521 Select * from auto_increment10; 522 [unknown result because it is related to issue#10834] 523 Drop table auto_increment10; 524 [unknown result because it is related to issue#10834] 525 Drop table if exists auto_increment11; 526 [unknown result because it is related to issue#10903] 527 Create temporary table auto_increment11(col1 int auto_increment primary key) auto_increment = 100; 528 [unknown result because it is related to issue#10903] 529 insert into auto_increment11 values(); 530 [unknown result because it is related to issue#10903] 531 Insert into auto_increment11 values(); 532 [unknown result because it is related to issue#10903] 533 Insert into auto_increment11 values(); 534 [unknown result because it is related to issue#10903] 535 select last_insert_id(); 536 [unknown result because it is related to issue#10903] 537 Select * from auto_increment11; 538 [unknown result because it is related to issue#10903] 539 Delete from auto_increment11 where col1 = 100; 540 [unknown result because it is related to issue#10903] 541 Update auto_increment11 set col1 = 200 where col1 = 101; 542 [unknown result because it is related to issue#10834] 543 Select * from auto_increment11; 544 [unknown result because it is related to issue#10834] 545 Drop table auto_increment11; 546 [unknown result because it is related to issue#10834] 547 Drop table if exists auto_increment12; 548 [unknown result because it is related to issue#10842] 549 create temporary table auto_increment12(col1 int auto_increment primary key)auto_increment = 10; 550 [unknown result because it is related to issue#10842] 551 Insert into auto_increment12 values(); 552 [unknown result because it is related to issue#10842] 553 Insert into auto_increment12 values(); 554 [unknown result because it is related to issue#10842] 555 Select * from auto_increment12; 556 [unknown result because it is related to issue#10842] 557 Insert into auto_increment12 values(16.898291); 558 [unknown result because it is related to issue#10842] 559 insert into auto_increment12 values(); 560 [unknown result because it is related to issue#10842] 561 select last_insert_id(); 562 [unknown result because it is related to issue#10842] 563 Select * from auto_increment12; 564 [unknown result because it is related to issue#10842] 565 Drop table auto_increment12; 566 [unknown result because it is related to issue#10842] 567 Drop table if exists auto_increment13; 568 Create table auto_increment13(col1 int auto_increment primary key)auto_increment = 30000; 569 Insert into auto_increment13 values(); 570 Insert into auto_increment13 values(); 571 select * from auto_increment13; 572 col1 573 30000 574 30001 575 Truncate table auto_increment13; 576 Insert into auto_increment13 values(); 577 select last_insert_id(); 578 last_insert_id() 579 1 580 Insert into auto_increment13 values(10000); 581 Select * from auto_increment13; 582 col1 583 1 584 10000 585 Drop table auto_increment13; 586 Drop table if exists auto_increment14; 587 Create table auto_increment14(col1 int primary key auto_increment, col2 varchar(10))auto_increment = 100; 588 insert into auto_increment14 values (-2147483648, 'aaa'); 589 select * from auto_increment14 order by c; 590 invalid input: column c does not exist 591 insert into auto_increment14 values (-2147483649, 'aaa'); 592 Data truncation: data out of range: data type int32, value '-2147483649' 593 Insert into auto_increment14 values(); 594 Insert into auto_increment14 values(); 595 Select last_insert_id(); 596 last_insert_id() 597 101 598 insert into auto_increment14(col2) values ('22222'); 599 select * from auto_increment14 order by col1; 600 col1 col2 601 -2147483648 aaa 602 100 null 603 101 null 604 102 22222 605 select * from auto_increment14 order by col1 desc; 606 col1 col2 607 102 22222 608 101 null 609 100 null 610 -2147483648 aaa 611 Drop table auto_increment14; 612 drop table if exists auto_increment15; 613 create temporary table auto_increment15( 614 a int primary key auto_increment, 615 b bigint auto_increment, 616 c int auto_increment, 617 d int auto_increment, 618 e bigint auto_increment 619 )auto_increment = 100; 620 show create table auto_increment15; 621 Table Create Table 622 auto_increment15 CREATE TABLE `auto_increment15` (\n`a` INT NOT NULL AUTO_INCREMENT,\n`b` BIGINT NOT NULL AUTO_INCREMENT,\n`c` INT NOT NULL AUTO_INCREMENT,\n`d` INT NOT NULL AUTO_INCREMENT,\n`e` BIGINT NOT NULL AUTO_INCREMENT,\nPRIMARY KEY (`a`)\n) 623 insert into auto_increment15 values (),(),(),(); 624 select * from auto_increment15 order by a; 625 a b c d e 626 100 100 100 100 100 627 101 101 101 101 101 628 102 102 102 102 102 629 103 103 103 103 103 630 insert into auto_increment15 values (NULL, NULL, NULL, NULL, NULL); 631 select * from auto_increment15 order by a; 632 a b c d e 633 100 100 100 100 100 634 101 101 101 101 101 635 102 102 102 102 102 636 103 103 103 103 103 637 104 104 104 104 104 638 insert into auto_increment15(b,c,d) values (NULL,NULL,NULL); 639 select * from auto_increment15 order by a; 640 a b c d e 641 100 100 100 100 100 642 101 101 101 101 101 643 102 102 102 102 102 644 103 103 103 103 103 645 104 104 104 104 104 646 105 105 105 105 105 647 insert into auto_increment15(a,b) values (100, 400); 648 tae data: duplicate 649 select * from auto_increment15 order by a; 650 a b c d e 651 100 100 100 100 100 652 101 101 101 101 101 653 102 102 102 102 102 654 103 103 103 103 103 655 104 104 104 104 104 656 105 105 105 105 105 657 insert into auto_increment15(c,d,e) values (200, 200, 200); 658 select * from auto_increment15; 659 a b c d e 660 100 100 100 100 100 661 101 101 101 101 101 662 102 102 102 102 102 663 103 103 103 103 103 664 104 104 104 104 104 665 105 105 105 105 105 666 106 401 200 200 200 667 insert into auto_increment15(c,d,e) values (200, 400, 600); 668 select * from auto_increment15; 669 a b c d e 670 100 100 100 100 100 671 101 101 101 101 101 672 102 102 102 102 102 673 103 103 103 103 103 674 104 104 104 104 104 675 105 105 105 105 105 676 106 401 200 200 200 677 107 402 200 400 600 678 Drop table auto_increment15; 679 Drop table if exists auto_increment16; 680 Create temporary table auto_increment16(col1 int auto_increment)auto_increment < 0; 681 SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 80 near " < 0;"; 682 Drop table auto_increment16; 683 no such table auto_increment.auto_increment16 684 drop table if exists auto_increment17; 685 set global auto_increment_offset= 10; 686 create table auto_increment17(col1 int auto_increment); 687 insert into auto_increment17 values(); 688 select * from auto_increment17; 689 col1 690 10 691 drop table auto_increment17; 692 set auto_increment_offset = 100; 693 create table auto_increment17(col1 int auto_increment); 694 insert into auto_increment17 values(); 695 select * from auto_increment17; 696 col1 697 100 698 drop table auto_increment17; 699 set auto_increment_offset = 1; 700 set global auto_increment_offset= 1;