INSTALL SONAME 'ha_connect';

let $MYSQLD_DATADIR= `select @@datadir`;

--write_file $MYSQLD_DATADIR/test/num1.csv

1

2

EOF

CREATE TABLE t (a int NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='num?.csv' MULTIPLE=1;

SELECT * FROM t;

ALTER TABLE t FORCE;

SELECT * FROM t;

ALTER TABLE t FORCE, ALGORITHM=COPY;

SELECT * FROM t;

--echo # File contents

--cat_file $MYSQLD_DATADIR/test/num1.csv

# Cleanup

DROP TABLE t;

UNINSTALL SONAME 'ha_connect';

ALTER TABLE t FORCE;

Warnings:

Warning	1105	This is an outward table, table data were not modified.

SELECT * FROM t;

a

1

2

ALTER TABLE t FORCE, ALGORITHM=COPY;

SELECT * FROM t;

a

1

2

1

2

# File contents

1

2

1

2