#
# Testing errors
#
CREATE TABLE t1
(
ID INT
) Engine=CONNECT TABLE_TYPE=DOS FILE_NAME='nonexistent.txt';
SELECT * FROM t1;
ID
Warnings:
Warning	1105	Open(rb) error 2 on DATADIR/test/nonexistent.txt: No such file or directory
DROP TABLE t1;
#
# Testing manual examples
#
CREATE TABLE t1
(
number   CHAR(4) not null,
location CHAR(15) flag=5,
director CHAR(5) flag=20,
function CHAR(12) flag=26,
name     CHAR(22) flag=38
) ENGINE=CONNECT TABLE_TYPE=DOS FILE_NAME='dept.dat';
SELECT * FROM t1;
number	location	director	function	name
0318	KINGSTON	70012	SALES	Bank/Insurance
0021	ARMONK	87777	CHQ	Corporate headquarter
0319	HARRISON	40567	SALES	Federal Administration
2452	POUGHKEEPSIE	31416	DEVELOPMENT	Research & development
DROP TABLE t1;
CREATE TABLE t1
(
name char(12),
city char(12),
birth date date_format='DD/MM/YYYY',
hired date date_format='DD/MM/YYYY' flag=36
) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boys.txt' ENDING=1;
SELECT * FROM t1;
name	city	birth	hired
John	Boston     2	1986-01-05	2010-06-02
Henry	Boston     0	1987-06-07	2008-04-01
George	San Jose   1	1981-07-31	2010-06-02
Sam	Chicago    2	1979-11-02	2007-10-10
James	Dallas     1	1992-05-03	2009-12-14
Bill	Boston     1	1986-09-01	2008-02-10
DROP TABLE t1;
CREATE TABLE t1
(
name char(12),
city char(12),
birth date date_format='DD/MM/YYYY',
hired date date_format='DD/MM/YYYY' flag=36
) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boys.txt' LRECL=47 ENDING=1;
SELECT * FROM t1;
name	city	birth	hired
John	Boston     2	1986-01-05	2010-06-02
Henry	Boston     0	1987-06-07	2008-04-01
George	San Jose   1	1981-07-31	2010-06-02
Sam	Chicago    2	1979-11-02	2007-10-10
James	Dallas     1	1992-05-03	2009-12-14
Bill	Boston     1	1986-09-01	2008-02-10
DROP TABLE t1;
CREATE TABLE t1
(
name char(12),
city char(12),
birth date date_format='DD/MM/YYYY',
hired date date_format='DD/MM/YYYY' flag=36
) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boyswin.txt' ENDING=2;
SELECT * FROM t1;
name	city	birth	hired
John	Boston     2	1986-01-05	2010-06-02
Henry	Boston     0	1987-06-07	2008-04-01
George	San Jose   1	1981-07-31	2010-06-02
Sam	Chicago    2	1979-11-02	2007-10-10
James	Dallas     1	1992-05-03	2009-12-14
Bill	Boston     1	1986-09-01	2008-02-10
DROP TABLE t1;
CREATE TABLE t1
(
name char(12),
city char(12),
birth date date_format='DD/MM/YYYY',
hired date date_format='DD/MM/YYYY' flag=36
) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boyswin.txt' LRECL=47 ENDING=2;
SELECT * FROM t1;
name	city	birth	hired
John	Boston     2	1986-01-05	2010-06-02
Henry	Boston     0	1987-06-07	2008-04-01
George	San Jose   1	1981-07-31	2010-06-02
Sam	Chicago    2	1979-11-02	2007-10-10
James	Dallas     1	1992-05-03	2009-12-14
Bill	Boston     1	1986-09-01	2008-02-10
DROP TABLE t1;