|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1 |
drop table if exists t1,t2;
|
2 |
SET SQL_WARNINGS=1;
|
|
3 |
CREATE TEMPORARY TABLE t1 (
|
|
4 |
STRING_DATA char(255) default NULL,
|
|
5 |
KEY string_data (STRING_DATA)
|
|
6 |
) ENGINE=MyISAM;
|
|
7 |
INSERT INTO t1 VALUES ('AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA');
|
|
8 |
INSERT INTO t1 VALUES ('DDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD');
|
|
9 |
INSERT INTO t1 VALUES ('FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF');
|
|
10 |
INSERT INTO t1 VALUES ('FGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG');
|
|
11 |
INSERT INTO t1 VALUES ('HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH');
|
|
12 |
INSERT INTO t1 VALUES ('WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW');
|
|
13 |
CHECK TABLE t1;
|
|
14 |
Table Op Msg_type Msg_text
|
|
15 |
test.t1 check status OK
|
|
16 |
drop table t1;
|
|
17 |
create table t1 (a int not null auto_increment, b blob not null, primary key (a));
|
|
18 |
check table t1;
|
|
19 |
Table Op Msg_type Msg_text
|
|
20 |
test.t1 check status OK
|
|
21 |
delete from t1 where (a mod 2) = 1;
|
|
22 |
check table t1;
|
|
23 |
Table Op Msg_type Msg_text
|
|
24 |
test.t1 check status OK
|
|
25 |
drop table t1;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
26 |
create TEMPORARY table t1 (a int not null auto_increment, b int not null, primary key (a), index(b)) ENGINE=MYISAM;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
27 |
insert into t1 (b) values (1),(2),(2),(2),(2);
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
28 |
alter table t1 engine=MYISAM;
|
29 |
show index from t1;
|
|
30 |
Table Unique Key_name Seq_in_index Column_name
|
|
31 |
t1 TRUE PRIMARY 1 a
|
|
32 |
t1 FALSE b 1 b
|
|
33 |
alter table t1 engine=MyISAM;
|
|
34 |
show index from t1;
|
|
35 |
Table Unique Key_name Seq_in_index Column_name
|
|
36 |
t1 TRUE PRIMARY 1 a
|
|
37 |
t1 FALSE b 1 b
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
38 |
drop table t1;
|
39 |
create temporary table t1 (a int not null, b int not null, c int not null, primary key (a),key(b)) engine=myisam;
|
|
40 |
insert into t1 values (3,3,3),(1,1,1),(2,2,2),(4,4,4);
|
|
41 |
explain select * from t1 order by a;
|
|
42 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
43 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort
|
|
44 |
explain select * from t1 order by b;
|
|
45 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
46 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort
|
|
47 |
explain select * from t1 order by c;
|
|
48 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
49 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort
|
|
50 |
explain select a from t1 order by a;
|
|
51 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
52 |
1 SIMPLE t1 index NULL PRIMARY 4 NULL 4 Using index
|
|
53 |
explain select b from t1 order by b;
|
|
54 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
55 |
1 SIMPLE t1 index NULL b 4 NULL 4 Using index
|
|
56 |
explain select a,b from t1 order by b;
|
|
57 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
58 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 4 Using filesort
|
|
59 |
explain select a,b from t1;
|
|
60 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
61 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 4
|
|
62 |
explain select a,b,c from t1;
|
|
63 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
64 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 4
|
|
65 |
drop table t1;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
66 |
create temporary table t1 ( t1 char(255), key(t1(250))) ENGINE=MYISAM;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
67 |
insert t1 values ('137513751375137513751375137513751375137569516951695169516951695169516951695169');
|
68 |
insert t1 values ('178417841784178417841784178417841784178403420342034203420342034203420342034203');
|
|
69 |
insert t1 values ('213872387238723872387238723872387238723867376737673767376737673767376737673767');
|
|
70 |
insert t1 values ('242624262426242624262426242624262426242607890789078907890789078907890789078907');
|
|
71 |
insert t1 values ('256025602560256025602560256025602560256011701170117011701170117011701170117011');
|
|
72 |
insert t1 values ('276027602760276027602760276027602760276001610161016101610161016101610161016101');
|
|
73 |
insert t1 values ('281528152815281528152815281528152815281564956495649564956495649564956495649564');
|
|
74 |
insert t1 values ('292129212921292129212921292129212921292102100210021002100210021002100210021002');
|
|
75 |
insert t1 values ('380638063806380638063806380638063806380634483448344834483448344834483448344834');
|
|
76 |
insert t1 values ('411641164116411641164116411641164116411616301630163016301630163016301630163016');
|
|
77 |
insert t1 values ('420842084208420842084208420842084208420899889988998899889988998899889988998899');
|
|
78 |
insert t1 values ('438443844384438443844384438443844384438482448244824482448244824482448244824482');
|
|
79 |
insert t1 values ('443244324432443244324432443244324432443239613961396139613961396139613961396139');
|
|
80 |
insert t1 values ('485448544854485448544854485448544854485477847784778477847784778477847784778477');
|
|
81 |
insert t1 values ('494549454945494549454945494549454945494555275527552755275527552755275527552755');
|
|
82 |
insert t1 values ('538647864786478647864786478647864786478688918891889188918891889188918891889188');
|
|
83 |
insert t1 values ('565556555655565556555655565556555655565554845484548454845484548454845484548454');
|
|
84 |
insert t1 values ('607860786078607860786078607860786078607856665666566656665666566656665666566656');
|
|
85 |
insert t1 values ('640164016401640164016401640164016401640141274127412741274127412741274127412741');
|
|
86 |
insert t1 values ('719471947194719471947194719471947194719478717871787178717871787178717871787178');
|
|
87 |
insert t1 values ('742574257425742574257425742574257425742549604960496049604960496049604960496049');
|
|
88 |
insert t1 values ('887088708870887088708870887088708870887035963596359635963596359635963596359635');
|
|
89 |
insert t1 values ('917791779177917791779177917791779177917773857385738573857385738573857385738573');
|
|
90 |
insert t1 values ('933293329332933293329332933293329332933278987898789878987898789878987898789878');
|
|
91 |
insert t1 values ('963896389638963896389638963896389638963877807780778077807780778077807780778077');
|
|
92 |
delete from t1 where t1>'2';
|
|
93 |
insert t1 values ('70'), ('84'), ('60'), ('20'), ('76'), ('89'), ('49'), ('50'),
|
|
94 |
('88'), ('61'), ('42'), ('98'), ('39'), ('30'), ('25'), ('66'), ('61'), ('48'),
|
|
95 |
('80'), ('84'), ('98'), ('19'), ('91'), ('42'), ('47');
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
96 |
alter table t1 ENGINE=myisam;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
97 |
check table t1;
|
98 |
Table Op Msg_type Msg_text
|
|
99 |
test.t1 check status OK
|
|
100 |
drop table t1;
|
|
101 |
create temporary table t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8
|
|
102 |
int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, i17
|
|
103 |
int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int,
|
|
104 |
i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34
|
|
105 |
int, i35 int, i36 int, i37 int, i38 int, i39 int, i40 int, i41 int, i42 int,
|
|
106 |
i43 int, i44 int, i45 int, i46 int, i47 int, i48 int, i49 int, i50 int, i51
|
|
107 |
int, i52 int, i53 int, i54 int, i55 int, i56 int, i57 int, i58 int, i59 int,
|
|
108 |
i60 int, i61 int, i62 int, i63 int, i64 int, i65 int, i66 int, i67 int, i68
|
|
109 |
int, i69 int, i70 int, i71 int, i72 int, i73 int, i74 int, i75 int, i76 int,
|
|
110 |
i77 int, i78 int, i79 int, i80 int, i81 int, i82 int, i83 int, i84 int, i85
|
|
111 |
int, i86 int, i87 int, i88 int, i89 int, i90 int, i91 int, i92 int, i93 int,
|
|
112 |
i94 int, i95 int, i96 int, i97 int, i98 int, i99 int, i100 int, i101 int, i102
|
|
113 |
int, i103 int, i104 int, i105 int, i106 int, i107 int, i108 int, i109 int, i110
|
|
114 |
int, i111 int, i112 int, i113 int, i114 int, i115 int, i116 int, i117 int, i118
|
|
115 |
int, i119 int, i120 int, i121 int, i122 int, i123 int, i124 int, i125 int, i126
|
|
116 |
int, i127 int, i128 int, i129 int, i130 int, i131 int, i132 int, i133 int, i134
|
|
117 |
int, i135 int, i136 int, i137 int, i138 int, i139 int, i140 int, i141 int, i142
|
|
118 |
int, i143 int, i144 int, i145 int, i146 int, i147 int, i148 int, i149 int, i150
|
|
119 |
int, i151 int, i152 int, i153 int, i154 int, i155 int, i156 int, i157 int, i158
|
|
120 |
int, i159 int, i160 int, i161 int, i162 int, i163 int, i164 int, i165 int, i166
|
|
121 |
int, i167 int, i168 int, i169 int, i170 int, i171 int, i172 int, i173 int, i174
|
|
122 |
int, i175 int, i176 int, i177 int, i178 int, i179 int, i180 int, i181 int, i182
|
|
123 |
int, i183 int, i184 int, i185 int, i186 int, i187 int, i188 int, i189 int, i190
|
|
124 |
int, i191 int, i192 int, i193 int, i194 int, i195 int, i196 int, i197 int, i198
|
|
125 |
int, i199 int, i200 int, i201 int, i202 int, i203 int, i204 int, i205 int, i206
|
|
126 |
int, i207 int, i208 int, i209 int, i210 int, i211 int, i212 int, i213 int, i214
|
|
127 |
int, i215 int, i216 int, i217 int, i218 int, i219 int, i220 int, i221 int, i222
|
|
128 |
int, i223 int, i224 int, i225 int, i226 int, i227 int, i228 int, i229 int, i230
|
|
129 |
int, i231 int, i232 int, i233 int, i234 int, i235 int, i236 int, i237 int, i238
|
|
130 |
int, i239 int, i240 int, i241 int, i242 int, i243 int, i244 int, i245 int, i246
|
|
131 |
int, i247 int, i248 int, i249 int, i250 int, i251 int, i252 int, i253 int, i254
|
|
132 |
int, i255 int, i256 int, i257 int, i258 int, i259 int, i260 int, i261 int, i262
|
|
133 |
int, i263 int, i264 int, i265 int, i266 int, i267 int, i268 int, i269 int, i270
|
|
134 |
int, i271 int, i272 int, i273 int, i274 int, i275 int, i276 int, i277 int, i278
|
|
135 |
int, i279 int, i280 int, i281 int, i282 int, i283 int, i284 int, i285 int, i286
|
|
136 |
int, i287 int, i288 int, i289 int, i290 int, i291 int, i292 int, i293 int, i294
|
|
137 |
int, i295 int, i296 int, i297 int, i298 int, i299 int, i300 int, i301 int, i302
|
|
138 |
int, i303 int, i304 int, i305 int, i306 int, i307 int, i308 int, i309 int, i310
|
|
139 |
int, i311 int, i312 int, i313 int, i314 int, i315 int, i316 int, i317 int, i318
|
|
140 |
int, i319 int, i320 int, i321 int, i322 int, i323 int, i324 int, i325 int, i326
|
|
141 |
int, i327 int, i328 int, i329 int, i330 int, i331 int, i332 int, i333 int, i334
|
|
142 |
int, i335 int, i336 int, i337 int, i338 int, i339 int, i340 int, i341 int, i342
|
|
143 |
int, i343 int, i344 int, i345 int, i346 int, i347 int, i348 int, i349 int, i350
|
|
144 |
int, i351 int, i352 int, i353 int, i354 int, i355 int, i356 int, i357 int, i358
|
|
145 |
int, i359 int, i360 int, i361 int, i362 int, i363 int, i364 int, i365 int, i366
|
|
146 |
int, i367 int, i368 int, i369 int, i370 int, i371 int, i372 int, i373 int, i374
|
|
147 |
int, i375 int, i376 int, i377 int, i378 int, i379 int, i380 int, i381 int, i382
|
|
148 |
int, i383 int, i384 int, i385 int, i386 int, i387 int, i388 int, i389 int, i390
|
|
149 |
int, i391 int, i392 int, i393 int, i394 int, i395 int, i396 int, i397 int, i398
|
|
150 |
int, i399 int, i400 int, i401 int, i402 int, i403 int, i404 int, i405 int, i406
|
|
151 |
int, i407 int, i408 int, i409 int, i410 int, i411 int, i412 int, i413 int, i414
|
|
152 |
int, i415 int, i416 int, i417 int, i418 int, i419 int, i420 int, i421 int, i422
|
|
153 |
int, i423 int, i424 int, i425 int, i426 int, i427 int, i428 int, i429 int, i430
|
|
154 |
int, i431 int, i432 int, i433 int, i434 int, i435 int, i436 int, i437 int, i438
|
|
155 |
int, i439 int, i440 int, i441 int, i442 int, i443 int, i444 int, i445 int, i446
|
|
156 |
int, i447 int, i448 int, i449 int, i450 int, i451 int, i452 int, i453 int, i454
|
|
157 |
int, i455 int, i456 int, i457 int, i458 int, i459 int, i460 int, i461 int, i462
|
|
158 |
int, i463 int, i464 int, i465 int, i466 int, i467 int, i468 int, i469 int, i470
|
|
159 |
int, i471 int, i472 int, i473 int, i474 int, i475 int, i476 int, i477 int, i478
|
|
160 |
int, i479 int, i480 int, i481 int, i482 int, i483 int, i484 int, i485 int, i486
|
|
161 |
int, i487 int, i488 int, i489 int, i490 int, i491 int, i492 int, i493 int, i494
|
|
162 |
int, i495 int, i496 int, i497 int, i498 int, i499 int, i500 int, i501 int, i502
|
|
163 |
int, i503 int, i504 int, i505 int, i506 int, i507 int, i508 int, i509 int, i510
|
|
164 |
int, i511 int, i512 int, i513 int, i514 int, i515 int, i516 int, i517 int, i518
|
|
165 |
int, i519 int, i520 int, i521 int, i522 int, i523 int, i524 int, i525 int, i526
|
|
166 |
int, i527 int, i528 int, i529 int, i530 int, i531 int, i532 int, i533 int, i534
|
|
167 |
int, i535 int, i536 int, i537 int, i538 int, i539 int, i540 int, i541 int, i542
|
|
168 |
int, i543 int, i544 int, i545 int, i546 int, i547 int, i548 int, i549 int, i550
|
|
169 |
int, i551 int, i552 int, i553 int, i554 int, i555 int, i556 int, i557 int, i558
|
|
170 |
int, i559 int, i560 int, i561 int, i562 int, i563 int, i564 int, i565 int, i566
|
|
171 |
int, i567 int, i568 int, i569 int, i570 int, i571 int, i572 int, i573 int, i574
|
|
172 |
int, i575 int, i576 int, i577 int, i578 int, i579 int, i580 int, i581 int, i582
|
|
173 |
int, i583 int, i584 int, i585 int, i586 int, i587 int, i588 int, i589 int, i590
|
|
174 |
int, i591 int, i592 int, i593 int, i594 int, i595 int, i596 int, i597 int, i598
|
|
175 |
int, i599 int, i600 int, i601 int, i602 int, i603 int, i604 int, i605 int, i606
|
|
176 |
int, i607 int, i608 int, i609 int, i610 int, i611 int, i612 int, i613 int, i614
|
|
177 |
int, i615 int, i616 int, i617 int, i618 int, i619 int, i620 int, i621 int, i622
|
|
178 |
int, i623 int, i624 int, i625 int, i626 int, i627 int, i628 int, i629 int, i630
|
|
179 |
int, i631 int, i632 int, i633 int, i634 int, i635 int, i636 int, i637 int, i638
|
|
180 |
int, i639 int, i640 int, i641 int, i642 int, i643 int, i644 int, i645 int, i646
|
|
181 |
int, i647 int, i648 int, i649 int, i650 int, i651 int, i652 int, i653 int, i654
|
|
182 |
int, i655 int, i656 int, i657 int, i658 int, i659 int, i660 int, i661 int, i662
|
|
183 |
int, i663 int, i664 int, i665 int, i666 int, i667 int, i668 int, i669 int, i670
|
|
184 |
int, i671 int, i672 int, i673 int, i674 int, i675 int, i676 int, i677 int, i678
|
|
185 |
int, i679 int, i680 int, i681 int, i682 int, i683 int, i684 int, i685 int, i686
|
|
186 |
int, i687 int, i688 int, i689 int, i690 int, i691 int, i692 int, i693 int, i694
|
|
187 |
int, i695 int, i696 int, i697 int, i698 int, i699 int, i700 int, i701 int, i702
|
|
188 |
int, i703 int, i704 int, i705 int, i706 int, i707 int, i708 int, i709 int, i710
|
|
189 |
int, i711 int, i712 int, i713 int, i714 int, i715 int, i716 int, i717 int, i718
|
|
190 |
int, i719 int, i720 int, i721 int, i722 int, i723 int, i724 int, i725 int, i726
|
|
191 |
int, i727 int, i728 int, i729 int, i730 int, i731 int, i732 int, i733 int, i734
|
|
192 |
int, i735 int, i736 int, i737 int, i738 int, i739 int, i740 int, i741 int, i742
|
|
193 |
int, i743 int, i744 int, i745 int, i746 int, i747 int, i748 int, i749 int, i750
|
|
194 |
int, i751 int, i752 int, i753 int, i754 int, i755 int, i756 int, i757 int, i758
|
|
195 |
int, i759 int, i760 int, i761 int, i762 int, i763 int, i764 int, i765 int, i766
|
|
196 |
int, i767 int, i768 int, i769 int, i770 int, i771 int, i772 int, i773 int, i774
|
|
197 |
int, i775 int, i776 int, i777 int, i778 int, i779 int, i780 int, i781 int, i782
|
|
198 |
int, i783 int, i784 int, i785 int, i786 int, i787 int, i788 int, i789 int, i790
|
|
199 |
int, i791 int, i792 int, i793 int, i794 int, i795 int, i796 int, i797 int, i798
|
|
200 |
int, i799 int, i800 int, i801 int, i802 int, i803 int, i804 int, i805 int, i806
|
|
201 |
int, i807 int, i808 int, i809 int, i810 int, i811 int, i812 int, i813 int, i814
|
|
202 |
int, i815 int, i816 int, i817 int, i818 int, i819 int, i820 int, i821 int, i822
|
|
203 |
int, i823 int, i824 int, i825 int, i826 int, i827 int, i828 int, i829 int, i830
|
|
204 |
int, i831 int, i832 int, i833 int, i834 int, i835 int, i836 int, i837 int, i838
|
|
205 |
int, i839 int, i840 int, i841 int, i842 int, i843 int, i844 int, i845 int, i846
|
|
206 |
int, i847 int, i848 int, i849 int, i850 int, i851 int, i852 int, i853 int, i854
|
|
207 |
int, i855 int, i856 int, i857 int, i858 int, i859 int, i860 int, i861 int, i862
|
|
208 |
int, i863 int, i864 int, i865 int, i866 int, i867 int, i868 int, i869 int, i870
|
|
209 |
int, i871 int, i872 int, i873 int, i874 int, i875 int, i876 int, i877 int, i878
|
|
210 |
int, i879 int, i880 int, i881 int, i882 int, i883 int, i884 int, i885 int, i886
|
|
211 |
int, i887 int, i888 int, i889 int, i890 int, i891 int, i892 int, i893 int, i894
|
|
212 |
int, i895 int, i896 int, i897 int, i898 int, i899 int, i900 int, i901 int, i902
|
|
213 |
int, i903 int, i904 int, i905 int, i906 int, i907 int, i908 int, i909 int, i910
|
|
214 |
int, i911 int, i912 int, i913 int, i914 int, i915 int, i916 int, i917 int, i918
|
|
215 |
int, i919 int, i920 int, i921 int, i922 int, i923 int, i924 int, i925 int, i926
|
|
216 |
int, i927 int, i928 int, i929 int, i930 int, i931 int, i932 int, i933 int, i934
|
|
217 |
int, i935 int, i936 int, i937 int, i938 int, i939 int, i940 int, i941 int, i942
|
|
218 |
int, i943 int, i944 int, i945 int, i946 int, i947 int, i948 int, i949 int, i950
|
|
219 |
int, i951 int, i952 int, i953 int, i954 int, i955 int, i956 int, i957 int, i958
|
|
220 |
int, i959 int, i960 int, i961 int, i962 int, i963 int, i964 int, i965 int, i966
|
|
221 |
int, i967 int, i968 int, i969 int, i970 int, i971 int, i972 int, i973 int, i974
|
|
222 |
int, i975 int, i976 int, i977 int, i978 int, i979 int, i980 int, i981 int, i982
|
|
223 |
int, i983 int, i984 int, i985 int, i986 int, i987 int, i988 int, i989 int, i990
|
|
224 |
int, i991 int, i992 int, i993 int, i994 int, i995 int, i996 int, i997 int, i998
|
|
225 |
int, i999 int, i1000 int, b blob) engine=myisam row_format=dynamic;
|
|
226 |
insert into t1 values (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
227 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
228 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
229 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
230 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
231 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
232 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
233 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
234 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
235 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
236 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
237 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
238 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
239 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
240 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
241 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
242 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
243 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
244 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
245 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
246 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
247 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
248 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
249 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
250 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
251 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
252 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
253 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
254 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
255 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
256 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
257 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
258 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
259 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
260 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
261 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
262 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
263 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
|
|
264 |
1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, "Sergei");
|
|
265 |
update t1 set b=repeat('a',256);
|
|
266 |
update t1 set i1=0, i2=0, i3=0, i4=0, i5=0, i6=0, i7=0;
|
|
267 |
check table t1;
|
|
268 |
Table Op Msg_type Msg_text
|
|
269 |
test.t1 check status OK
|
|
270 |
delete from t1 where i8=1;
|
|
271 |
select i1,i2 from t1;
|
|
272 |
i1 i2
|
|
273 |
check table t1;
|
|
274 |
Table Op Msg_type Msg_text
|
|
275 |
test.t1 check status OK
|
|
276 |
drop table t1;
|
|
277 |
CREATE TEMPORARY TABLE `t1` (
|
|
278 |
`post_id` int NOT NULL auto_increment,
|
|
279 |
`topic_id` int NOT NULL default '0',
|
|
280 |
`post_time` datetime,
|
|
281 |
`post_text` text NOT NULL,
|
|
282 |
`icon_url` varchar(10) NOT NULL default '',
|
|
283 |
`sign` int NOT NULL default '0',
|
|
284 |
`post_edit` varchar(150) NOT NULL default '',
|
|
285 |
`poster_login` varchar(35) NOT NULL default '',
|
|
286 |
`ip` varchar(15) NOT NULL default '',
|
|
287 |
PRIMARY KEY (`post_id`),
|
|
288 |
KEY `post_time` (`post_time`),
|
|
289 |
KEY `ip` (`ip`),
|
|
290 |
KEY `poster_login` (`poster_login`),
|
|
291 |
KEY `topic_id` (`topic_id`)
|
|
292 |
# FULLTEXT KEY `post_text` (`post_text`)
|
|
293 |
) ENGINE=MyISAM;
|
|
294 |
INSERT INTO t1 (post_text) VALUES ('ceci est un test'),('ceci est un test'),('ceci est un test'),('ceci est un test'),('ceci est un test');
|
|
295 |
CHECK TABLE t1;
|
|
296 |
Table Op Msg_type Msg_text
|
|
297 |
test.t1 check status OK
|
|
298 |
drop table t1;
|
|
299 |
CREATE TEMPORARY TABLE t1 (a varchar(300), b varchar(300), c varchar(300), d varchar(300), e varchar(300), KEY t1 (a, b, c, d, e)) ENGINE=MyISAM;
|
|
300 |
ERROR 42000: Specified key was too long; max key length is 1332 bytes
|
|
301 |
CREATE TEMPORARY TABLE t1 (a varchar(300), b varchar(300), c varchar(300), d varchar(300), e varchar(300)) ENGINE=MyISAM;
|
|
302 |
ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);
|
|
303 |
ERROR 42000: Specified key was too long; max key length is 1332 bytes
|
|
304 |
DROP TABLE t1;
|
|
305 |
CREATE TEMPORARY TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a)) ENGINE=MyISAM;
|
|
306 |
INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4);
|
|
307 |
create table t2 (a int not null, b int, c int, key(b), key(c), key(a));
|
|
308 |
INSERT into t2 values (1,1,1), (2,2,2);
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
309 |
alter table t1 ENGINE=MYISAM;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
310 |
show index from t1;
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
311 |
Table Unique Key_name Seq_in_index Column_name
|
312 |
t1 FALSE b 1 b
|
|
313 |
t1 FALSE c 1 c
|
|
314 |
t1 FALSE a 1 a
|
|
315 |
t1 FALSE a 2 b
|
|
316 |
t1 FALSE c_2 1 c
|
|
317 |
t1 FALSE c_2 2 a
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
318 |
explain select * from t1,t2 where t1.a=t2.a;
|
319 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
320 |
1 SIMPLE t2 ALL a NULL NULL NULL 2
|
|
321 |
1 SIMPLE t1 ref a a 4 test.t2.a 1
|
|
322 |
explain select * from t1,t2 force index(a) where t1.a=t2.a;
|
|
323 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
324 |
1 SIMPLE t2 ALL a NULL NULL NULL 2
|
|
325 |
1 SIMPLE t1 ref a a 4 test.t2.a 1
|
|
326 |
explain select * from t1 force index(a),t2 force index(a) where t1.a=t2.a;
|
|
327 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
328 |
1 SIMPLE t2 ALL a NULL NULL NULL 2
|
|
329 |
1 SIMPLE t1 ref a a 4 test.t2.a 1
|
|
330 |
explain select * from t1,t2 where t1.b=t2.b;
|
|
331 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
332 |
1 SIMPLE t2 ALL b NULL NULL NULL 2
|
|
333 |
1 SIMPLE t1 ALL b NULL NULL NULL 5 Using where; Using join buffer
|
|
334 |
explain select * from t1,t2 force index(c) where t1.a=t2.a;
|
|
335 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
336 |
1 SIMPLE t2 ALL NULL NULL NULL NULL 2
|
|
337 |
1 SIMPLE t1 ref a a 4 test.t2.a 1
|
|
338 |
explain select * from t1 where a=0 or a=2;
|
|
339 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
340 |
1 SIMPLE t1 ALL a NULL NULL NULL 5 Using where
|
|
341 |
explain select * from t1 force index (a) where a=0 or a=2;
|
|
342 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
343 |
1 SIMPLE t1 range a a 4 NULL 4 Using where
|
|
344 |
explain select * from t1 where c=1;
|
|
345 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
346 |
1 SIMPLE t1 ref c,c_2 c 5 const 1
|
|
347 |
explain select * from t1 use index() where c=1;
|
|
348 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
349 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 5 Using where
|
|
350 |
drop table t1,t2;
|
|
351 |
create table t1 (a int not null auto_increment primary key, b varchar(255));
|
|
352 |
insert into t1 (b) values (repeat('a',100)),(repeat('b',100)),(repeat('c',100));
|
|
353 |
update t1 set b=repeat(left(b,1),200) where a=1;
|
|
354 |
delete from t1 where (a mod 2) = 0;
|
|
355 |
update t1 set b=repeat('e',200) where a=1;
|
|
356 |
flush tables;
|
|
357 |
check table t1;
|
|
358 |
Table Op Msg_type Msg_text
|
|
359 |
test.t1 check status OK
|
|
360 |
update t1 set b=repeat(left(b,1),255) where a between 1 and 5;
|
|
361 |
update t1 set b=repeat(left(b,1),10) where a between 32 and 43;
|
|
362 |
update t1 set b=repeat(left(b,1),2) where a between 64 and 66;
|
|
363 |
update t1 set b=repeat(left(b,1),65) where a between 67 and 70;
|
|
364 |
check table t1;
|
|
365 |
Table Op Msg_type Msg_text
|
|
366 |
test.t1 check status OK
|
|
367 |
insert into t1 (b) values (repeat('z',100));
|
|
368 |
update t1 set b="test" where left(b,1) > 'n';
|
|
369 |
check table t1;
|
|
370 |
Table Op Msg_type Msg_text
|
|
371 |
test.t1 check status OK
|
|
372 |
drop table t1;
|
|
373 |
create temporary table t1 ( a text not null, key a (a(20))) engine=myisam;
|
|
374 |
insert into t1 values ('aaa '),('aaa'),('aa');
|
|
375 |
check table t1;
|
|
376 |
Table Op Msg_type Msg_text
|
|
377 |
test.t1 check status OK
|
|
378 |
select concat(a,'.') from t1 where a='aaa';
|
|
379 |
concat(a,'.')
|
|
380 |
aaa .
|
|
381 |
aaa.
|
|
382 |
select concat(a,'.') from t1 where binary a='aaa';
|
|
383 |
concat(a,'.')
|
|
384 |
aaa.
|
|
385 |
update t1 set a='bbb' where a='aaa';
|
|
386 |
select concat(a,'.') from t1;
|
|
387 |
concat(a,'.')
|
|
388 |
bbb.
|
|
389 |
bbb.
|
|
390 |
aa.
|
|
391 |
drop table t1;
|
|
392 |
create temporary table t1(a text not null, b text not null, c text not null, index (a(10),b(10),c(10))) engine=myisam;
|
|
393 |
insert into t1 values('807780', '477', '165');
|
|
394 |
insert into t1 values('807780', '477', '162');
|
|
395 |
insert into t1 values('807780', '472', '162');
|
|
396 |
select * from t1 where a='807780' and b='477' and c='165';
|
|
397 |
a b c
|
|
398 |
807780 477 165
|
|
399 |
drop table t1;
|
|
400 |
DROP TABLE IF EXISTS t1;
|
|
401 |
Warnings:
|
|
402 |
Note 1051 Unknown table 't1'
|
|
403 |
CREATE TEMPORARY TABLE t1 (a varchar(150) NOT NULL, KEY (a)) ENGINE=MyISAM;
|
|
404 |
INSERT t1 VALUES ("can \tcan");
|
|
405 |
INSERT t1 VALUES ("can can");
|
|
406 |
INSERT t1 VALUES ("can");
|
|
407 |
SELECT * FROM t1;
|
|
408 |
a
|
|
409 |
can can
|
|
410 |
can
|
|
411 |
can can
|
|
412 |
CHECK TABLE t1;
|
|
413 |
Table Op Msg_type Msg_text
|
|
414 |
test.t1 check status OK
|
|
415 |
DROP TABLE t1;
|
|
416 |
create table t1 (a blob);
|
|
417 |
insert into t1 values('a '),('a');
|
|
418 |
select concat(a,'.') from t1 where a='a';
|
|
419 |
concat(a,'.')
|
|
420 |
a.
|
|
421 |
select concat(a,'.') from t1 where a='a ';
|
|
422 |
concat(a,'.')
|
|
423 |
a .
|
|
424 |
alter table t1 add key(a(2));
|
|
425 |
select concat(a,'.') from t1 where a='a';
|
|
426 |
concat(a,'.')
|
|
427 |
a.
|
|
428 |
select concat(a,'.') from t1 where a='a ';
|
|
429 |
concat(a,'.')
|
|
430 |
a .
|
|
431 |
drop table t1;
|
|
432 |
create table t1 (a int not null auto_increment primary key, b text not null, unique b (b(20)));
|
|
433 |
insert into t1 (b) values ('a'),('b'),('c');
|
|
434 |
select concat(b,'.') from t1;
|
|
435 |
concat(b,'.')
|
|
436 |
a.
|
|
437 |
b.
|
|
438 |
c.
|
|
439 |
update t1 set b='b ' where a=2;
|
|
440 |
update t1 set b='b ' where a > 1;
|
|
441 |
ERROR 23000: Duplicate entry 'b ' for key 'b'
|
|
442 |
insert into t1 (b) values ('b');
|
|
443 |
ERROR 23000: Duplicate entry 'b' for key 'b'
|
|
444 |
select * from t1;
|
|
445 |
a b
|
|
446 |
1 a
|
|
447 |
3 c
|
|
448 |
2 b
|
|
449 |
delete from t1 where b='b';
|
|
450 |
select a,concat(b,'.') from t1;
|
|
451 |
a concat(b,'.')
|
|
452 |
1 a.
|
|
453 |
3 c.
|
|
454 |
drop table t1;
|
|
455 |
create table t1 (a int not null);
|
|
456 |
create table t2 (a int not null, primary key (a));
|
|
457 |
insert into t1 values (1);
|
|
458 |
insert into t2 values (1),(2);
|
|
459 |
select sql_big_result distinct t1.a from t1,t2 order by t2.a;
|
|
460 |
a
|
|
461 |
1
|
|
462 |
select distinct t1.a from t1,t2 order by t2.a;
|
|
463 |
a
|
|
464 |
1
|
|
465 |
select sql_big_result distinct t1.a from t1,t2;
|
|
466 |
a
|
|
467 |
1
|
|
468 |
explain select sql_big_result distinct t1.a from t1,t2 order by t2.a;
|
|
469 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
470 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 1 Using temporary; Using filesort
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
471 |
1 SIMPLE t2 ALL NULL NULL NULL NULL 2 Distinct; Using join buffer
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
472 |
explain select distinct t1.a from t1,t2 order by t2.a;
|
473 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
474 |
1 SIMPLE t1 ALL NULL NULL NULL NULL 1 Using temporary; Using filesort
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
475 |
1 SIMPLE t2 ALL NULL NULL NULL NULL 2 Distinct; Using join buffer
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
476 |
drop table t1,t2;
|
477 |
create temporary table t1 (
|
|
478 |
c1 varchar(32),
|
|
479 |
key (c1)
|
|
480 |
) engine=myisam;
|
|
481 |
alter table t1 disable keys;
|
|
482 |
insert into t1 values ('a'), ('b');
|
|
483 |
select c1 from t1 order by c1 limit 1;
|
|
484 |
c1
|
|
485 |
a
|
|
486 |
drop table t1;
|
|
487 |
create table t1 (a int, b varchar(200), c text not null);
|
|
488 |
create table t2 (a int, b varchar(200), c text not null);
|
|
489 |
insert t1 values (1, "aaa", "bbb"), (NULL, "", "ccccc"), (0, NULL, "");
|
|
490 |
insert t2 select * from t1;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
491 |
show table status;
|
492 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
493 |
# test t1 STANDARD PBXT # # # # #
|
|
494 |
# test t2 STANDARD PBXT # # # # #
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
495 |
drop table t1,t2;
|
496 |
create table t1 ( a tinytext, b char(1), index idx (a(1),b) );
|
|
497 |
insert into t1 values (null,''), (null,'');
|
|
498 |
explain select count(*) from t1 where a is null;
|
|
499 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
500 |
1 SIMPLE t1 ref idx idx 7 const 1 Using where
|
|
501 |
select count(*) from t1 where a is null;
|
|
502 |
count(*)
|
|
503 |
2
|
|
504 |
drop table t1;
|
|
505 |
create table t1 (c1 int, c2 varchar(4) not null default '',
|
|
506 |
key(c2(3)));
|
|
507 |
insert into t1 values (1,'A'), (2, 'B'), (3, 'A');
|
|
508 |
update t1 set c2='A B' where c1=2;
|
|
509 |
check table t1;
|
|
510 |
Table Op Msg_type Msg_text
|
|
511 |
test.t1 check status OK
|
|
512 |
drop table t1;
|
|
513 |
create table t1(
|
|
514 |
cip INT NOT NULL,
|
|
515 |
score INT NOT NULL DEFAULT 0,
|
|
516 |
bob TINYBLOB
|
|
517 |
);
|
|
518 |
insert into t1 (cip) VALUES (1), (2), (3);
|
|
519 |
insert into t1 (cip, bob) VALUES (4, 'a' ), (5, 'b'),
|
|
520 |
(6, 'c');
|
|
521 |
select * from t1 where bob is null and cip=1;
|
|
522 |
cip score bob
|
|
523 |
1 0 NULL
|
|
524 |
create index bug on t1 (bob(22), cip);
|
|
525 |
select * from t1 where bob is null and cip=1;
|
|
526 |
cip score bob
|
|
527 |
1 0 NULL
|
|
528 |
drop table t1;
|
|
529 |
create temporary table t1 (
|
|
530 |
id1 int not null auto_increment,
|
|
531 |
id2 int not null default '0',
|
|
532 |
t text not null,
|
|
533 |
primary key (id1),
|
|
534 |
key x (id2, t(32))
|
|
535 |
) engine=myisam;
|
|
536 |
insert into t1 (id2, t) values
|
|
537 |
(10, 'abc'), (10, 'abc'), (10, 'abc'),
|
|
538 |
(20, 'abc'), (20, 'abc'), (20, 'def'),
|
|
539 |
(10, 'abc'), (10, 'abc');
|
|
540 |
select count(*) from t1 where id2 = 10;
|
|
541 |
count(*)
|
|
542 |
5
|
|
543 |
select count(id1) from t1 where id2 = 10;
|
|
544 |
count(id1)
|
|
545 |
5
|
|
546 |
drop table t1;
|
|
547 |
CREATE TEMPORARY TABLE t1(a int, KEY(a)) ENGINE=MyISAM;
|
|
548 |
INSERT INTO t1 VALUES(1);
|
|
549 |
SELECT MAX(a) FROM t1 IGNORE INDEX(a);
|
|
550 |
MAX(a)
|
|
551 |
1
|
|
552 |
ALTER TABLE t1 DISABLE KEYS;
|
|
553 |
SELECT MAX(a) FROM t1;
|
|
554 |
MAX(a)
|
|
555 |
1
|
|
556 |
SELECT MAX(a) FROM t1 IGNORE INDEX(a);
|
|
557 |
MAX(a)
|
|
558 |
1
|
|
559 |
DROP TABLE t1;
|
|
560 |
SET GLOBAL myisam_repair_threads=2;
|
|
561 |
SHOW VARIABLES LIKE 'myisam_repair%';
|
|
562 |
Variable_name Value
|
|
563 |
myisam_repair_threads 2
|
|
564 |
CREATE TEMPORARY TABLE t1 (
|
|
565 |
`_id` int NOT NULL default '0',
|
|
566 |
`url` text,
|
|
567 |
`email` text,
|
|
568 |
`description` text,
|
|
569 |
`loverlap` int default NULL,
|
|
570 |
`roverlap` int default NULL,
|
|
571 |
`lneighbor_id` int default NULL,
|
|
572 |
`rneighbor_id` int default NULL,
|
|
573 |
`length_` int default NULL,
|
|
574 |
`sequence` text,
|
|
575 |
`name` text,
|
|
576 |
`_obj_class` text NOT NULL,
|
|
577 |
PRIMARY KEY (`_id`),
|
|
578 |
UNIQUE KEY `sequence_name_index` (`name`(50)),
|
|
579 |
KEY (`length_`)
|
|
580 |
) ENGINE=MyISAM;
|
|
581 |
INSERT INTO t1 VALUES
|
|
582 |
(1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample1',''),
|
|
583 |
(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample2',''),
|
|
584 |
(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample3',''),
|
|
585 |
(4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample4',''),
|
|
586 |
(5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample5',''),
|
|
587 |
(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample6',''),
|
|
588 |
(7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample7',''),
|
|
589 |
(8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample8',''),
|
|
590 |
(9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'sample9','');
|
|
591 |
SELECT _id FROM t1;
|
|
592 |
_id
|
|
593 |
1
|
|
594 |
2
|
|
595 |
3
|
|
596 |
4
|
|
597 |
5
|
|
598 |
6
|
|
599 |
7
|
|
600 |
8
|
|
601 |
9
|
|
602 |
DELETE FROM t1 WHERE _id < 8;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
603 |
show table status LIKE 't1';
|
604 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
605 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
606 |
CHECK TABLE t1;
|
|
607 |
Table Op Msg_type Msg_text
|
|
608 |
test.t1 check status OK
|
|
609 |
ALTER TABLE t1 ENGINE=MYISAM;
|
|
610 |
CHECK TABLE t1;
|
|
611 |
Table Op Msg_type Msg_text
|
|
612 |
test.t1 check status OK
|
|
613 |
show table status LIKE 't1';
|
|
614 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
615 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
616 |
SELECT _id FROM t1;
|
617 |
_id
|
|
618 |
8
|
|
619 |
9
|
|
620 |
DROP TABLE t1;
|
|
621 |
SET GLOBAL myisam_repair_threads=1;
|
|
622 |
SHOW VARIABLES LIKE 'myisam_repair%';
|
|
623 |
Variable_name Value
|
|
624 |
myisam_repair_threads 1
|
|
625 |
CREATE TEMPORARY TABLE t1 (c1 TEXT) ENGINE=MyISAM;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
626 |
show table status like 't1';
|
627 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
628 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
629 |
DROP TABLE t1;
|
630 |
CREATE TEMPORARY TABLE t1 (c1 TEXT NOT NULL, KEY c1 (c1(10))) ENGINE=MyISAM;
|
|
631 |
INSERT INTO t1 VALUES
|
|
632 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
633 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
634 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
635 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
636 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
637 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
638 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
639 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
640 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
641 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
642 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
643 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
644 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
645 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
646 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
647 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
648 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
649 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
650 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
651 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
652 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
653 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
654 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
655 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
656 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
657 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
658 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
659 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
660 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
661 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
662 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
663 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
664 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
665 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
666 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
667 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
668 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
669 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
670 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
671 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
672 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
673 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
674 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
675 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
676 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
677 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
678 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
679 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
680 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
681 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
682 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
683 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
684 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
685 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
686 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
687 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
688 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
689 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
690 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
691 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
692 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
693 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
694 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
695 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
696 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
697 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
698 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
699 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
700 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
701 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
702 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
703 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
704 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
705 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
706 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
707 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
708 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
709 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
710 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
711 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
712 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
713 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
714 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
715 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
716 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
717 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
718 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
719 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
720 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
721 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
722 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
723 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
724 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
725 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
726 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
727 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
728 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
729 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
730 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
731 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
732 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
733 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
734 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
735 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
736 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
737 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
738 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
739 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
740 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
741 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
742 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
743 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
744 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
745 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
746 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
747 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
748 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
749 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
750 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
751 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
752 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
753 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
754 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
755 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
756 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
757 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
758 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
759 |
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
|
|
760 |
(''), (''), (''), (''),
|
|
761 |
(' B'), (' B'), (' B'), (' B');
|
|
762 |
SELECT DISTINCT COUNT(*) FROM t1 WHERE c1 = '';
|
|
763 |
COUNT(*)
|
|
764 |
4
|
|
765 |
SELECT DISTINCT length(c1), c1 FROM t1 WHERE c1 = '';
|
|
766 |
length(c1) c1
|
|
767 |
0
|
|
768 |
SELECT DISTINCT COUNT(*) FROM t1 IGNORE INDEX (c1) WHERE c1 = '';
|
|
769 |
COUNT(*)
|
|
770 |
4
|
|
771 |
SELECT DISTINCT length(c1), c1 FROM t1 IGNORE INDEX (c1) WHERE c1 = '';
|
|
772 |
length(c1) c1
|
|
773 |
0
|
|
774 |
SELECT DISTINCT length(c1), c1 FROM t1 ORDER BY c1;
|
|
775 |
length(c1) c1
|
|
776 |
0
|
|
777 |
2 A
|
|
778 |
2 B
|
|
779 |
DROP TABLE t1;
|
|
780 |
End of 4.1 tests
|
|
781 |
set storage_engine=MyISAM;
|
|
782 |
drop table if exists t1,t2,t3;
|
|
783 |
--- Testing varchar ---
|
|
784 |
--- Testing varchar ---
|
|
785 |
create TEMPORARY table t1 (v varchar(10), c char(10), t text);
|
|
786 |
insert into t1 values('+ ', '+ ', '+ ');
|
|
787 |
set @a=repeat(' ',20);
|
|
788 |
insert into t1 values (concat('+',@a),concat('+',@a),concat('+',@a));
|
|
789 |
Warnings:
|
|
790 |
Note 1265 Data truncated for column 'v' at row 1
|
|
791 |
Note 1265 Data truncated for column 'c' at row 1
|
|
792 |
select concat('*',v,'*',c,'*',t,'*') from t1;
|
|
793 |
concat('*',v,'*',c,'*',t,'*')
|
|
794 |
*+ *+ *+ *
|
|
795 |
*+ *+ *+ *
|
|
796 |
show create table t1;
|
|
797 |
Table Create Table
|
|
798 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
799 |
`v` varchar(10) DEFAULT NULL,
|
|
800 |
`c` varchar(10) DEFAULT NULL,
|
|
801 |
`t` text
|
|
802 |
) ENGINE=MyISAM
|
|
803 |
create TEMPORARY table t2 like t1;
|
|
804 |
show create table t2;
|
|
805 |
Table Create Table
|
|
806 |
t2 CREATE TEMPORARY TABLE `t2` (
|
|
807 |
`v` varchar(10) DEFAULT NULL,
|
|
808 |
`c` varchar(10) DEFAULT NULL,
|
|
809 |
`t` text
|
|
810 |
) ENGINE=MyISAM
|
|
811 |
create TEMPORARY table t3 select * from t1;
|
|
812 |
show create table t3;
|
|
813 |
Table Create Table
|
|
814 |
t3 CREATE TEMPORARY TABLE `t3` (
|
|
815 |
`v` varchar(10) DEFAULT NULL,
|
|
816 |
`c` varchar(10) DEFAULT NULL,
|
|
817 |
`t` text
|
|
818 |
) ENGINE=MyISAM
|
|
819 |
alter table t1 modify c varchar(10);
|
|
820 |
show create table t1;
|
|
821 |
Table Create Table
|
|
822 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
823 |
`v` varchar(10) DEFAULT NULL,
|
|
824 |
`c` varchar(10) DEFAULT NULL,
|
|
825 |
`t` text
|
|
826 |
) ENGINE=MyISAM
|
|
827 |
alter table t1 modify v char(10);
|
|
828 |
show create table t1;
|
|
829 |
Table Create Table
|
|
830 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
831 |
`v` varchar(10) DEFAULT NULL,
|
|
832 |
`c` varchar(10) DEFAULT NULL,
|
|
833 |
`t` text
|
|
834 |
) ENGINE=MyISAM
|
|
835 |
alter table t1 modify t varchar(10);
|
|
836 |
Warnings:
|
|
837 |
Note 1265 Data truncated for column 't' at row 2
|
|
838 |
show create table t1;
|
|
839 |
Table Create Table
|
|
840 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
841 |
`v` varchar(10) DEFAULT NULL,
|
|
842 |
`c` varchar(10) DEFAULT NULL,
|
|
843 |
`t` varchar(10) DEFAULT NULL
|
|
844 |
) ENGINE=MyISAM
|
|
845 |
select concat('*',v,'*',c,'*',t,'*') from t1;
|
|
846 |
concat('*',v,'*',c,'*',t,'*')
|
|
847 |
*+ *+ *+ *
|
|
848 |
*+ *+ *+ *
|
|
849 |
drop table t1,t2,t3;
|
|
850 |
create TEMPORARY table t1 (v varchar(10), c char(10), t text, key(v), key(c), key(t(10)));
|
|
851 |
show create table t1;
|
|
852 |
Table Create Table
|
|
853 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
854 |
`v` varchar(10) DEFAULT NULL,
|
|
855 |
`c` varchar(10) DEFAULT NULL,
|
|
856 |
`t` text,
|
|
857 |
KEY `v` (`v`),
|
|
858 |
KEY `c` (`c`),
|
|
859 |
KEY `t` (`t`(10))
|
|
860 |
) ENGINE=MyISAM
|
|
861 |
select count(*) from t1;
|
|
862 |
count(*)
|
|
863 |
270
|
|
864 |
insert into t1 values(concat('a',char(1)),concat('a',char(1)),concat('a',char(1)));
|
|
865 |
select count(*) from t1 where v='a';
|
|
866 |
count(*)
|
|
867 |
10
|
|
868 |
select count(*) from t1 where c='a';
|
|
869 |
count(*)
|
|
870 |
10
|
|
871 |
select count(*) from t1 where t='a';
|
|
872 |
count(*)
|
|
873 |
10
|
|
874 |
select count(*) from t1 where v='a ';
|
|
875 |
count(*)
|
|
876 |
10
|
|
877 |
select count(*) from t1 where c='a ';
|
|
878 |
count(*)
|
|
879 |
10
|
|
880 |
select count(*) from t1 where t='a ';
|
|
881 |
count(*)
|
|
882 |
10
|
|
883 |
select count(*) from t1 where v between 'a' and 'a ';
|
|
884 |
count(*)
|
|
885 |
10
|
|
886 |
select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n';
|
|
887 |
count(*)
|
|
888 |
10
|
|
889 |
select count(*) from t1 where v like 'a%';
|
|
890 |
count(*)
|
|
891 |
11
|
|
892 |
select count(*) from t1 where c like 'a%';
|
|
893 |
count(*)
|
|
894 |
11
|
|
895 |
select count(*) from t1 where t like 'a%';
|
|
896 |
count(*)
|
|
897 |
11
|
|
898 |
select count(*) from t1 where v like 'a %';
|
|
899 |
count(*)
|
|
900 |
9
|
|
901 |
explain select count(*) from t1 where v='a ';
|
|
902 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
903 |
1 SIMPLE t1 ref v v 43 const # Using where; Using index
|
|
904 |
explain select count(*) from t1 where c='a ';
|
|
905 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
906 |
1 SIMPLE t1 ref c c 43 const # Using where; Using index
|
|
907 |
explain select count(*) from t1 where t='a ';
|
|
908 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
909 |
1 SIMPLE t1 ref t t 43 const # Using where
|
|
910 |
explain select count(*) from t1 where v like 'a%';
|
|
911 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
912 |
1 SIMPLE t1 range v v 43 NULL # Using where; Using index
|
|
913 |
explain select count(*) from t1 where v between 'a' and 'a ';
|
|
914 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
915 |
1 SIMPLE t1 ref v v 43 const # Using where; Using index
|
|
916 |
explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n';
|
|
917 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
918 |
1 SIMPLE t1 ref v v 43 const # Using where; Using index
|
|
919 |
alter table t1 add unique(v);
|
|
920 |
ERROR 23000: Duplicate entry '{ ' for key 'v_2'
|
|
921 |
alter table t1 add key(v);
|
|
922 |
select concat('*',v,'*',c,'*',t,'*') as qq from t1 where v='a';
|
|
923 |
qq
|
|
924 |
*a*a*a*
|
|
925 |
*a *a *a *
|
|
926 |
*a *a *a *
|
|
927 |
*a *a *a *
|
|
928 |
*a *a *a *
|
|
929 |
*a *a *a *
|
|
930 |
*a *a *a *
|
|
931 |
*a *a *a *
|
|
932 |
*a *a *a *
|
|
933 |
*a *a *a *
|
|
934 |
explain select * from t1 where v='a';
|
|
935 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
936 |
1 SIMPLE t1 ref v,v_2 # 43 const # Using where
|
|
937 |
select v,count(*) from t1 group by v limit 10;
|
|
938 |
v count(*)
|
|
939 |
a 1
|
|
940 |
a 10
|
|
941 |
b 10
|
|
942 |
c 10
|
|
943 |
d 10
|
|
944 |
e 10
|
|
945 |
f 10
|
|
946 |
g 10
|
|
947 |
h 10
|
|
948 |
i 10
|
|
949 |
select v,count(t) from t1 group by v limit 10;
|
|
950 |
v count(t)
|
|
951 |
a 1
|
|
952 |
a 10
|
|
953 |
b 10
|
|
954 |
c 10
|
|
955 |
d 10
|
|
956 |
e 10
|
|
957 |
f 10
|
|
958 |
g 10
|
|
959 |
h 10
|
|
960 |
i 10
|
|
961 |
select v,count(c) from t1 group by v limit 10;
|
|
962 |
v count(c)
|
|
963 |
a 1
|
|
964 |
a 10
|
|
965 |
b 10
|
|
966 |
c 10
|
|
967 |
d 10
|
|
968 |
e 10
|
|
969 |
f 10
|
|
970 |
g 10
|
|
971 |
h 10
|
|
972 |
i 10
|
|
973 |
select sql_big_result v,count(t) from t1 group by v limit 10;
|
|
974 |
v count(t)
|
|
975 |
a 1
|
|
976 |
a 10
|
|
977 |
b 10
|
|
978 |
c 10
|
|
979 |
d 10
|
|
980 |
e 10
|
|
981 |
f 10
|
|
982 |
g 10
|
|
983 |
h 10
|
|
984 |
i 10
|
|
985 |
select sql_big_result v,count(c) from t1 group by v limit 10;
|
|
986 |
v count(c)
|
|
987 |
a 1
|
|
988 |
a 10
|
|
989 |
b 10
|
|
990 |
c 10
|
|
991 |
d 10
|
|
992 |
e 10
|
|
993 |
f 10
|
|
994 |
g 10
|
|
995 |
h 10
|
|
996 |
i 10
|
|
997 |
select c,count(*) from t1 group by c limit 10;
|
|
998 |
c count(*)
|
|
999 |
a 1
|
|
1000 |
a 10
|
|
1001 |
b 10
|
|
1002 |
c 10
|
|
1003 |
d 10
|
|
1004 |
e 10
|
|
1005 |
f 10
|
|
1006 |
g 10
|
|
1007 |
h 10
|
|
1008 |
i 10
|
|
1009 |
select c,count(t) from t1 group by c limit 10;
|
|
1010 |
c count(t)
|
|
1011 |
a 1
|
|
1012 |
a 10
|
|
1013 |
b 10
|
|
1014 |
c 10
|
|
1015 |
d 10
|
|
1016 |
e 10
|
|
1017 |
f 10
|
|
1018 |
g 10
|
|
1019 |
h 10
|
|
1020 |
i 10
|
|
1021 |
select sql_big_result c,count(t) from t1 group by c limit 10;
|
|
1022 |
c count(t)
|
|
1023 |
a 1
|
|
1024 |
a 10
|
|
1025 |
b 10
|
|
1026 |
c 10
|
|
1027 |
d 10
|
|
1028 |
e 10
|
|
1029 |
f 10
|
|
1030 |
g 10
|
|
1031 |
h 10
|
|
1032 |
i 10
|
|
1033 |
select t,count(*) from t1 group by t limit 10;
|
|
1034 |
t count(*)
|
|
1035 |
a 1
|
|
1036 |
a 10
|
|
1037 |
b 10
|
|
1038 |
c 10
|
|
1039 |
d 10
|
|
1040 |
e 10
|
|
1041 |
f 10
|
|
1042 |
g 10
|
|
1043 |
h 10
|
|
1044 |
i 10
|
|
1045 |
select t,count(t) from t1 group by t limit 10;
|
|
1046 |
t count(t)
|
|
1047 |
a 1
|
|
1048 |
a 10
|
|
1049 |
b 10
|
|
1050 |
c 10
|
|
1051 |
d 10
|
|
1052 |
e 10
|
|
1053 |
f 10
|
|
1054 |
g 10
|
|
1055 |
h 10
|
|
1056 |
i 10
|
|
1057 |
select sql_big_result t,count(t) from t1 group by t limit 10;
|
|
1058 |
t count(t)
|
|
1059 |
a 1
|
|
1060 |
a 10
|
|
1061 |
b 10
|
|
1062 |
c 10
|
|
1063 |
d 10
|
|
1064 |
e 10
|
|
1065 |
f 10
|
|
1066 |
g 10
|
|
1067 |
h 10
|
|
1068 |
i 10
|
|
1069 |
alter table t1 modify v varchar(300), drop key v, drop key v_2, add key v (v);
|
|
1070 |
show create table t1;
|
|
1071 |
Table Create Table
|
|
1072 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1073 |
`v` varchar(300) DEFAULT NULL,
|
|
1074 |
`c` varchar(10) DEFAULT NULL,
|
|
1075 |
`t` text,
|
|
1076 |
KEY `c` (`c`),
|
|
1077 |
KEY `t` (`t`(10)),
|
|
1078 |
KEY `v` (`v`)
|
|
1079 |
) ENGINE=MyISAM
|
|
1080 |
select count(*) from t1 where v='a';
|
|
1081 |
count(*)
|
|
1082 |
10
|
|
1083 |
select count(*) from t1 where v='a ';
|
|
1084 |
count(*)
|
|
1085 |
10
|
|
1086 |
select count(*) from t1 where v between 'a' and 'a ';
|
|
1087 |
count(*)
|
|
1088 |
10
|
|
1089 |
select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n';
|
|
1090 |
count(*)
|
|
1091 |
10
|
|
1092 |
select count(*) from t1 where v like 'a%';
|
|
1093 |
count(*)
|
|
1094 |
11
|
|
1095 |
select count(*) from t1 where v like 'a %';
|
|
1096 |
count(*)
|
|
1097 |
9
|
|
1098 |
explain select count(*) from t1 where v='a ';
|
|
1099 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1100 |
1 SIMPLE t1 ref v v 1203 const # Using where; Using index
|
|
1101 |
explain select count(*) from t1 where v like 'a%';
|
|
1102 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1103 |
1 SIMPLE t1 range v v 1203 NULL # Using where; Using index
|
|
1104 |
explain select count(*) from t1 where v between 'a' and 'a ';
|
|
1105 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1106 |
1 SIMPLE t1 ref v v 1203 const # Using where; Using index
|
|
1107 |
explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n';
|
|
1108 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1109 |
1 SIMPLE t1 ref v v 1203 const # Using where; Using index
|
|
1110 |
explain select * from t1 where v='a';
|
|
1111 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1112 |
1 SIMPLE t1 ref v v 1203 const # Using where
|
|
1113 |
select v,count(*) from t1 group by v limit 10;
|
|
1114 |
v count(*)
|
|
1115 |
a 1
|
|
1116 |
a 10
|
|
1117 |
b 10
|
|
1118 |
c 10
|
|
1119 |
d 10
|
|
1120 |
e 10
|
|
1121 |
f 10
|
|
1122 |
g 10
|
|
1123 |
h 10
|
|
1124 |
i 10
|
|
1125 |
select v,count(t) from t1 group by v limit 10;
|
|
1126 |
v count(t)
|
|
1127 |
a 1
|
|
1128 |
a 10
|
|
1129 |
b 10
|
|
1130 |
c 10
|
|
1131 |
d 10
|
|
1132 |
e 10
|
|
1133 |
f 10
|
|
1134 |
g 10
|
|
1135 |
h 10
|
|
1136 |
i 10
|
|
1137 |
select sql_big_result v,count(t) from t1 group by v limit 10;
|
|
1138 |
v count(t)
|
|
1139 |
a 1
|
|
1140 |
a 10
|
|
1141 |
b 10
|
|
1142 |
c 10
|
|
1143 |
d 10
|
|
1144 |
e 10
|
|
1145 |
f 10
|
|
1146 |
g 10
|
|
1147 |
h 10
|
|
1148 |
i 10
|
|
1149 |
alter table t1 drop key v, add key v (v(30));
|
|
1150 |
show create table t1;
|
|
1151 |
Table Create Table
|
|
1152 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1153 |
`v` varchar(300) DEFAULT NULL,
|
|
1154 |
`c` varchar(10) DEFAULT NULL,
|
|
1155 |
`t` text,
|
|
1156 |
KEY `c` (`c`),
|
|
1157 |
KEY `t` (`t`(10)),
|
|
1158 |
KEY `v` (`v`(30))
|
|
1159 |
) ENGINE=MyISAM
|
|
1160 |
select count(*) from t1 where v='a';
|
|
1161 |
count(*)
|
|
1162 |
10
|
|
1163 |
select count(*) from t1 where v='a ';
|
|
1164 |
count(*)
|
|
1165 |
10
|
|
1166 |
select count(*) from t1 where v between 'a' and 'a ';
|
|
1167 |
count(*)
|
|
1168 |
10
|
|
1169 |
select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n';
|
|
1170 |
count(*)
|
|
1171 |
10
|
|
1172 |
select count(*) from t1 where v like 'a%';
|
|
1173 |
count(*)
|
|
1174 |
11
|
|
1175 |
select count(*) from t1 where v like 'a %';
|
|
1176 |
count(*)
|
|
1177 |
9
|
|
1178 |
explain select count(*) from t1 where v='a ';
|
|
1179 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1180 |
1 SIMPLE t1 ref v v 123 const # Using where
|
|
1181 |
explain select count(*) from t1 where v like 'a%';
|
|
1182 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1183 |
1 SIMPLE t1 range v v 123 NULL # Using where
|
|
1184 |
explain select count(*) from t1 where v between 'a' and 'a ';
|
|
1185 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1186 |
1 SIMPLE t1 ref v v 123 const # Using where
|
|
1187 |
explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' and 'b\n';
|
|
1188 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1189 |
1 SIMPLE t1 ref v v 123 const # Using where
|
|
1190 |
explain select * from t1 where v='a';
|
|
1191 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1192 |
1 SIMPLE t1 ref v v 123 const # Using where
|
|
1193 |
select v,count(*) from t1 group by v limit 10;
|
|
1194 |
v count(*)
|
|
1195 |
a 1
|
|
1196 |
a 10
|
|
1197 |
b 10
|
|
1198 |
c 10
|
|
1199 |
d 10
|
|
1200 |
e 10
|
|
1201 |
f 10
|
|
1202 |
g 10
|
|
1203 |
h 10
|
|
1204 |
i 10
|
|
1205 |
select v,count(t) from t1 group by v limit 10;
|
|
1206 |
v count(t)
|
|
1207 |
a 1
|
|
1208 |
a 10
|
|
1209 |
b 10
|
|
1210 |
c 10
|
|
1211 |
d 10
|
|
1212 |
e 10
|
|
1213 |
f 10
|
|
1214 |
g 10
|
|
1215 |
h 10
|
|
1216 |
i 10
|
|
1217 |
select sql_big_result v,count(t) from t1 group by v limit 10;
|
|
1218 |
v count(t)
|
|
1219 |
a 1
|
|
1220 |
a 10
|
|
1221 |
b 10
|
|
1222 |
c 10
|
|
1223 |
d 10
|
|
1224 |
e 10
|
|
1225 |
f 10
|
|
1226 |
g 10
|
|
1227 |
h 10
|
|
1228 |
i 10
|
|
1229 |
alter table t1 modify v varchar(600), drop key v, add key v (v);
|
|
1230 |
Warnings:
|
|
1231 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1232 |
show create table t1;
|
|
1233 |
Table Create Table
|
|
1234 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1235 |
`v` varchar(600) DEFAULT NULL,
|
|
1236 |
`c` varchar(10) DEFAULT NULL,
|
|
1237 |
`t` text,
|
|
1238 |
KEY `c` (`c`),
|
|
1239 |
KEY `t` (`t`(10)),
|
|
1240 |
KEY `v` (`v`(333))
|
|
1241 |
) ENGINE=MyISAM
|
|
1242 |
select v,count(*) from t1 group by v limit 10;
|
|
1243 |
v count(*)
|
|
1244 |
a 1
|
|
1245 |
a 10
|
|
1246 |
b 10
|
|
1247 |
c 10
|
|
1248 |
d 10
|
|
1249 |
e 10
|
|
1250 |
f 10
|
|
1251 |
g 10
|
|
1252 |
h 10
|
|
1253 |
i 10
|
|
1254 |
select v,count(t) from t1 group by v limit 10;
|
|
1255 |
v count(t)
|
|
1256 |
a 1
|
|
1257 |
a 10
|
|
1258 |
b 10
|
|
1259 |
c 10
|
|
1260 |
d 10
|
|
1261 |
e 10
|
|
1262 |
f 10
|
|
1263 |
g 10
|
|
1264 |
h 10
|
|
1265 |
i 10
|
|
1266 |
select sql_big_result v,count(t) from t1 group by v limit 10;
|
|
1267 |
v count(t)
|
|
1268 |
a 1
|
|
1269 |
a 10
|
|
1270 |
b 10
|
|
1271 |
c 10
|
|
1272 |
d 10
|
|
1273 |
e 10
|
|
1274 |
f 10
|
|
1275 |
g 10
|
|
1276 |
h 10
|
|
1277 |
i 10
|
|
1278 |
drop table t1;
|
|
1279 |
create TEMPORARY table t1 (a char(10), unique (a));
|
|
1280 |
insert into t1 values ('a ');
|
|
1281 |
insert into t1 values ('a ');
|
|
1282 |
ERROR 23000: Duplicate entry 'a ' for key 'a'
|
|
1283 |
alter table t1 modify a varchar(10);
|
|
1284 |
insert into t1 values ('a '),('a '),('a '),('a ');
|
|
1285 |
ERROR 23000: Duplicate entry 'a ' for key 'a'
|
|
1286 |
insert into t1 values ('a ');
|
|
1287 |
ERROR 23000: Duplicate entry 'a ' for key 'a'
|
|
1288 |
insert into t1 values ('a ');
|
|
1289 |
ERROR 23000: Duplicate entry 'a ' for key 'a'
|
|
1290 |
insert into t1 values ('a ');
|
|
1291 |
ERROR 23000: Duplicate entry 'a ' for key 'a'
|
|
1292 |
update t1 set a='a ' where a like 'a%';
|
|
1293 |
select concat(a,'.') from t1;
|
|
1294 |
concat(a,'.')
|
|
1295 |
a .
|
|
1296 |
update t1 set a='abc ' where a like 'a ';
|
|
1297 |
select concat(a,'.') from t1;
|
|
1298 |
concat(a,'.')
|
|
1299 |
a .
|
|
1300 |
update t1 set a='a ' where a like 'a %';
|
|
1301 |
select concat(a,'.') from t1;
|
|
1302 |
concat(a,'.')
|
|
1303 |
a .
|
|
1304 |
update t1 set a='a ' where a like 'a ';
|
|
1305 |
select concat(a,'.') from t1;
|
|
1306 |
concat(a,'.')
|
|
1307 |
a .
|
|
1308 |
drop table t1;
|
|
1309 |
create TEMPORARY table t1 (v varchar(10), c char(10), t text, key(v(5)), key(c(5)), key(t(5)));
|
|
1310 |
show create table t1;
|
|
1311 |
Table Create Table
|
|
1312 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1313 |
`v` varchar(10) DEFAULT NULL,
|
|
1314 |
`c` varchar(10) DEFAULT NULL,
|
|
1315 |
`t` text,
|
|
1316 |
KEY `v` (`v`(5)),
|
|
1317 |
KEY `c` (`c`(5)),
|
|
1318 |
KEY `t` (`t`(5))
|
|
1319 |
) ENGINE=MyISAM
|
|
1320 |
drop table t1;
|
|
1321 |
create TEMPORARY table t1 (v char(10));
|
|
1322 |
show create table t1;
|
|
1323 |
Table Create Table
|
|
1324 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1325 |
`v` varchar(10) DEFAULT NULL
|
|
1326 |
) ENGINE=MyISAM
|
|
1327 |
drop table t1;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1328 |
create TEMPORARY table t1 (v varchar(10), c char(10));
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1329 |
show create table t1;
|
1330 |
Table Create Table
|
|
1331 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1332 |
`v` varchar(10) DEFAULT NULL,
|
|
1333 |
`c` varchar(10) DEFAULT NULL
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1334 |
) ENGINE=MyISAM
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1335 |
insert into t1 values('a','a'),('a ','a ');
|
1336 |
select concat('*',v,'*',c,'*') from t1;
|
|
1337 |
concat('*',v,'*',c,'*')
|
|
1338 |
*a*a*
|
|
1339 |
*a *a *
|
|
1340 |
drop table t1;
|
|
1341 |
create TEMPORARY table t1(a int, b varchar(12), key ba(b, a));
|
|
1342 |
insert into t1 values (1, 'A'), (20, NULL);
|
|
1343 |
explain select * from t1 where a=20 and b is null;
|
|
1344 |
id select_type table type possible_keys key key_len ref rows Extra
|
|
1345 |
1 SIMPLE t1 ref ba ba 56 const,const 1 Using where; Using index
|
|
1346 |
select * from t1 where a=20 and b is null;
|
|
1347 |
a b
|
|
1348 |
20 NULL
|
|
1349 |
drop table t1;
|
|
1350 |
create temporary table t1 (v varchar(65530), key(v));
|
|
1351 |
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
|
|
1352 |
create temporary table t1 (v varchar(65536));
|
|
1353 |
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
|
|
1354 |
create temporary table t1 (v varchar(65530));
|
|
1355 |
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
|
|
1356 |
create temporary table t1 (v varchar(65535));
|
|
1357 |
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
|
|
1358 |
set storage_engine=PBXT;
|
|
1359 |
create table t1 (a int, key(a));
|
|
1360 |
insert into t1 values (1),(2),(3),(4),(NULL),(NULL),(NULL),(NULL);
|
|
1361 |
analyze table t1;
|
|
1362 |
Table Op Msg_type Msg_text
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1363 |
test.t1 analyze note The storage engine for the table doesn't support analyze
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1364 |
show keys from t1;
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1365 |
Table Unique Key_name Seq_in_index Column_name
|
1366 |
t1 FALSE a 1 a
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1367 |
alter table t1 disable keys;
|
1368 |
Warnings:
|
|
1369 |
Note 1031 Table storage engine for 't1' doesn't have this option
|
|
1370 |
alter table t1 enable keys;
|
|
1371 |
Warnings:
|
|
1372 |
Note 1031 Table storage engine for 't1' doesn't have this option
|
|
1373 |
show keys from t1;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1374 |
Table Unique Key_name Seq_in_index Column_name
|
1375 |
t1 FALSE a 1 a
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1376 |
drop table t1;
|
1377 |
CREATE TEMPORARY TABLE t1(a INT, b INT, KEY inx (a), UNIQUE KEY uinx (b)) ENGINE=MyISAM;
|
|
1378 |
INSERT INTO t1(a,b) VALUES (1,1),(2,2),(3,3),(4,4),(5,5);
|
|
1379 |
SELECT a FROM t1 FORCE INDEX (inx) WHERE a=1;
|
|
1380 |
a
|
|
1381 |
1
|
|
1382 |
ALTER TABLE t1 DISABLE KEYS;
|
|
1383 |
SELECT a FROM t1 FORCE INDEX (inx) WHERE a=1;
|
|
1384 |
a
|
|
1385 |
1
|
|
1386 |
SELECT a FROM t1 USE INDEX (inx) WHERE a=1;
|
|
1387 |
a
|
|
1388 |
1
|
|
1389 |
SELECT b FROM t1 FORCE INDEX (uinx) WHERE b=1;
|
|
1390 |
b
|
|
1391 |
1
|
|
1392 |
SELECT b FROM t1 USE INDEX (uinx) WHERE b=1;
|
|
1393 |
b
|
|
1394 |
1
|
|
1395 |
SELECT a FROM t1 FORCE INDEX (inx,uinx) WHERE a=1;
|
|
1396 |
a
|
|
1397 |
1
|
|
1398 |
ALTER TABLE t1 ENABLE KEYS;
|
|
1399 |
SELECT a FROM t1 FORCE INDEX (inx) WHERE a=1;
|
|
1400 |
a
|
|
1401 |
1
|
|
1402 |
DROP TABLE t1;
|
|
1403 |
CREATE TEMPORARY TABLE t1 (c1 INT, c2 INT, UNIQUE INDEX (c1), INDEX (c2)) ENGINE=MYISAM;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1404 |
show table status like 't1';
|
1405 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
1406 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1407 |
INSERT INTO t1 VALUES (1,1);
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1408 |
show table status like 't1';
|
1409 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
1410 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
1411 |
ALTER TABLE t1 DISABLE KEYS;
|
|
1412 |
show table status like 't1';
|
|
1413 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
1414 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
1415 |
ALTER TABLE t1 ENABLE KEYS;
|
|
1416 |
show table status like 't1';
|
|
1417 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
1418 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
1419 |
ALTER TABLE t1 DISABLE KEYS;
|
|
1420 |
show table status like 't1';
|
|
1421 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
1422 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
1423 |
ALTER TABLE t1 ENABLE KEYS;
|
|
1424 |
show table status like 't1';
|
|
1425 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
|
|
1426 |
# test t1 TEMPORARY MyISAM # # # # #
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1427 |
# Enable keys with parallel repair
|
1428 |
SET GLOBAL myisam_repair_threads=2;
|
|
1429 |
ALTER TABLE t1 DISABLE KEYS;
|
|
1430 |
ALTER TABLE t1 ENABLE KEYS;
|
|
1431 |
SET GLOBAL myisam_repair_threads=1;
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1432 |
CHECK TABLE t1;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1433 |
Table Op Msg_type Msg_text
|
1434 |
test.t1 check status OK
|
|
1435 |
DROP TABLE t1;
|
|
1436 |
CREATE TABLE t1 (id int NOT NULL, ref int NOT NULL, INDEX (id));
|
|
1437 |
CREATE TABLE t2 LIKE t1;
|
|
1438 |
INSERT INTO t2 (id, ref) VALUES (1,3), (2,1), (3,2), (4,5), (4,4);
|
|
1439 |
INSERT INTO t1 SELECT * FROM t2;
|
|
1440 |
SELECT * FROM t1 AS a INNER JOIN t1 AS b USING (id) WHERE a.ref < b.ref;
|
|
1441 |
id ref ref
|
|
1442 |
4 4 5
|
|
1443 |
SELECT * FROM t1;
|
|
1444 |
id ref
|
|
1445 |
1 3
|
|
1446 |
2 1
|
|
1447 |
3 2
|
|
1448 |
4 5
|
|
1449 |
4 4
|
|
1450 |
DROP TABLE t1, t2;
|
|
1451 |
End of 5.0 tests
|
|
1452 |
create temporary table t1 (a int not null, key `a` (a) key_block_size=1024) ENGINE=MyISAM;
|
|
1453 |
show create table t1;
|
|
1454 |
Table Create Table
|
|
1455 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1456 |
`a` int NOT NULL,
|
|
1457 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024
|
|
1458 |
) ENGINE=MyISAM
|
|
1459 |
drop table t1;
|
|
1460 |
create temporary table t1 (a int not null, key `a` (a) key_block_size=2048) ENGINE=MyISAM;
|
|
1461 |
show create table t1;
|
|
1462 |
Table Create Table
|
|
1463 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1464 |
`a` int NOT NULL,
|
|
1465 |
KEY `a` (`a`) KEY_BLOCK_SIZE=2048
|
|
1466 |
) ENGINE=MyISAM
|
|
1467 |
drop table t1;
|
|
1468 |
create temporary table t1 (a varchar(2048), key `a` (a)) ENGINE=MyISAM;
|
|
1469 |
Warnings:
|
|
1470 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1471 |
show create table t1;
|
|
1472 |
Table Create Table
|
|
1473 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1474 |
`a` varchar(2048) DEFAULT NULL,
|
|
1475 |
KEY `a` (`a`(333))
|
|
1476 |
) ENGINE=MyISAM
|
|
1477 |
drop table t1;
|
|
1478 |
create temporary table t1 (a varchar(2048), key `a` (a) key_block_size=1024) ENGINE=MyISAM;
|
|
1479 |
Warnings:
|
|
1480 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1481 |
show create table t1;
|
|
1482 |
Table Create Table
|
|
1483 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1484 |
`a` varchar(2048) DEFAULT NULL,
|
|
1485 |
KEY `a` (`a`(333)) KEY_BLOCK_SIZE=6144
|
|
1486 |
) ENGINE=MyISAM
|
|
1487 |
drop table t1;
|
|
1488 |
create temporary table t1 (a int not null, b varchar(2048), key (a), key(b)) ENGINE=MyISAM key_block_size=1024;
|
|
1489 |
Warnings:
|
|
1490 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1491 |
show create table t1;
|
|
1492 |
Table Create Table
|
|
1493 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1494 |
`a` int NOT NULL,
|
|
1495 |
`b` varchar(2048) DEFAULT NULL,
|
|
1496 |
KEY `a` (`a`),
|
|
1497 |
KEY `b` (`b`(333)) KEY_BLOCK_SIZE=6144
|
|
1498 |
) ENGINE=MyISAM KEY_BLOCK_SIZE=1024
|
|
1499 |
alter table t1 key_block_size=2048;
|
|
1500 |
show create table t1;
|
|
1501 |
Table Create Table
|
|
1502 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1503 |
`a` int NOT NULL,
|
|
1504 |
`b` varchar(2048) DEFAULT NULL,
|
|
1505 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
|
|
1506 |
KEY `b` (`b`(333)) KEY_BLOCK_SIZE=8192
|
|
1507 |
) ENGINE=MyISAM KEY_BLOCK_SIZE=2048
|
|
1508 |
alter table t1 add c int, add key (c);
|
|
1509 |
show create table t1;
|
|
1510 |
Table Create Table
|
|
1511 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1512 |
`a` int NOT NULL,
|
|
1513 |
`b` varchar(2048) DEFAULT NULL,
|
|
1514 |
`c` int DEFAULT NULL,
|
|
1515 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
|
|
1516 |
KEY `b` (`b`(333)) KEY_BLOCK_SIZE=8192,
|
|
1517 |
KEY `c` (`c`)
|
|
1518 |
) ENGINE=MyISAM KEY_BLOCK_SIZE=2048
|
|
1519 |
alter table t1 key_block_size=0;
|
|
1520 |
alter table t1 add d int, add key (d);
|
|
1521 |
show create table t1;
|
|
1522 |
Table Create Table
|
|
1523 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1524 |
`a` int NOT NULL,
|
|
1525 |
`b` varchar(2048) DEFAULT NULL,
|
|
1526 |
`c` int DEFAULT NULL,
|
|
1527 |
`d` int DEFAULT NULL,
|
|
1528 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
|
|
1529 |
KEY `b` (`b`(333)) KEY_BLOCK_SIZE=8192,
|
|
1530 |
KEY `c` (`c`) KEY_BLOCK_SIZE=2048,
|
|
1531 |
KEY `d` (`d`)
|
|
1532 |
) ENGINE=MyISAM
|
|
1533 |
drop table t1;
|
|
1534 |
create temporary table t1 (a int not null, b varchar(2048), key (a), key(b)) ENGINE=MyISAM key_block_size=8192;
|
|
1535 |
Warnings:
|
|
1536 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1537 |
show create table t1;
|
|
1538 |
Table Create Table
|
|
1539 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1540 |
`a` int NOT NULL,
|
|
1541 |
`b` varchar(2048) DEFAULT NULL,
|
|
1542 |
KEY `a` (`a`),
|
|
1543 |
KEY `b` (`b`(333))
|
|
1544 |
) ENGINE=MyISAM KEY_BLOCK_SIZE=8192
|
|
1545 |
drop table t1;
|
|
1546 |
create temporary table t1 (a int not null, b varchar(2048), key (a) key_block_size=1024, key(b)) ENGINE=MyISAM key_block_size=8192;
|
|
1547 |
Warnings:
|
|
1548 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1549 |
show create table t1;
|
|
1550 |
Table Create Table
|
|
1551 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1552 |
`a` int NOT NULL,
|
|
1553 |
`b` varchar(2048) DEFAULT NULL,
|
|
1554 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
|
|
1555 |
KEY `b` (`b`(333))
|
|
1556 |
) ENGINE=MyISAM KEY_BLOCK_SIZE=8192
|
|
1557 |
drop table t1;
|
|
1558 |
create temporary table t1 (a int not null, b int, key (a) key_block_size=1024, key(b) key_block_size=8192) ENGINE=MyISAM key_block_size=16384;
|
|
1559 |
show create table t1;
|
|
1560 |
Table Create Table
|
|
1561 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1562 |
`a` int NOT NULL,
|
|
1563 |
`b` int DEFAULT NULL,
|
|
1564 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
|
|
1565 |
KEY `b` (`b`) KEY_BLOCK_SIZE=8192
|
|
1566 |
) ENGINE=MyISAM KEY_BLOCK_SIZE=16384
|
|
1567 |
drop table t1;
|
|
1568 |
create temporary table t1 (a int not null, key `a` (a) key_block_size=512) ENGINE=MyISAM;
|
|
1569 |
show create table t1;
|
|
1570 |
Table Create Table
|
|
1571 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1572 |
`a` int NOT NULL,
|
|
1573 |
KEY `a` (`a`) KEY_BLOCK_SIZE=1024
|
|
1574 |
) ENGINE=MyISAM
|
|
1575 |
drop table t1;
|
|
1576 |
create temporary table t1 (a varchar(2048), key `a` (a) key_block_size=1000000000000000000) ENGINE=MyISAM;
|
|
1577 |
Warnings:
|
|
1578 |
Warning 1071 Specified key was too long; max key length is 1332 bytes
|
|
1579 |
show create table t1;
|
|
1580 |
Table Create Table
|
|
1581 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1582 |
`a` varchar(2048) DEFAULT NULL,
|
|
1583 |
KEY `a` (`a`(333)) KEY_BLOCK_SIZE=6144
|
|
1584 |
) ENGINE=MyISAM
|
|
1585 |
drop table t1;
|
|
1586 |
create temporary table t1 (a int not null, key `a` (a) key_block_size=1025) ENGINE=MyISAM;
|
|
1587 |
show create table t1;
|
|
1588 |
Table Create Table
|
|
1589 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1590 |
`a` int NOT NULL,
|
|
1591 |
KEY `a` (`a`) KEY_BLOCK_SIZE=2048
|
|
1592 |
) ENGINE=MyISAM
|
|
1593 |
drop table t1;
|
|
1594 |
create temporary table t1 (a int not null, key key_block_size=1024 (a)) ENGINE=MyISAM;
|
|
1595 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '=1024 (a)) ENGINE=MyISAM' at line 1
|
|
1596 |
create temporary table t1 (a int not null, key `a` key_block_size=1024 (a)) ENGINE=MyISAM;
|
|
1597 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'key_block_size=1024 (a)) ENGINE=MyISAM' at line 1
|
|
1598 |
CREATE temporary TABLE t1 (
|
|
1599 |
c1 INT,
|
|
1600 |
c2 VARCHAR(300),
|
|
1601 |
KEY (c1) KEY_BLOCK_SIZE 1024,
|
|
1602 |
KEY (c2) KEY_BLOCK_SIZE 8192
|
|
1603 |
) ENGINE=MyISAM;
|
|
1604 |
INSERT INTO t1 VALUES (10, REPEAT('a', CEIL(RAND(10) * 300))),
|
|
1605 |
(11, REPEAT('b', CEIL(RAND() * 300))),
|
|
1606 |
(12, REPEAT('c', CEIL(RAND() * 300))),
|
|
1607 |
(13, REPEAT('d', CEIL(RAND() * 300))),
|
|
1608 |
(14, REPEAT('e', CEIL(RAND() * 300))),
|
|
1609 |
(15, REPEAT('f', CEIL(RAND() * 300))),
|
|
1610 |
(16, REPEAT('g', CEIL(RAND() * 300))),
|
|
1611 |
(17, REPEAT('h', CEIL(RAND() * 300))),
|
|
1612 |
(18, REPEAT('i', CEIL(RAND() * 300))),
|
|
1613 |
(19, REPEAT('j', CEIL(RAND() * 300))),
|
|
1614 |
(20, REPEAT('k', CEIL(RAND() * 300))),
|
|
1615 |
(21, REPEAT('l', CEIL(RAND() * 300))),
|
|
1616 |
(22, REPEAT('m', CEIL(RAND() * 300))),
|
|
1617 |
(23, REPEAT('n', CEIL(RAND() * 300))),
|
|
1618 |
(24, REPEAT('o', CEIL(RAND() * 300))),
|
|
1619 |
(25, REPEAT('p', CEIL(RAND() * 300))),
|
|
1620 |
(26, REPEAT('q', CEIL(RAND() * 300))),
|
|
1621 |
(27, REPEAT('r', CEIL(RAND() * 300))),
|
|
1622 |
(28, REPEAT('s', CEIL(RAND() * 300))),
|
|
1623 |
(29, REPEAT('t', CEIL(RAND() * 300))),
|
|
1624 |
(30, REPEAT('u', CEIL(RAND() * 300))),
|
|
1625 |
(31, REPEAT('v', CEIL(RAND() * 300))),
|
|
1626 |
(32, REPEAT('w', CEIL(RAND() * 300))),
|
|
1627 |
(33, REPEAT('x', CEIL(RAND() * 300))),
|
|
1628 |
(34, REPEAT('y', CEIL(RAND() * 300))),
|
|
1629 |
(35, REPEAT('z', CEIL(RAND() * 300)));
|
|
1630 |
CREATE TEMPORARY TABLE t2 AS SELECT * FROM t1;
|
|
1631 |
INSERT INTO t1 SELECT * FROM t2;
|
|
1632 |
DROP TABLE t2;
|
|
1633 |
CREATE TEMPORARY TABLE t2 AS SELECT * FROM t1;
|
|
1634 |
INSERT INTO t1 SELECT * FROM t2;
|
|
1635 |
DROP TABLE t2;
|
|
1636 |
CHECK TABLE t1;
|
|
1637 |
Table Op Msg_type Msg_text
|
|
1638 |
test.t1 check status OK
|
|
1639 |
DELETE FROM t1 WHERE c1 >= 10;
|
|
1640 |
CHECK TABLE t1;
|
|
1641 |
Table Op Msg_type Msg_text
|
|
1642 |
test.t1 check status OK
|
|
1643 |
DROP TABLE t1;
|
|
1644 |
CREATE temporary TABLE t1 (
|
|
1645 |
c1 CHAR(130),
|
|
1646 |
c2 VARCHAR(1)
|
|
1647 |
) ENGINE=MyISAM;
|
|
1648 |
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
|
|
1649 |
SELECT COUNT(*) FROM t1;
|
|
1650 |
COUNT(*)
|
|
1651 |
1
|
|
1652 |
CHECK TABLE t1;
|
|
1653 |
Table Op Msg_type Msg_text
|
|
1654 |
test.t1 check status OK
|
|
1655 |
SELECT COUNT(*) FROM t1;
|
|
1656 |
COUNT(*)
|
|
1657 |
1
|
|
1658 |
CHECK TABLE t1;
|
|
1659 |
Table Op Msg_type Msg_text
|
|
1660 |
test.t1 check status OK
|
|
1661 |
DROP TABLE t1;
|
|
1662 |
CREATE temporary TABLE t1 (
|
|
1663 |
c1 CHAR(130),
|
|
1664 |
c2 VARCHAR(1)
|
|
1665 |
) ENGINE=MyISAM;
|
|
1666 |
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
|
|
1667 |
SELECT COUNT(*) FROM t1;
|
|
1668 |
COUNT(*)
|
|
1669 |
1
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1670 |
CHECK TABLE t1;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1671 |
Table Op Msg_type Msg_text
|
1672 |
test.t1 check status OK
|
|
1673 |
SELECT COUNT(*) FROM t1;
|
|
1674 |
COUNT(*)
|
|
1675 |
1
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1676 |
CHECK TABLE t1;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1677 |
Table Op Msg_type Msg_text
|
1678 |
test.t1 check status OK
|
|
1679 |
DROP TABLE t1;
|
|
1680 |
CREATE temporary TABLE t1 (
|
|
1681 |
c1 CHAR(130),
|
|
1682 |
c2 VARCHAR(1)
|
|
1683 |
) ENGINE=MyISAM;
|
|
1684 |
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
|
|
1685 |
INSERT INTO t1 VALUES('b', 'b');
|
|
1686 |
INSERT INTO t1 VALUES('c', 'b');
|
|
1687 |
DELETE FROM t1 WHERE c1='b';
|
|
1688 |
SELECT COUNT(*) FROM t1;
|
|
1689 |
COUNT(*)
|
|
1690 |
2
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1691 |
ALTER TABLE t1 ENGINE=MyISAM;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1692 |
SELECT COUNT(*) FROM t1;
|
1693 |
COUNT(*)
|
|
1694 |
2
|
|
1695 |
DROP TABLE t1;
|
|
1696 |
CREATE temporary TABLE t1 (
|
|
1697 |
c1 CHAR(130),
|
|
1698 |
c2 VARCHAR(1),
|
|
1699 |
KEY (c1)
|
|
1700 |
) ENGINE=MyISAM;
|
|
1701 |
# Insert 100 rows. Query log disabled.
|
|
1702 |
UPDATE t1 SET c1=REPEAT("a",128) LIMIT 90;
|
|
1703 |
SELECT COUNT(*) FROM t1;
|
|
1704 |
COUNT(*)
|
|
1705 |
100
|
|
1706 |
ALTER TABLE t1 ENGINE=MyISAM;
|
|
1707 |
SELECT COUNT(*) FROM t1;
|
|
1708 |
COUNT(*)
|
|
1709 |
100
|
|
1710 |
CHECK TABLE t1;
|
|
1711 |
Table Op Msg_type Msg_text
|
|
1712 |
test.t1 check status OK
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1713 |
CHECK TABLE t1;
|
1714 |
Table Op Msg_type Msg_text
|
|
1715 |
test.t1 check status OK
|
|
1716 |
DROP TABLE t1;
|
|
1717 |
CREATE temporary TABLE t1 (
|
|
1718 |
c1 CHAR(50),
|
|
1719 |
c2 VARCHAR(1)
|
|
1720 |
) ENGINE=MyISAM;
|
|
1721 |
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
|
|
1722 |
SELECT COUNT(*) FROM t1;
|
|
1723 |
COUNT(*)
|
|
1724 |
1
|
|
1725 |
CHECK TABLE t1;
|
|
1726 |
Table Op Msg_type Msg_text
|
|
1727 |
test.t1 check status OK
|
|
1728 |
SELECT COUNT(*) FROM t1;
|
|
1729 |
COUNT(*)
|
|
1730 |
1
|
|
1731 |
CHECK TABLE t1;
|
|
1732 |
Table Op Msg_type Msg_text
|
|
1733 |
test.t1 check status OK
|
|
1734 |
DROP TABLE t1;
|
|
1735 |
CREATE temporary TABLE t1 (
|
|
1736 |
c1 CHAR(50),
|
|
1737 |
c2 VARCHAR(1)
|
|
1738 |
) ENGINE=MyISAM;
|
|
1739 |
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
|
|
1740 |
SELECT COUNT(*) FROM t1;
|
|
1741 |
COUNT(*)
|
|
1742 |
1
|
|
1743 |
CHECK TABLE t1;
|
|
1744 |
Table Op Msg_type Msg_text
|
|
1745 |
test.t1 check status OK
|
|
1746 |
SELECT COUNT(*) FROM t1;
|
|
1747 |
COUNT(*)
|
|
1748 |
1
|
|
1749 |
CHECK TABLE t1;
|
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1750 |
Table Op Msg_type Msg_text
|
1751 |
test.t1 check status OK
|
|
1752 |
DROP TABLE t1;
|
|
1753 |
CREATE temporary TABLE t1 (
|
|
1754 |
c1 CHAR(50),
|
|
1755 |
c2 VARCHAR(1)
|
|
1756 |
) ENGINE=MyISAM;
|
|
1757 |
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
|
|
1758 |
INSERT INTO t1 VALUES('b', 'b');
|
|
1759 |
INSERT INTO t1 VALUES('c', 'b');
|
|
1760 |
DELETE FROM t1 WHERE c1='b';
|
|
1761 |
SELECT COUNT(*) FROM t1;
|
|
1762 |
COUNT(*)
|
|
1763 |
2
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1764 |
ALTER TABLE t1 ENGINE=MyISAM;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1765 |
SELECT COUNT(*) FROM t1;
|
1766 |
COUNT(*)
|
|
1767 |
2
|
|
1768 |
DROP TABLE t1;
|
|
1769 |
CREATE temporary TABLE t1 (
|
|
1770 |
c1 CHAR(50),
|
|
1771 |
c2 VARCHAR(1),
|
|
1772 |
KEY (c1)
|
|
1773 |
) ENGINE=MyISAM;
|
|
1774 |
# Insert 100 rows. Query log disabled.
|
|
1775 |
UPDATE t1 SET c1=REPEAT( x'e0ae85',43) LIMIT 90;
|
|
1776 |
SELECT COUNT(*) FROM t1;
|
|
1777 |
COUNT(*)
|
|
1778 |
100
|
|
1779 |
ALTER TABLE t1 ENGINE=MyISAM;
|
|
1780 |
SELECT COUNT(*) FROM t1;
|
|
1781 |
COUNT(*)
|
|
1782 |
100
|
|
1783 |
CHECK TABLE t1;
|
|
1784 |
Table Op Msg_type Msg_text
|
|
1785 |
test.t1 check status OK
|
|
|
1455.3.7
by Paul McCullagh
Fixed PBXT specific test results |
1786 |
CHECK TABLE t1;
|
|
1455.3.1
by Vladimir Kolesnikov
lp:drizzle + pbxt 1.1 + test results |
1787 |
Table Op Msg_type Msg_text
|
1788 |
test.t1 check status OK
|
|
1789 |
DROP TABLE t1;
|
|
1790 |
End of 5.1 tests
|