11
11
#------------------------------------------------------------------------------#
12
12
# Original Author: mleich #
13
13
# Original Date: 2006-05-12 #
17
14
################################################################################
24
21
if ($do_file_tests)
23
let $ls_file= $MYSQLTEST_VARDIR/master-data/test/tmp2;
26
24
# List the files belonging to the table t1
27
--exec ls $MYSQLTEST_VARDIR/master-data/test/t1* > $MYSQLTEST_VARDIR/master-data/test/tmp2 || true
25
--list_files_write_file $ls_file $MYSQLTEST_VARDIR/master-data/test t1*
28
27
if ($with_directories)
30
--exec ls $MYSQLTEST_VARDIR/tmp/t1* >> $MYSQLTEST_VARDIR/master-data/test/tmp2 || true
29
--list_files_append_file $ls_file $MYSQLTEST_VARDIR/tmp t1*
32
eval SET @aux = CONCAT('load_file(''$MYSQLTEST_VARDIR','/master-data/test/tmp2'')');
33
let $file_list= `SELECT @aux`;
31
eval SET @aux = load_file('$ls_file');
35
33
if (!$do_file_tests)
37
let $file_list= '--- not determined ---';
35
SET @aux = '--- not determined ---';
40
38
# UPDATE the current filelist of the table t1 within t0_definition
41
39
# Note: This list should be empty, because the table t1 was dropped !
42
eval INSERT INTO t0_definition SET state = 'old', file_list = $file_list
43
ON DUPLICATE KEY UPDATE file_list = $file_list;
44
# eval UPDATE t0_definition SET file_list = $file_list WHERE state = 'old';
40
eval INSERT INTO t0_definition SET state = 'old', file_list = @aux
41
ON DUPLICATE KEY UPDATE file_list = @aux;
42
# eval UPDATE t0_definition SET file_list = @aux WHERE state = 'old';
46
44
# Check if filelist is empty.
47
45
let $found_garbage= `SELECT file_list <> '' FROM t0_definition WHERE state = 'old'`;