28
pk1 int unsigned not NULL,
35
35
insert into t1 values (0, 1, 1),
40
40
select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
69
pk2 char(4) not NULL collate latin1_german1_ci,
70
pk3 char(4) not NULL collate latin1_bin,
70
pk3 char(4) not NULL collate utf8_bin,
73
73
PRIMARY KEY (pk1,pk2,pk3),
77
77
insert into t1 values
78
78
(1, 'u', 'u', 1, 1),
79
(1, 'u', char(0xEC), 1, 1),
80
80
(1, 'u', 'x', 1, 1);
81
81
insert ignore into t1 select pk1, char(0xEC), pk3, key1, key2 from t1;
83
Warning 1366 Incorrect string value: '\xEC' for column 'pk2' at row 1
84
Warning 1366 Incorrect string value: '\xEC' for column 'pk2' at row 2
85
Warning 1366 Incorrect string value: '\xEC' for column 'pk2' at row 3
82
86
insert ignore into t1 select pk1, 'x', pk3, key1, key2 from t1 where pk2='u';
83
87
insert ignore into t1 select 2, pk2, pk3, key1, key2 from t1;
85
89
pk1 pk2 pk3 key1 key2
104
108
select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
105
109
pk1 pk2 pk3 key1 key2
124
128
alter table t1 drop primary key;
125
129
select * from t1;
126
130
pk1 pk2 pk3 key1 key2
145
149
select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
146
150
pk1 pk2 pk3 key1 key2
166
170
create table t1 (
167
171
pk1 varchar(8) NOT NULL default '',
168
172
pk2 varchar(4) NOT NULL default '',
171
175
primary key(pk1, pk2),