40
40
t1 0 PRIMARY 1 a A 5 NULL NULL BTREE
41
41
t1 1 b 1 b A 5 NULL NULL BTREE
43
create table t1 (a int not null, b int not null, c int not null, primary key (a),key(b)) engine=myisam;
43
create temporary table t1 (a int not null, b int not null, c int not null, primary key (a),key(b)) engine=myisam;
44
44
insert into t1 values (3,3,3),(1,1,1),(2,2,2),(4,4,4);
45
45
explain select * from t1 order by a;
46
46
id select_type table type possible_keys key key_len ref rows Extra
106
106
Table Op Msg_type Msg_text
107
107
test.t1 check status OK
109
create table t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8
109
create temporary table t1 (i1 int, i2 int, i3 int, i4 int, i5 int, i6 int, i7 int, i8
110
110
int, i9 int, i10 int, i11 int, i12 int, i13 int, i14 int, i15 int, i16 int, i17
111
111
int, i18 int, i19 int, i20 int, i21 int, i22 int, i23 int, i24 int, i25 int,
112
112
i26 int, i27 int, i28 int, i29 int, i30 int, i31 int, i32 int, i33 int, i34
304
304
Table Op Msg_type Msg_text
305
305
test.t1 check status OK
307
CREATE 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;
307
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;
308
308
ERROR 42000: Specified key was too long; max key length is 1332 bytes
309
CREATE TABLE t1 (a varchar(300), b varchar(300), c varchar(300), d varchar(300), e varchar(300)) ENGINE=MyISAM;
309
CREATE TEMPORARY TABLE t1 (a varchar(300), b varchar(300), c varchar(300), d varchar(300), e varchar(300)) ENGINE=MyISAM;
310
310
ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e);
311
311
ERROR 42000: Specified key was too long; max key length is 1332 bytes
313
CREATE TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a)) ENGINE=MyISAM;
313
CREATE TEMPORARY TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a)) ENGINE=MyISAM;
314
314
INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4);
315
315
create table t2 (a int not null, b int, c int, key(b), key(c), key(a));
316
316
INSERT into t2 values (1,1,1), (2,2,2);
402
create table t1(a text not null, b text not null, c text not null, index (a(10),b(10),c(10)));
402
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;
403
403
insert into t1 values('807780', '477', '165');
404
404
insert into t1 values('807780', '477', '162');
405
405
insert into t1 values('807780', '472', '162');
692
CREATE TABLE t1 (c1 TEXT) ENGINE=MyISAM AVG_ROW_LENGTH=70100 MAX_ROWS=4100100100;
690
CREATE TEMPORARY TABLE t1 (c1 TEXT) ENGINE=MyISAM AVG_ROW_LENGTH=70100 MAX_ROWS=4100100100;
693
691
SHOW TABLE STATUS LIKE 't1';
694
692
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
695
t1 MyISAM 0 Dynamic X X X 72057594037927935 X X X X X X utf8_general_ci X max_rows=4100100100 avg_row_length=70100
697
CREATE TABLE t1 (c1 TEXT NOT NULL, KEY c1 (c1(10))) ENGINE=MyISAM;
694
CREATE TEMPORARY TABLE t1 (c1 TEXT NOT NULL, KEY c1 (c1(10))) ENGINE=MyISAM;
698
695
INSERT INTO t1 VALUES
699
696
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
700
697
(CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)), (CHAR(9,65)),
849
846
drop table if exists t1,t2,t3;
850
847
--- Testing varchar ---
851
848
--- Testing varchar ---
852
create table t1 (v varchar(10), c char(10), t text);
849
create TEMPORARY table t1 (v varchar(10), c char(10), t text);
853
850
insert into t1 values('+ ', '+ ', '+ ');
854
851
set @a=repeat(' ',20);
855
852
insert into t1 values (concat('+',@a),concat('+',@a),concat('+',@a));
863
860
show create table t1;
864
861
Table Create Table
865
t1 CREATE TABLE `t1` (
862
t1 CREATE TEMPORARY TABLE `t1` (
866
863
`v` varchar(10) DEFAULT NULL,
867
864
`c` varchar(10) DEFAULT NULL,
870
create table t2 like t1;
867
create TEMPORARY table t2 like t1;
871
868
show create table t2;
872
869
Table Create Table
873
t2 CREATE TABLE `t2` (
870
t2 CREATE TEMPORARY TABLE `t2` (
874
871
`v` varchar(10) DEFAULT NULL,
875
872
`c` varchar(10) DEFAULT NULL,
878
create table t3 select * from t1;
875
create TEMPORARY table t3 select * from t1;
879
876
show create table t3;
880
877
Table Create Table
881
t3 CREATE TABLE `t3` (
878
t3 CREATE TEMPORARY TABLE `t3` (
882
879
`v` varchar(10) DEFAULT NULL,
883
880
`c` varchar(10) DEFAULT NULL,
916
913
drop table t1,t2,t3;
917
create table t1 (v varchar(10), c char(10), t text, key(v), key(c), key(t(10)));
914
create TEMPORARY table t1 (v varchar(10), c char(10), t text, key(v), key(c), key(t(10)));
918
915
show create table t1;
919
916
Table Create Table
920
t1 CREATE TABLE `t1` (
917
t1 CREATE TEMPORARY TABLE `t1` (
921
918
`v` varchar(10) DEFAULT NULL,
922
919
`c` varchar(10) DEFAULT NULL,
1376
create table t1 (v varchar(10), c char(10), t text, key(v(5)), key(c(5)), key(t(5)));
1373
create TEMPORARY table t1 (v varchar(10), c char(10), t text, key(v(5)), key(c(5)), key(t(5)));
1377
1374
show create table t1;
1378
1375
Table Create Table
1379
t1 CREATE TABLE `t1` (
1376
t1 CREATE TEMPORARY TABLE `t1` (
1380
1377
`v` varchar(10) DEFAULT NULL,
1381
1378
`c` varchar(10) DEFAULT NULL,
1385
1382
KEY `t` (`t`(5))
1386
1383
) ENGINE=MyISAM
1388
create table t1 (v char(10));
1385
create TEMPORARY table t1 (v char(10));
1389
1386
show create table t1;
1390
1387
Table Create Table
1391
t1 CREATE TABLE `t1` (
1388
t1 CREATE TEMPORARY TABLE `t1` (
1392
1389
`v` varchar(10) DEFAULT NULL
1393
1390
) ENGINE=MyISAM
1395
create table t1 (v varchar(10), c char(10)) row_format=fixed;
1392
create TEMPORARY table t1 (v varchar(10), c char(10)) row_format=fixed;
1396
1393
show create table t1;
1397
1394
Table Create Table
1398
t1 CREATE TABLE `t1` (
1395
t1 CREATE TEMPORARY TABLE `t1` (
1399
1396
`v` varchar(10) DEFAULT NULL,
1400
1397
`c` varchar(10) DEFAULT NULL
1401
1398
) ENGINE=MyISAM ROW_FORMAT=FIXED
1408
create table t1(a int, b varchar(12), key ba(b, a));
1405
create TEMPORARY table t1(a int, b varchar(12), key ba(b, a));
1409
1406
insert into t1 values (1, 'A'), (20, NULL);
1410
1407
explain select * from t1 where a=20 and b is null;
1411
1408
id select_type table type possible_keys key key_len ref rows Extra
1417
create table t1 (v varchar(65530), key(v));
1418
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1419
create table t1 (v varchar(65536));
1420
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1421
create table t1 (v varchar(65530));
1422
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1423
create table t1 (v varchar(65535));
1414
create temporary table t1 (v varchar(65530), key(v));
1415
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1416
create temporary table t1 (v varchar(65536));
1417
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1418
create temporary table t1 (v varchar(65530));
1419
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1420
create temporary table t1 (v varchar(65535));
1424
1421
ERROR 42000: Column length too big for column 'v' (max = 16383); use BLOB or TEXT instead
1425
1422
set storage_engine=InnoDB;
1426
1423
create table t1 (a int, key(a));
1441
1438
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
1442
1439
t1 1 a 1 a A 8 NULL NULL YES BTREE
1444
create table t1 (c1 int) engine=myisam pack_keys=0;
1445
create table t2 (c1 int) engine=myisam pack_keys=1;
1446
create table t3 (c1 int) engine=myisam pack_keys=default;
1447
create table t4 (c1 int) engine=myisam pack_keys=2;
1441
create temporary table t1 (c1 int) engine=myisam pack_keys=0;
1442
create temporary table t2 (c1 int) engine=myisam pack_keys=1;
1443
create temporary table t3 (c1 int) engine=myisam pack_keys=default;
1444
create temporary table t4 (c1 int) engine=myisam pack_keys=2;
1448
1445
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 '2' at line 1
1449
1446
drop table t1, t2, t3;
1450
CREATE TABLE t1(a INT, b INT, KEY inx (a), UNIQUE KEY uinx (b)) ENGINE=MyISAM;
1447
CREATE TEMPORARY TABLE t1(a INT, b INT, KEY inx (a), UNIQUE KEY uinx (b)) ENGINE=MyISAM;
1451
1448
INSERT INTO t1(a,b) VALUES (1,1),(2,2),(3,3),(4,4),(5,5);
1452
1449
SELECT a FROM t1 FORCE INDEX (inx) WHERE a=1;
1476
CREATE TABLE t1 (c1 INT, c2 INT, UNIQUE INDEX (c1), INDEX (c2)) ENGINE=MYISAM;
1473
CREATE TEMPORARY TABLE t1 (c1 INT, c2 INT, UNIQUE INDEX (c1), INDEX (c2)) ENGINE=MYISAM;
1477
1474
SHOW TABLE STATUS LIKE 't1';
1478
1475
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1479
t1 MyISAM 0 Fixed 0 # # # 1024 # # # # # # #
1480
1476
INSERT INTO t1 VALUES (1,1);
1481
1477
SHOW TABLE STATUS LIKE 't1';
1482
1478
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1483
t1 MyISAM 0 Fixed 1 # # # 3072 # # # # # # #
1484
ALTER TABLE t1 DISABLE KEYS;
1485
SHOW TABLE STATUS LIKE 't1';
1486
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1487
t1 MyISAM 0 Fixed 1 # # # 3072 # # # # # # #
1488
ALTER TABLE t1 ENABLE KEYS;
1489
SHOW TABLE STATUS LIKE 't1';
1490
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1491
t1 MyISAM 0 Fixed 1 # # # 3072 # # # # # # #
1492
ALTER TABLE t1 DISABLE KEYS;
1493
SHOW TABLE STATUS LIKE 't1';
1494
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1495
t1 MyISAM 0 Fixed 1 # # # 3072 # # # # # # #
1496
ALTER TABLE t1 ENABLE KEYS;
1497
SHOW TABLE STATUS LIKE 't1';
1498
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1499
t1 MyISAM 0 Fixed 1 # # # 3072 # # # # # # #
1479
ALTER TABLE t1 DISABLE KEYS;
1480
SHOW TABLE STATUS LIKE 't1';
1481
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1482
ALTER TABLE t1 ENABLE KEYS;
1483
SHOW TABLE STATUS LIKE 't1';
1484
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1485
ALTER TABLE t1 DISABLE KEYS;
1486
SHOW TABLE STATUS LIKE 't1';
1487
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1488
ALTER TABLE t1 ENABLE KEYS;
1489
SHOW TABLE STATUS LIKE 't1';
1490
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
1500
1491
# Enable keys with parallel repair
1501
1492
SET GLOBAL myisam_repair_threads=2;
1502
1493
ALTER TABLE t1 DISABLE KEYS;
1506
1497
Table Op Msg_type Msg_text
1507
1498
test.t1 check status OK
1509
CREATE TABLE t1 (id int NOT NULL, ref int NOT NULL, INDEX (id)) ENGINE=MyISAM;
1500
CREATE TABLE t1 (id int NOT NULL, ref int NOT NULL, INDEX (id));
1510
1501
CREATE TABLE t2 LIKE t1;
1511
1502
INSERT INTO t2 (id, ref) VALUES (1,3), (2,1), (3,2), (4,5), (4,4);
1512
1503
INSERT INTO t1 SELECT * FROM t2;
1530
1521
DROP TABLE t1, t2;
1531
1522
End of 5.0 tests
1532
create table t1 (a int not null, key `a` (a) key_block_size=1024) ENGINE=MyISAM;
1523
create temporary table t1 (a int not null, key `a` (a) key_block_size=1024) ENGINE=MyISAM;
1533
1524
show create table t1;
1534
1525
Table Create Table
1535
t1 CREATE TABLE `t1` (
1526
t1 CREATE TEMPORARY TABLE `t1` (
1536
1527
`a` int NOT NULL,
1537
1528
KEY `a` (`a`) KEY_BLOCK_SIZE=1024
1538
1529
) ENGINE=MyISAM
1540
create table t1 (a int not null, key `a` (a) key_block_size=2048) ENGINE=MyISAM;
1531
create temporary table t1 (a int not null, key `a` (a) key_block_size=2048) ENGINE=MyISAM;
1541
1532
show create table t1;
1542
1533
Table Create Table
1543
t1 CREATE TABLE `t1` (
1534
t1 CREATE TEMPORARY TABLE `t1` (
1544
1535
`a` int NOT NULL,
1545
1536
KEY `a` (`a`) KEY_BLOCK_SIZE=2048
1546
1537
) ENGINE=MyISAM
1548
create table t1 (a varchar(2048), key `a` (a)) ENGINE=MyISAM;
1539
create temporary table t1 (a varchar(2048), key `a` (a)) ENGINE=MyISAM;
1550
1541
Warning 1071 Specified key was too long; max key length is 1332 bytes
1551
1542
show create table t1;
1552
1543
Table Create Table
1553
t1 CREATE TABLE `t1` (
1544
t1 CREATE TEMPORARY TABLE `t1` (
1554
1545
`a` varchar(2048) DEFAULT NULL,
1555
1546
KEY `a` (`a`(333))
1556
1547
) ENGINE=MyISAM
1558
create table t1 (a varchar(2048), key `a` (a) key_block_size=1024) ENGINE=MyISAM;
1549
create temporary table t1 (a varchar(2048), key `a` (a) key_block_size=1024) ENGINE=MyISAM;
1560
1551
Warning 1071 Specified key was too long; max key length is 1332 bytes
1561
1552
show create table t1;
1562
1553
Table Create Table
1563
t1 CREATE TABLE `t1` (
1554
t1 CREATE TEMPORARY TABLE `t1` (
1564
1555
`a` varchar(2048) DEFAULT NULL,
1565
1556
KEY `a` (`a`(333)) KEY_BLOCK_SIZE=6144
1566
1557
) ENGINE=MyISAM
1568
create table t1 (a int not null, b varchar(2048), key (a), key(b)) ENGINE=MyISAM key_block_size=1024;
1559
create temporary table t1 (a int not null, b varchar(2048), key (a), key(b)) ENGINE=MyISAM key_block_size=1024;
1570
1561
Warning 1071 Specified key was too long; max key length is 1332 bytes
1571
1562
show create table t1;
1572
1563
Table Create Table
1573
t1 CREATE TABLE `t1` (
1564
t1 CREATE TEMPORARY TABLE `t1` (
1574
1565
`a` int NOT NULL,
1575
1566
`b` varchar(2048) DEFAULT NULL,
1612
1603
) ENGINE=MyISAM
1614
create table t1 (a int not null, b varchar(2048), key (a), key(b)) ENGINE=MyISAM key_block_size=8192;
1605
create temporary table t1 (a int not null, b varchar(2048), key (a), key(b)) ENGINE=MyISAM key_block_size=8192;
1616
1607
Warning 1071 Specified key was too long; max key length is 1332 bytes
1617
1608
show create table t1;
1618
1609
Table Create Table
1619
t1 CREATE TABLE `t1` (
1610
t1 CREATE TEMPORARY TABLE `t1` (
1620
1611
`a` int NOT NULL,
1621
1612
`b` varchar(2048) DEFAULT NULL,
1623
1614
KEY `b` (`b`(333))
1624
1615
) ENGINE=MyISAM KEY_BLOCK_SIZE=8192
1626
create table t1 (a int not null, b varchar(2048), key (a) key_block_size=1024, key(b)) ENGINE=MyISAM key_block_size=8192;
1617
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;
1628
1619
Warning 1071 Specified key was too long; max key length is 1332 bytes
1629
1620
show create table t1;
1630
1621
Table Create Table
1631
t1 CREATE TABLE `t1` (
1622
t1 CREATE TEMPORARY TABLE `t1` (
1632
1623
`a` int NOT NULL,
1633
1624
`b` varchar(2048) DEFAULT NULL,
1634
1625
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
1635
1626
KEY `b` (`b`(333))
1636
1627
) ENGINE=MyISAM KEY_BLOCK_SIZE=8192
1638
create 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;
1629
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;
1639
1630
show create table t1;
1640
1631
Table Create Table
1641
t1 CREATE TABLE `t1` (
1632
t1 CREATE TEMPORARY TABLE `t1` (
1642
1633
`a` int NOT NULL,
1643
1634
`b` int DEFAULT NULL,
1644
1635
KEY `a` (`a`) KEY_BLOCK_SIZE=1024,
1645
1636
KEY `b` (`b`) KEY_BLOCK_SIZE=8192
1646
1637
) ENGINE=MyISAM KEY_BLOCK_SIZE=16384
1648
create table t1 (a int not null, key `a` (a) key_block_size=512) ENGINE=MyISAM;
1639
create temporary table t1 (a int not null, key `a` (a) key_block_size=512) ENGINE=MyISAM;
1649
1640
show create table t1;
1650
1641
Table Create Table
1651
t1 CREATE TABLE `t1` (
1642
t1 CREATE TEMPORARY TABLE `t1` (
1652
1643
`a` int NOT NULL,
1653
1644
KEY `a` (`a`) KEY_BLOCK_SIZE=1024
1654
1645
) ENGINE=MyISAM
1656
create table t1 (a varchar(2048), key `a` (a) key_block_size=1000000000000000000) ENGINE=MyISAM;
1647
create temporary table t1 (a varchar(2048), key `a` (a) key_block_size=1000000000000000000) ENGINE=MyISAM;
1658
1649
Warning 1071 Specified key was too long; max key length is 1332 bytes
1659
1650
show create table t1;
1660
1651
Table Create Table
1661
t1 CREATE TABLE `t1` (
1652
t1 CREATE TEMPORARY TABLE `t1` (
1662
1653
`a` varchar(2048) DEFAULT NULL,
1663
1654
KEY `a` (`a`(333)) KEY_BLOCK_SIZE=6144
1664
1655
) ENGINE=MyISAM
1666
create table t1 (a int not null, key `a` (a) key_block_size=1025) ENGINE=MyISAM;
1657
create temporary table t1 (a int not null, key `a` (a) key_block_size=1025) ENGINE=MyISAM;
1667
1658
show create table t1;
1668
1659
Table Create Table
1669
t1 CREATE TABLE `t1` (
1660
t1 CREATE TEMPORARY TABLE `t1` (
1670
1661
`a` int NOT NULL,
1671
1662
KEY `a` (`a`) KEY_BLOCK_SIZE=2048
1672
1663
) ENGINE=MyISAM
1674
create table t1 (a int not null, key key_block_size=1024 (a)) ENGINE=MyISAM;
1665
create temporary table t1 (a int not null, key key_block_size=1024 (a)) ENGINE=MyISAM;
1675
1666
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
1676
create table t1 (a int not null, key `a` key_block_size=1024 (a)) ENGINE=MyISAM;
1667
create temporary table t1 (a int not null, key `a` key_block_size=1024 (a)) ENGINE=MyISAM;
1677
1668
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
1669
CREATE temporary TABLE t1 (
1680
1671
c2 VARCHAR(300),
1681
1672
KEY (c1) KEY_BLOCK_SIZE 1024,
1707
1698
(33, REPEAT('x', CEIL(RAND() * 300))),
1708
1699
(34, REPEAT('y', CEIL(RAND() * 300))),
1709
1700
(35, REPEAT('z', CEIL(RAND() * 300)));
1710
INSERT INTO t1 SELECT * FROM t1;
1711
INSERT INTO t1 SELECT * FROM t1;
1701
CREATE TEMPORARY TABLE t2 AS SELECT * FROM t1;
1702
INSERT INTO t1 SELECT * FROM t2;
1704
CREATE TEMPORARY TABLE t2 AS SELECT * FROM t1;
1705
INSERT INTO t1 SELECT * FROM t2;
1712
1707
CHECK TABLE t1;
1713
1708
Table Op Msg_type Msg_text
1714
1709
test.t1 check status OK
1717
1712
Table Op Msg_type Msg_text
1718
1713
test.t1 check status OK
1724
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
1725
SELECT COUNT(*) FROM t1;
1729
Table Op Msg_type Msg_text
1730
test.t1 check status OK
1731
SELECT COUNT(*) FROM t1;
1735
Table Op Msg_type Msg_text
1736
test.t1 check status OK
1742
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
1743
SELECT COUNT(*) FROM t1;
1746
CHECK TABLE t1 EXTENDED;
1747
Table Op Msg_type Msg_text
1748
test.t1 check status OK
1749
SELECT COUNT(*) FROM t1;
1752
CHECK TABLE t1 EXTENDED;
1753
Table Op Msg_type Msg_text
1754
test.t1 check status OK
1715
CREATE temporary TABLE t1 (
1719
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
1720
SELECT COUNT(*) FROM t1;
1724
Table Op Msg_type Msg_text
1725
test.t1 check status OK
1726
SELECT COUNT(*) FROM t1;
1730
Table Op Msg_type Msg_text
1731
test.t1 check status OK
1733
CREATE temporary TABLE t1 (
1737
INSERT INTO t1 VALUES(REPEAT("a",128), 'b');
1738
SELECT COUNT(*) FROM t1;
1741
CHECK TABLE t1 EXTENDED;
1742
Table Op Msg_type Msg_text
1743
test.t1 check status OK
1744
SELECT COUNT(*) FROM t1;
1747
CHECK TABLE t1 EXTENDED;
1748
Table Op Msg_type Msg_text
1749
test.t1 check status OK
1751
CREATE temporary TABLE t1 (
1759
1754
) ENGINE=MyISAM;
1792
1787
Table Op Msg_type Msg_text
1793
1788
test.t1 check status OK
1799
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
1800
SELECT COUNT(*) FROM t1;
1804
Table Op Msg_type Msg_text
1805
test.t1 check status OK
1806
SELECT COUNT(*) FROM t1;
1810
Table Op Msg_type Msg_text
1811
test.t1 check status OK
1817
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
1818
SELECT COUNT(*) FROM t1;
1821
CHECK TABLE t1 EXTENDED;
1822
Table Op Msg_type Msg_text
1823
test.t1 check status OK
1824
SELECT COUNT(*) FROM t1;
1827
CHECK TABLE t1 EXTENDED;
1828
Table Op Msg_type Msg_text
1829
test.t1 check status OK
1790
CREATE temporary TABLE t1 (
1794
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
1795
SELECT COUNT(*) FROM t1;
1799
Table Op Msg_type Msg_text
1800
test.t1 check status OK
1801
SELECT COUNT(*) FROM t1;
1805
Table Op Msg_type Msg_text
1806
test.t1 check status OK
1808
CREATE temporary TABLE t1 (
1812
INSERT INTO t1 VALUES(REPEAT( x'e0ae85',43), 'b');
1813
SELECT COUNT(*) FROM t1;
1816
CHECK TABLE t1 EXTENDED;
1817
Table Op Msg_type Msg_text
1818
test.t1 check status OK
1819
SELECT COUNT(*) FROM t1;
1822
CHECK TABLE t1 EXTENDED;
1823
Table Op Msg_type Msg_text
1824
test.t1 check status OK
1826
CREATE temporary TABLE t1 (
1834
1829
) ENGINE=MyISAM;