Debian Codegraph @

mysql-test/suite/galera/t/galera_cache_index.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE t1 (c1 int, UNIQUE INDEX (c1)) engine=innodb;
5 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
6 CREATE TABLE t2 (c1 int);
7 INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
8 CREATE TEMPORARY TABLE t1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) INSERT_METHOD=LAST;
9 CACHE INDEX t1,t2 IN default;
10 LOAD INDEX INTO CACHE t1,t2;
11 DROP TEMPORARY TABLE t1;
12 DROP TABLE t1,t2;
13
14 CREATE TABLE t1 (c1 int, UNIQUE INDEX (c1)) engine=MyISAM;
15 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
16 CREATE TABLE t2 (c1 int, UNIQUE INDEX (c1)) engine=MyISAM;
17 INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
18 CREATE TEMPORARY TABLE t1 (c1 INT) ENGINE=MRG_MyISAM UNION=(t1,t2) INSERT_METHOD=LAST;
19 CACHE INDEX t1,t2 IN default;
20 LOAD INDEX INTO CACHE t1,t2;
21 DROP TEMPORARY TABLE t1;
22 DROP TABLE t1,t2;
23
24 CREATE TABLE t1 (c1 int, UNIQUE INDEX (c1)) engine=MyISAM;
25 INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
26 CREATE TABLE t2 (c1 int, UNIQUE INDEX (c1)) engine=MyISAM;
27 INSERT INTO t2 VALUES (1),(2),(3),(4),(5);
28 CACHE INDEX t1,t2 IN default;
29 LOAD INDEX INTO CACHE t1,t2;
30 DROP TABLE t1,t2;