1--source ../include/direct_sql_with_tmp_table_init.inc
2--echo
3--echo drop and create databases
4
5--connection master_1
6--disable_warnings
7CREATE DATABASE auto_test_local;
8USE auto_test_local;
9--enable_warnings
10
11--disable_query_log
12echo CREATE TEMPORARY TABLE tmp_a (
13    pkey int NOT NULL,
14    PRIMARY KEY (pkey)
15) MASTER_1_ENGINE2;
16eval CREATE TEMPORARY TABLE tmp_a (
17    pkey int NOT NULL,
18    PRIMARY KEY (pkey)
19) $MASTER_1_ENGINE2;
20--enable_query_log
21
22eval $DIRECT_SQL_COMMAND;
23SELECT pkey FROM tmp_a;
24
25--echo
26--echo deinit
27--disable_warnings
28
29--connection master_1
30DROP DATABASE IF EXISTS auto_test_local;
31
32--enable_warnings
33--source ../include/direct_sql_with_tmp_table_deinit.inc
34--echo
35--echo end of test
36