1
1
################################################################################
2
# inc/partition_layout_check1.inc #
2
# inc/partition_layout_check1.inc #
5
5
# Store the SHOW CREATE TABLE output and the list of files belonging to #
6
6
# this table + print this into the protocol #
7
7
# This script is only usefule when sourced within the partitioning tests. #
9
# Attention: The routine inc/partition_layout_check2.inc is very similar #
9
# Attention: The routine inc/partition_layout_check2.inc is very similar #
10
10
# to this one. So if something has to be changed here it #
11
11
# might be necessary to do it also there #
25
25
# Clean the table holding the definition of t1
26
26
DELETE FROM t0_definition;
28
# Get the MySQL Servers datadir without ending slash
29
let $MYSQLD_DATADIR= `select LEFT(@@datadir, LENGTH(@@datadir)-1)`;
30
#echo MYSQLD_DATADIR: $MYSQLD_DATADIR;
28
32
# Dump the current definition of the table t1 to tmp1
29
33
# This complicated method - let another mysqltest collect the output - is used
30
34
# because of two reasons
31
35
# - SHOW CREATE TABLE t1 is at least currently most probably more reliable than
32
36
# the corresponding SELECT on the INFORMATION_SCHEMA
33
37
# - SHOW CREATE TABLE .. cannot write its out put into a file like SELECT
34
let $show_file= $MYSQLTEST_VARDIR/master-data/test/tmp1;
35
--exec echo "SHOW CREATE TABLE t1;" | $MYSQL_TEST > $show_file 2>&1 || true
38
let $show_file= $MYSQLD_DATADIR/test/tmp1;
39
--exec echo "SHOW CREATE TABLE t1; exit; " | $MYSQL_TEST > $show_file 2>&1
37
40
if ($do_file_tests)
39
# List the files belonging to the table t1
40
let $ls_file= $MYSQLTEST_VARDIR/master-data/test/tmp2;
41
--list_files_write_file $ls_file $MYSQLTEST_VARDIR/master-data/test t1*
43
if ($with_directories)
45
--list_files_append_file $ls_file $MYSQLTEST_VARDIR/mysql-test-data-dir t1*
46
--list_files_append_file $ls_file $MYSQLTEST_VARDIR/mysql-test-idx-dir t1*
48
eval SET @aux = load_file('$ls_file');
42
# List the files belonging to the table t1
43
let $ls_file= $MYSQLD_DATADIR/test/tmp2;
44
--list_files_write_file $ls_file $MYSQLD_DATADIR/test t1*
46
if ($with_directories)
48
--list_files_append_file $ls_file $MYSQLTEST_VARDIR/mysql-test-data-dir t1*
49
--list_files_append_file $ls_file $MYSQLTEST_VARDIR/mysql-test-idx-dir t1*
51
eval SET @aux = load_file('$ls_file');
50
53
if (!$do_file_tests)
52
SET @aux = '--- not determined ---';
55
SET @aux = '--- not determined ---';
55
58
# Insert the current definition of the table t1 into t0_definition
68
71
# Print the list of files into the protocol
69
eval SELECT REPLACE(@aux,'$MYSQLTEST_VARDIR','\$MYSQLTEST_VARDIR')
71
FROM t0_definition WHERE state = 'old';
72
replace_result $MYSQLD_DATADIR MYSQLD_DATADIR $MYSQLTEST_VARDIR MYSQLTEST_VARDIR;
73
SELECT file_list AS "unified filelist"
74
FROM t0_definition WHERE state = 'old';