################################################################################
# include/partition_layout_check2.inc                                          #
#                                                                              #
# Purpose:                                                                     #
#   Store the SHOW CREATE TABLE output and the list of files belonging to      #
#   this table + Check if the layout of the table was not modified             #
#   since the call of include/partition_layout_check1.inc                      #
#   This script is only usefule when sourced within the partitioning tests.    #
#                                                                              #
# Attention: The routine include/partition_layout_check1.inc is very similar   #
#            to this one. So if something has to be changed here it            #
#            might be necessary to do it also there                            #
#                                                                              #
#------------------------------------------------------------------------------#
# Original Author: ML                                                          #
# Original Date: 2006-03-05                                                    #
# Change Author:                                                               #
# Change Date:                                                                 #
# Change:                                                                      #
################################################################################

if ($no_debug)
{
--disable_query_log
}
# Clean the table holding the definition of t1
DELETE FROM t0_definition WHERE state = 'new';

# Dump the current definition of the table t1 to tmp1
--exec echo "SHOW CREATE TABLE t1;" | $MYSQL_TEST > $MYSQLTEST_VARDIR/master-data/test/tmp1 2>&1 || true
if ($do_file_tests)
{
# List the files belonging to the table t1
--exec ls $MYSQLTEST_VARDIR/master-data/test/t1* > $MYSQLTEST_VARDIR/master-data/test/tmp2 2>&1 || true
eval SET @aux = CONCAT('load_file(''$MYSQLTEST_VARDIR','/master-data/test/tmp2'')');
let $file_list= `SELECT @aux`;
}
if (!$do_file_tests)
{
let $file_list= '--- not determined ---';
}

# Insert the current definition of the table t1 into t0_definition
eval INSERT INTO t0_definition SET state = 'new',
     create_command = load_file('$MYSQLTEST_VARDIR/master-data/test/tmp1'),
     file_list      = $file_list;

# Print the old and new table layout, if they differ
SELECT COUNT(*) <> 1 INTO @aux
FROM t0_definition tab1, t0_definition tab2
WHERE tab1.state = 'old' AND tab2.state = 'new'
  AND tab1.create_command = tab2.create_command
  AND tab1.file_list = tab2.file_list;
let $run= `SELECT @aux`;
if ($run)
{
   --vertical_results
   SELECT state,
   REPLACE(create_command,'\n',' ') AS "Table definition",
   REPLACE(file_list     ,'\n',' ') AS "File list"
   FROM t0_definition WHERE state in ('old','new');
   --horizontal_results
   --echo # check layout success:    0
}
let $run= `SELECT @aux = 0`;
if ($run)
{
   --echo # check layout success:    1
}
--enable_query_log
