Debian Codegraph @

mysql-test/suite/handler/init.inc

raw
1 # Setup things for handler.inc
2 #
3 # Input variables
4 # $engine_type -- storage engine to be tested
5 # using btree -- set if you want a non standard key type
6 #
7 # This scripts sets up default values for:
8 # $other_handler_engine_type -- storage engine <> $engine_type, if possible
9 # 1. $other_handler_engine_type must support handler
10 # 2. $other_handler_engine_type must point to an all
11 # time available storage engine
12 # have to be set before sourcing this script.
13 #
14 # Handler tests don't work with embedded server
15 #
16 -- source include/not_embedded.inc
17
18 eval SET SESSION DEFAULT_STORAGE_ENGINE = $engine_type;
19 let $other_handler_engine_type= MyISAM;
20
21 --disable_warnings
22 drop table if exists t1,t3,t4,t5;
23 --enable_warnings
24
25 # Create default test table
26
27 create table t1 (a int, b char(10), key a using btree (a), key b using btree (a,b));
28 insert into t1 values
29 (17,"ddd"),(18,"eee"),(19,"fff"),(19,"yyy"),
30 (14,"aaa"),(16,"ccc"),(16,"xxx"),
31 (20,"ggg"),(21,"hhh"),(22,"iii"),(23,"xxx"),(24,"xxx"),(25,"xxx");