INSERT INTO t1 VALUES('uuABCDEFGHIGKLMNOPRSTUVWXYZbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb');
778
778
INSERT INTO t1 VALUES('uu');
779
779
check table t1;
851
851
after_delete_bin
852
852
킁aaaa
853
853
drop table t1;
854
CREATE TABLE t1 (id int PRIMARY KEY,
854
CREATE TEMPORARY TABLE t1 (id int PRIMARY KEY,
855
855
a varchar(16) collate utf8_unicode_ci NOT NULL default '',
856
856
b int,
857
857
f varchar(128) default 'XXX',
890
890
6 bbbbbb
891
891
11 bbbbbb
892
892
DROP TABLE t1;
893
CREATE TABLE t1 (
893
CREATE TEMPORARY TABLE t1 (
894
894
a CHAR(13) DEFAULT '',
895
895
INDEX(a)
896
896
) ENGINE=MyISAM COLLATE=utf8_general_ci;
898
898
('KÃli KÃli 2-4'), ('KÃli KÃli 2-4'),
899
899
('KÃli KÃli 2+4'), ('KÃli KÃli 2+4'),
900
900
('KÃli KÃli 2-6'), ('KÃli KÃli 2-6');
901
INSERT INTO t1 SELECT * FROM t1;
901
CREATE TABLE t2 SELECT * FROM t1;
902
INSERT INTO t1 SELECT * FROM t2;
903
DROP TABLE t2;
902
904
SELECT a FROM t1 WHERE a LIKE 'KÃli KÃli 2+4';
903
905
a
904
906
KÃli KÃli 2+4
912
914
id select_type table type possible_keys key key_len ref rows Extra
913
915
1 SIMPLE t1 ref a a 55 const 4 Using where; Using index