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