# # 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;