EVOLUTION-MANAGER

Edit File: fmt.result

# # Testing errors # CREATE TABLE t1 ( ID INT NOT NULL field_format=' %n%d%n' ) Engine=CONNECT table_type=FMT 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 update on FMT tables # CREATE TABLE t1 ( id INT NOT NULL field_format=' %n%d%n' ) ENGINE=CONNECT TABLE_TYPE=FMT FILE_NAME='t1.txt'; INSERT INTO t1 VALUES (10),(20); ERROR HY000: Got error 174 'Writing FMT files is not implemented yet' from CONNECT DROP TABLE t1; # # Testing manual examples # CREATE TABLE t1 ( ID Integer(5) not null field_format=' %n%d%n', NAME Char(16) not null field_format=" , '%n%[^']%n'", DEPNO Integer(4) not null field_format=' , #%n%d%n', SALARY Double(12,2) not null field_format=' ; %n%f%n' ) Engine=CONNECT table_type=FMT file_name='funny.txt'; SELECT * FROM t1; ID NAME DEPNO SALARY 12345 BERTRAND 200 5009.13 56 POIROT-DELMOTTE 4256 18009.00 345 TRUCMUCHE 67 19000.25 DROP TABLE t1; CREATE TABLE t1 ( ID Integer(5) not null field_format=' %n%d%n', NAME Char(16) not null field_format=" , '%n%[^']%n'", DEPNO Integer(4) not null field_format=' , #%n%d%n', SALARY Double(12,2) not null field_format=' ; %n%f%n' ) Engine=CONNECT table_type=FMT file_name='funny2.txt'; SELECT * FROM t1; ERROR HY000: Got error 122 'Bad format line 2 field 3 of t1' from CONNECT DROP TABLE t1; CREATE TABLE t1 ( ID Integer(5) not null field_format=' %n%d%n', NAME Char(16) not null field_format=' , ''%n%[^'']%m', DEPNO Integer(4) not null field_format=''' , #%n%d%m', SALARY Double(12,2) not null field_format=' ; %n%f%n' ) Engine=CONNECT table_type=FMT file_name='funny2.txt'; SELECT * FROM t1; ID NAME DEPNO SALARY 12345 BERTRAND 200 5009.13 56 POIROT-DELMOTTE 0 18009.00 345 67 19000.25 UPDATE t1 SET SALARY=1234; ERROR HY000: Got error 174 'Writing FMT files is not implemented yet' from CONNECT DELETE FROM t1 WHERE ID=56; SELECT * FROM t1; ID NAME DEPNO SALARY 12345 BERTRAND 200 5009.13 345 67 19000.25 DROP TABLE t1;