CREATE TABLE t3 (c int) ENGINE = MYISAM;
--echo don't need to keep track of insert statements
--disable_query_log
let $input= 4000;
while ($input)
{
 eval INSERT INTO t3 VALUES($input);
dec $input;
}
--enable_query_log
CREATE TABLE t4 (c int) ENGINE = MYISAM;
--echo don't need to keep track of insert statements
--disable_query_log
let $input= 4000;
while ($input)
{
 eval INSERT INTO t4 VALUES($input*2);
dec $input;
}
--enable_query_log

--echo merge t3, t4 = success
# Merge into new table t6
--exec $MYISAMPACK --join=$MYSQLTEST_VARDIR/master-data/test/t6 $MYSQLTEST_VARDIR/master-data/test/t3 $MYSQLTEST_VARDIR/master-data/test/t4
--exec ls $MYSQLTEST_VARDIR/master-data/test/t6*
--echo No .FRM file

--echo Try to SELECT from t6 = no table t6
SELECT * FROM t6 WHERE c < 10;
#Verify t6 is read-only
#INSERT INTO t6 VALUES(8001);
#Verify source tables are not packed / read-only
SELECT MAX(c), MIN(c) FROM t4;
INSERT INTO t4 VALUES(8001);