1### Test int for: tinyint, , null 2create table t ( 3id tinyint primary key, 4x tinyint null 5) engine = tokudb; 6insert into t values (1,0), (2,0), (3,0); 7select * from t; 8id x 91 0 102 0 113 0 12update t set x = 100 where id = 2; 13select * from t; 14id x 151 0 162 100 173 0 18update t set x = x + 1 where id = 3; 19select * from t; 20id x 211 0 222 100 233 1 24update t set x = x - 1 where id = 3; 25select * from t; 26id x 271 0 282 100 293 0 30update t set x = x + 100 where id = 3; 31select * from t; 32id x 331 0 342 100 353 100 36update t set x = x - 100 where id = 3; 37select * from t; 38id x 391 0 402 100 413 0 42update t set x = 1 + x where id = 1; 43ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 44update t set x = -x where id = 1; 45ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 46update t set x = x + 1 where id = 100; 47select * from t; 48id x 491 0 502 100 513 0 52update t set x = x + 1 where 1 <= id and id < 100; 53ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 54update t set x = x + 1; 55ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 56drop table t; 57### Test int for: tinyint, , not null 58create table t ( 59id tinyint primary key, 60x tinyint not null 61) engine = tokudb; 62insert into t values (1,0), (2,0), (3,0); 63select * from t; 64id x 651 0 662 0 673 0 68update t set x = 100 where id = 2; 69select * from t; 70id x 711 0 722 100 733 0 74update t set x = x + 1 where id = 3; 75select * from t; 76id x 771 0 782 100 793 1 80update t set x = x - 1 where id = 3; 81select * from t; 82id x 831 0 842 100 853 0 86update t set x = x + 100 where id = 3; 87select * from t; 88id x 891 0 902 100 913 100 92update t set x = x - 100 where id = 3; 93select * from t; 94id x 951 0 962 100 973 0 98update t set x = 1 + x where id = 1; 99ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 100update t set x = -x where id = 1; 101ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 102update t set x = x + 1 where id = 100; 103select * from t; 104id x 1051 0 1062 100 1073 0 108update t set x = x + 1 where 1 <= id and id < 100; 109ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 110update t set x = x + 1; 111ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 112drop table t; 113### Test int for: tinyint, unsigned, null 114create table t ( 115id tinyint unsigned primary key, 116x tinyint unsigned null 117) engine = tokudb; 118insert into t values (1,0), (2,0), (3,0); 119select * from t; 120id x 1211 0 1222 0 1233 0 124update t set x = 100 where id = 2; 125select * from t; 126id x 1271 0 1282 100 1293 0 130update t set x = x + 1 where id = 3; 131select * from t; 132id x 1331 0 1342 100 1353 1 136update t set x = x - 1 where id = 3; 137select * from t; 138id x 1391 0 1402 100 1413 0 142update t set x = x + 100 where id = 3; 143select * from t; 144id x 1451 0 1462 100 1473 100 148update t set x = x - 100 where id = 3; 149select * from t; 150id x 1511 0 1522 100 1533 0 154update t set x = 1 + x where id = 1; 155ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 156update t set x = -x where id = 1; 157ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 158update t set x = x + 1 where id = 100; 159select * from t; 160id x 1611 0 1622 100 1633 0 164update t set x = x + 1 where 1 <= id and id < 100; 165ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 166update t set x = x + 1; 167ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 168drop table t; 169### Test int for: tinyint, unsigned, not null 170create table t ( 171id tinyint unsigned primary key, 172x tinyint unsigned not null 173) engine = tokudb; 174insert into t values (1,0), (2,0), (3,0); 175select * from t; 176id x 1771 0 1782 0 1793 0 180update t set x = 100 where id = 2; 181select * from t; 182id x 1831 0 1842 100 1853 0 186update t set x = x + 1 where id = 3; 187select * from t; 188id x 1891 0 1902 100 1913 1 192update t set x = x - 1 where id = 3; 193select * from t; 194id x 1951 0 1962 100 1973 0 198update t set x = x + 100 where id = 3; 199select * from t; 200id x 2011 0 2022 100 2033 100 204update t set x = x - 100 where id = 3; 205select * from t; 206id x 2071 0 2082 100 2093 0 210update t set x = 1 + x where id = 1; 211ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 212update t set x = -x where id = 1; 213ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 214update t set x = x + 1 where id = 100; 215select * from t; 216id x 2171 0 2182 100 2193 0 220update t set x = x + 1 where 1 <= id and id < 100; 221ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 222update t set x = x + 1; 223ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 224drop table t; 225### Test int for: smallint, , null 226create table t ( 227id smallint primary key, 228x smallint null 229) engine = tokudb; 230insert into t values (1,0), (2,0), (3,0); 231select * from t; 232id x 2331 0 2342 0 2353 0 236update t set x = 100 where id = 2; 237select * from t; 238id x 2391 0 2402 100 2413 0 242update t set x = x + 1 where id = 3; 243select * from t; 244id x 2451 0 2462 100 2473 1 248update t set x = x - 1 where id = 3; 249select * from t; 250id x 2511 0 2522 100 2533 0 254update t set x = x + 100 where id = 3; 255select * from t; 256id x 2571 0 2582 100 2593 100 260update t set x = x - 100 where id = 3; 261select * from t; 262id x 2631 0 2642 100 2653 0 266update t set x = 1 + x where id = 1; 267ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 268update t set x = -x where id = 1; 269ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 270update t set x = x + 1 where id = 100; 271select * from t; 272id x 2731 0 2742 100 2753 0 276update t set x = x + 1 where 1 <= id and id < 100; 277ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 278update t set x = x + 1; 279ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 280drop table t; 281### Test int for: smallint, , not null 282create table t ( 283id smallint primary key, 284x smallint not null 285) engine = tokudb; 286insert into t values (1,0), (2,0), (3,0); 287select * from t; 288id x 2891 0 2902 0 2913 0 292update t set x = 100 where id = 2; 293select * from t; 294id x 2951 0 2962 100 2973 0 298update t set x = x + 1 where id = 3; 299select * from t; 300id x 3011 0 3022 100 3033 1 304update t set x = x - 1 where id = 3; 305select * from t; 306id x 3071 0 3082 100 3093 0 310update t set x = x + 100 where id = 3; 311select * from t; 312id x 3131 0 3142 100 3153 100 316update t set x = x - 100 where id = 3; 317select * from t; 318id x 3191 0 3202 100 3213 0 322update t set x = 1 + x where id = 1; 323ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 324update t set x = -x where id = 1; 325ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 326update t set x = x + 1 where id = 100; 327select * from t; 328id x 3291 0 3302 100 3313 0 332update t set x = x + 1 where 1 <= id and id < 100; 333ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 334update t set x = x + 1; 335ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 336drop table t; 337### Test int for: smallint, unsigned, null 338create table t ( 339id smallint unsigned primary key, 340x smallint unsigned null 341) engine = tokudb; 342insert into t values (1,0), (2,0), (3,0); 343select * from t; 344id x 3451 0 3462 0 3473 0 348update t set x = 100 where id = 2; 349select * from t; 350id x 3511 0 3522 100 3533 0 354update t set x = x + 1 where id = 3; 355select * from t; 356id x 3571 0 3582 100 3593 1 360update t set x = x - 1 where id = 3; 361select * from t; 362id x 3631 0 3642 100 3653 0 366update t set x = x + 100 where id = 3; 367select * from t; 368id x 3691 0 3702 100 3713 100 372update t set x = x - 100 where id = 3; 373select * from t; 374id x 3751 0 3762 100 3773 0 378update t set x = 1 + x where id = 1; 379ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 380update t set x = -x where id = 1; 381ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 382update t set x = x + 1 where id = 100; 383select * from t; 384id x 3851 0 3862 100 3873 0 388update t set x = x + 1 where 1 <= id and id < 100; 389ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 390update t set x = x + 1; 391ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 392drop table t; 393### Test int for: smallint, unsigned, not null 394create table t ( 395id smallint unsigned primary key, 396x smallint unsigned not null 397) engine = tokudb; 398insert into t values (1,0), (2,0), (3,0); 399select * from t; 400id x 4011 0 4022 0 4033 0 404update t set x = 100 where id = 2; 405select * from t; 406id x 4071 0 4082 100 4093 0 410update t set x = x + 1 where id = 3; 411select * from t; 412id x 4131 0 4142 100 4153 1 416update t set x = x - 1 where id = 3; 417select * from t; 418id x 4191 0 4202 100 4213 0 422update t set x = x + 100 where id = 3; 423select * from t; 424id x 4251 0 4262 100 4273 100 428update t set x = x - 100 where id = 3; 429select * from t; 430id x 4311 0 4322 100 4333 0 434update t set x = 1 + x where id = 1; 435ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 436update t set x = -x where id = 1; 437ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 438update t set x = x + 1 where id = 100; 439select * from t; 440id x 4411 0 4422 100 4433 0 444update t set x = x + 1 where 1 <= id and id < 100; 445ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 446update t set x = x + 1; 447ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 448drop table t; 449### Test int for: mediumint, , null 450create table t ( 451id mediumint primary key, 452x mediumint null 453) engine = tokudb; 454insert into t values (1,0), (2,0), (3,0); 455select * from t; 456id x 4571 0 4582 0 4593 0 460update t set x = 100 where id = 2; 461select * from t; 462id x 4631 0 4642 100 4653 0 466update t set x = x + 1 where id = 3; 467select * from t; 468id x 4691 0 4702 100 4713 1 472update t set x = x - 1 where id = 3; 473select * from t; 474id x 4751 0 4762 100 4773 0 478update t set x = x + 100 where id = 3; 479select * from t; 480id x 4811 0 4822 100 4833 100 484update t set x = x - 100 where id = 3; 485select * from t; 486id x 4871 0 4882 100 4893 0 490update t set x = 1 + x where id = 1; 491ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 492update t set x = -x where id = 1; 493ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 494update t set x = x + 1 where id = 100; 495select * from t; 496id x 4971 0 4982 100 4993 0 500update t set x = x + 1 where 1 <= id and id < 100; 501ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 502update t set x = x + 1; 503ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 504drop table t; 505### Test int for: mediumint, , not null 506create table t ( 507id mediumint primary key, 508x mediumint not null 509) engine = tokudb; 510insert into t values (1,0), (2,0), (3,0); 511select * from t; 512id x 5131 0 5142 0 5153 0 516update t set x = 100 where id = 2; 517select * from t; 518id x 5191 0 5202 100 5213 0 522update t set x = x + 1 where id = 3; 523select * from t; 524id x 5251 0 5262 100 5273 1 528update t set x = x - 1 where id = 3; 529select * from t; 530id x 5311 0 5322 100 5333 0 534update t set x = x + 100 where id = 3; 535select * from t; 536id x 5371 0 5382 100 5393 100 540update t set x = x - 100 where id = 3; 541select * from t; 542id x 5431 0 5442 100 5453 0 546update t set x = 1 + x where id = 1; 547ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 548update t set x = -x where id = 1; 549ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 550update t set x = x + 1 where id = 100; 551select * from t; 552id x 5531 0 5542 100 5553 0 556update t set x = x + 1 where 1 <= id and id < 100; 557ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 558update t set x = x + 1; 559ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 560drop table t; 561### Test int for: mediumint, unsigned, null 562create table t ( 563id mediumint unsigned primary key, 564x mediumint unsigned null 565) engine = tokudb; 566insert into t values (1,0), (2,0), (3,0); 567select * from t; 568id x 5691 0 5702 0 5713 0 572update t set x = 100 where id = 2; 573select * from t; 574id x 5751 0 5762 100 5773 0 578update t set x = x + 1 where id = 3; 579select * from t; 580id x 5811 0 5822 100 5833 1 584update t set x = x - 1 where id = 3; 585select * from t; 586id x 5871 0 5882 100 5893 0 590update t set x = x + 100 where id = 3; 591select * from t; 592id x 5931 0 5942 100 5953 100 596update t set x = x - 100 where id = 3; 597select * from t; 598id x 5991 0 6002 100 6013 0 602update t set x = 1 + x where id = 1; 603ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 604update t set x = -x where id = 1; 605ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 606update t set x = x + 1 where id = 100; 607select * from t; 608id x 6091 0 6102 100 6113 0 612update t set x = x + 1 where 1 <= id and id < 100; 613ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 614update t set x = x + 1; 615ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 616drop table t; 617### Test int for: mediumint, unsigned, not null 618create table t ( 619id mediumint unsigned primary key, 620x mediumint unsigned not null 621) engine = tokudb; 622insert into t values (1,0), (2,0), (3,0); 623select * from t; 624id x 6251 0 6262 0 6273 0 628update t set x = 100 where id = 2; 629select * from t; 630id x 6311 0 6322 100 6333 0 634update t set x = x + 1 where id = 3; 635select * from t; 636id x 6371 0 6382 100 6393 1 640update t set x = x - 1 where id = 3; 641select * from t; 642id x 6431 0 6442 100 6453 0 646update t set x = x + 100 where id = 3; 647select * from t; 648id x 6491 0 6502 100 6513 100 652update t set x = x - 100 where id = 3; 653select * from t; 654id x 6551 0 6562 100 6573 0 658update t set x = 1 + x where id = 1; 659ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 660update t set x = -x where id = 1; 661ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 662update t set x = x + 1 where id = 100; 663select * from t; 664id x 6651 0 6662 100 6673 0 668update t set x = x + 1 where 1 <= id and id < 100; 669ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 670update t set x = x + 1; 671ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 672drop table t; 673### Test int for: int, , null 674create table t ( 675id int primary key, 676x int null 677) engine = tokudb; 678insert into t values (1,0), (2,0), (3,0); 679select * from t; 680id x 6811 0 6822 0 6833 0 684update t set x = 100 where id = 2; 685select * from t; 686id x 6871 0 6882 100 6893 0 690update t set x = x + 1 where id = 3; 691select * from t; 692id x 6931 0 6942 100 6953 1 696update t set x = x - 1 where id = 3; 697select * from t; 698id x 6991 0 7002 100 7013 0 702update t set x = x + 100 where id = 3; 703select * from t; 704id x 7051 0 7062 100 7073 100 708update t set x = x - 100 where id = 3; 709select * from t; 710id x 7111 0 7122 100 7133 0 714update t set x = 1 + x where id = 1; 715ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 716update t set x = -x where id = 1; 717ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 718update t set x = x + 1 where id = 100; 719select * from t; 720id x 7211 0 7222 100 7233 0 724update t set x = x + 1 where 1 <= id and id < 100; 725ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 726update t set x = x + 1; 727ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 728drop table t; 729### Test int for: int, , not null 730create table t ( 731id int primary key, 732x int not null 733) engine = tokudb; 734insert into t values (1,0), (2,0), (3,0); 735select * from t; 736id x 7371 0 7382 0 7393 0 740update t set x = 100 where id = 2; 741select * from t; 742id x 7431 0 7442 100 7453 0 746update t set x = x + 1 where id = 3; 747select * from t; 748id x 7491 0 7502 100 7513 1 752update t set x = x - 1 where id = 3; 753select * from t; 754id x 7551 0 7562 100 7573 0 758update t set x = x + 100 where id = 3; 759select * from t; 760id x 7611 0 7622 100 7633 100 764update t set x = x - 100 where id = 3; 765select * from t; 766id x 7671 0 7682 100 7693 0 770update t set x = 1 + x where id = 1; 771ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 772update t set x = -x where id = 1; 773ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 774update t set x = x + 1 where id = 100; 775select * from t; 776id x 7771 0 7782 100 7793 0 780update t set x = x + 1 where 1 <= id and id < 100; 781ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 782update t set x = x + 1; 783ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 784drop table t; 785### Test int for: int, unsigned, null 786create table t ( 787id int unsigned primary key, 788x int unsigned null 789) engine = tokudb; 790insert into t values (1,0), (2,0), (3,0); 791select * from t; 792id x 7931 0 7942 0 7953 0 796update t set x = 100 where id = 2; 797select * from t; 798id x 7991 0 8002 100 8013 0 802update t set x = x + 1 where id = 3; 803select * from t; 804id x 8051 0 8062 100 8073 1 808update t set x = x - 1 where id = 3; 809select * from t; 810id x 8111 0 8122 100 8133 0 814update t set x = x + 100 where id = 3; 815select * from t; 816id x 8171 0 8182 100 8193 100 820update t set x = x - 100 where id = 3; 821select * from t; 822id x 8231 0 8242 100 8253 0 826update t set x = 1 + x where id = 1; 827ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 828update t set x = -x where id = 1; 829ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 830update t set x = x + 1 where id = 100; 831select * from t; 832id x 8331 0 8342 100 8353 0 836update t set x = x + 1 where 1 <= id and id < 100; 837ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 838update t set x = x + 1; 839ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 840drop table t; 841### Test int for: int, unsigned, not null 842create table t ( 843id int unsigned primary key, 844x int unsigned not null 845) engine = tokudb; 846insert into t values (1,0), (2,0), (3,0); 847select * from t; 848id x 8491 0 8502 0 8513 0 852update t set x = 100 where id = 2; 853select * from t; 854id x 8551 0 8562 100 8573 0 858update t set x = x + 1 where id = 3; 859select * from t; 860id x 8611 0 8622 100 8633 1 864update t set x = x - 1 where id = 3; 865select * from t; 866id x 8671 0 8682 100 8693 0 870update t set x = x + 100 where id = 3; 871select * from t; 872id x 8731 0 8742 100 8753 100 876update t set x = x - 100 where id = 3; 877select * from t; 878id x 8791 0 8802 100 8813 0 882update t set x = 1 + x where id = 1; 883ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 884update t set x = -x where id = 1; 885ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 886update t set x = x + 1 where id = 100; 887select * from t; 888id x 8891 0 8902 100 8913 0 892update t set x = x + 1 where 1 <= id and id < 100; 893ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 894update t set x = x + 1; 895ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 896drop table t; 897### Test int for: bigint, , null 898create table t ( 899id bigint primary key, 900x bigint null 901) engine = tokudb; 902insert into t values (1,0), (2,0), (3,0); 903select * from t; 904id x 9051 0 9062 0 9073 0 908update t set x = 100 where id = 2; 909select * from t; 910id x 9111 0 9122 100 9133 0 914update t set x = x + 1 where id = 3; 915select * from t; 916id x 9171 0 9182 100 9193 1 920update t set x = x - 1 where id = 3; 921select * from t; 922id x 9231 0 9242 100 9253 0 926update t set x = x + 100 where id = 3; 927select * from t; 928id x 9291 0 9302 100 9313 100 932update t set x = x - 100 where id = 3; 933select * from t; 934id x 9351 0 9362 100 9373 0 938update t set x = 1 + x where id = 1; 939ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 940update t set x = -x where id = 1; 941ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 942update t set x = x + 1 where id = 100; 943select * from t; 944id x 9451 0 9462 100 9473 0 948update t set x = x + 1 where 1 <= id and id < 100; 949ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 950update t set x = x + 1; 951ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 952drop table t; 953### Test int for: bigint, , not null 954create table t ( 955id bigint primary key, 956x bigint not null 957) engine = tokudb; 958insert into t values (1,0), (2,0), (3,0); 959select * from t; 960id x 9611 0 9622 0 9633 0 964update t set x = 100 where id = 2; 965select * from t; 966id x 9671 0 9682 100 9693 0 970update t set x = x + 1 where id = 3; 971select * from t; 972id x 9731 0 9742 100 9753 1 976update t set x = x - 1 where id = 3; 977select * from t; 978id x 9791 0 9802 100 9813 0 982update t set x = x + 100 where id = 3; 983select * from t; 984id x 9851 0 9862 100 9873 100 988update t set x = x - 100 where id = 3; 989select * from t; 990id x 9911 0 9922 100 9933 0 994update t set x = 1 + x where id = 1; 995ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 996update t set x = -x where id = 1; 997ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 998update t set x = x + 1 where id = 100; 999select * from t; 1000id x 10011 0 10022 100 10033 0 1004update t set x = x + 1 where 1 <= id and id < 100; 1005ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1006update t set x = x + 1; 1007ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1008drop table t; 1009### Test int for: bigint, unsigned, null 1010create table t ( 1011id bigint unsigned primary key, 1012x bigint unsigned null 1013) engine = tokudb; 1014insert into t values (1,0), (2,0), (3,0); 1015select * from t; 1016id x 10171 0 10182 0 10193 0 1020update t set x = 100 where id = 2; 1021select * from t; 1022id x 10231 0 10242 100 10253 0 1026update t set x = x + 1 where id = 3; 1027select * from t; 1028id x 10291 0 10302 100 10313 1 1032update t set x = x - 1 where id = 3; 1033select * from t; 1034id x 10351 0 10362 100 10373 0 1038update t set x = x + 100 where id = 3; 1039select * from t; 1040id x 10411 0 10422 100 10433 100 1044update t set x = x - 100 where id = 3; 1045select * from t; 1046id x 10471 0 10482 100 10493 0 1050update t set x = 1 + x where id = 1; 1051ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1052update t set x = -x where id = 1; 1053ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1054update t set x = x + 1 where id = 100; 1055select * from t; 1056id x 10571 0 10582 100 10593 0 1060update t set x = x + 1 where 1 <= id and id < 100; 1061ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1062update t set x = x + 1; 1063ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1064drop table t; 1065### Test int for: bigint, unsigned, not null 1066create table t ( 1067id bigint unsigned primary key, 1068x bigint unsigned not null 1069) engine = tokudb; 1070insert into t values (1,0), (2,0), (3,0); 1071select * from t; 1072id x 10731 0 10742 0 10753 0 1076update t set x = 100 where id = 2; 1077select * from t; 1078id x 10791 0 10802 100 10813 0 1082update t set x = x + 1 where id = 3; 1083select * from t; 1084id x 10851 0 10862 100 10873 1 1088update t set x = x - 1 where id = 3; 1089select * from t; 1090id x 10911 0 10922 100 10933 0 1094update t set x = x + 100 where id = 3; 1095select * from t; 1096id x 10971 0 10982 100 10993 100 1100update t set x = x - 100 where id = 3; 1101select * from t; 1102id x 11031 0 11042 100 11053 0 1106update t set x = 1 + x where id = 1; 1107ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1108update t set x = -x where id = 1; 1109ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1110update t set x = x + 1 where id = 100; 1111select * from t; 1112id x 11131 0 11142 100 11153 0 1116update t set x = x + 1 where 1 <= id and id < 100; 1117ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1118update t set x = x + 1; 1119ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version 1120drop table t; 1121