2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 INTEGER NOT NULL);
5
CREATE INDEX i1 USING BTREE ON t1(c1 ASC);
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
10
DROP TABLE t1; SHOW TABLES;
11
CREATE TABLE t1(c1 INTEGER NOT NULL);
12
CREATE INDEX i1 USING BTREE ON t1(c1 DESC);
13
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
14
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
16
DROP TABLE t1; SHOW TABLES;
17
CREATE TABLE t1(c1 INTEGER NOT NULL);
18
CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 ASC);
19
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
20
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
24
DROP TABLE t1; SHOW TABLES;
25
CREATE TABLE t1(c1 INTEGER NOT NULL);
26
CREATE UNIQUE INDEX i1 USING BTREE ON t1(c1 DESC);
27
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
28
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
32
DROP TABLE t1; SHOW TABLES;
33
CREATE TABLE t1(c1 INTEGER NOT NULL);
34
CREATE INDEX i1 USING HASH ON t1(c1 ASC);
35
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
36
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39
DROP TABLE t1; SHOW TABLES;
40
CREATE TABLE t1(c1 INTEGER NOT NULL);
41
CREATE INDEX i1 USING HASH ON t1(c1 DESC);
42
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
43
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
46
DROP TABLE t1; SHOW TABLES;
47
CREATE TABLE t1(c1 INTEGER NOT NULL);
48
CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 ASC);
49
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
50
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
54
DROP TABLE t1; SHOW TABLES;
55
CREATE TABLE t1(c1 INTEGER NOT NULL);
56
CREATE UNIQUE INDEX i1 USING HASH ON t1(c1 DESC);
57
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
58
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62
DROP TABLE t1; SHOW TABLES;