| 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"); |