1let $MYSQLD_DATADIR= `select @@datadir`; 2--copy_file $MTR_SUITE_DIR/std_data/employee.dat $MYSQLD_DATADIR/test/employee.dat 3 4SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 5 6CREATE TABLE employee 7( 8serialno CHAR(5) NOT NULL, 9name VARCHAR(12) NOT NULL FLAG=6, 10sex TINYINT(1) NOT NULL, 11title VARCHAR(15) NOT NULL FLAG=20, 12manager CHAR(5) NOT NULL, 13department CHAR(4) NOT NULL FLAG=41, 14secretary CHAR(5) NOT NULL FLAG=46, 15salary DOUBLE(8,2) NOT NULL FLAG=52 16) ENGINE=connect TABLE_TYPE=fix FILE_NAME='employee.dat' ENDING=1; 17SELECT * FROM employee; 18 19DELIMITER //; 20CREATE PROCEDURE test.tst_up() DETERMINISTIC 21BEGIN 22SELECT * FROM t1; 23UPDATE t1 SET salary = salary + 1, title = 'RESEARCH' WHERE title = 'SCIENTIST'; 24UPDATE t1 SET salary = salary + 1, title = 'TECHNICIAN' WHERE title = 'ENGINEER'; 25UPDATE t1 SET title = 'PUPPET' WHERE name = 'TONGHO'; 26UPDATE t1 SET salary = 0. WHERE title = 'XXX'; 27SELECT * FROM t1; 28DELETE FROM t1 WHERE title = 'SECRETARY'; 29DELETE FROM t1 WHERE title = 'DIRECTOR'; 30DELETE FROM t1 WHERE title = 'TYPIST'; 31SELECT * FROM t1; 32DELETE FROM t1 LIMIT 3; 33INSERT INTO t1(serialno, name, title, salary) VALUES('66666','NEWMAN','ENGINEER',10000.80); 34SELECT * FROM t1; 35DROP TABLE t1; 36END// 37DELIMITER ;// 38 39--echo # 40--echo # Testing DOS table changes 41--echo # 42CREATE TABLE t1 ENGINE=connect AS SELECT * FROM employee; 43CALL test.tst_up(); 44 45--echo # 46--echo # Testing DOS table changes 47--echo # 48CREATE TABLE t1 ENGINE=connect mapped=yes AS SELECT * FROM employee; 49CALL test.tst_up(); 50 51--echo # 52--echo # Testing FIX table changes 53--echo # 54CREATE TABLE t1 ENGINE=connect TABLE_TYPE=fix AS SELECT * FROM employee; 55CALL test.tst_up(); 56 57--echo # 58--echo # Testing FIX table changes 59--echo # 60CREATE TABLE t1 ENGINE=connect TABLE_TYPE=fix mapped=yes AS SELECT * FROM employee; 61CALL test.tst_up(); 62 63--echo # 64--echo # Testing FIX table changes 65--echo # 66CREATE TABLE t1 ENGINE=connect TABLE_TYPE=fix huge=yes AS SELECT * FROM employee; 67CALL test.tst_up(); 68 69--echo # 70--echo # Testing CSV table changes 71--echo # 72CREATE TABLE t1 ENGINE=connect TABLE_TYPE=csv AS SELECT * FROM employee; 73CALL test.tst_up(); 74 75--echo # 76--echo # Testing CSV table changes 77--echo # 78CREATE TABLE t1 ENGINE=connect TABLE_TYPE=csv mapped=yes AS SELECT * FROM employee; 79CALL test.tst_up(); 80 81--echo # 82--echo # Testing DBF table changes 83--echo # 84CREATE TABLE t1 ENGINE=connect TABLE_TYPE=dbf AS SELECT * FROM employee; 85CALL test.tst_up(); 86 87--echo # 88--echo # Testing DBF table changes 89--echo # 90CREATE TABLE t1 ENGINE=connect TABLE_TYPE=dbf mapped=yes AS SELECT * FROM employee; 91CALL test.tst_up(); 92 93--echo # 94--echo # Testing BIN table changes 95--echo # 96CREATE TABLE t1 ENGINE=connect TABLE_TYPE=bin AS SELECT * FROM employee; 97CALL test.tst_up(); 98 99--echo # 100--echo # Testing BIN table changes 101--echo # 102CREATE TABLE t1 ENGINE=connect TABLE_TYPE=bin mapped=yes AS SELECT * FROM employee; 103CALL test.tst_up(); 104 105--echo # 106--echo # Testing BIN table changes 107--echo # 108CREATE TABLE t1 ENGINE=connect TABLE_TYPE=bin huge=yes AS SELECT * FROM employee; 109CALL test.tst_up(); 110 111--echo # 112--echo # Testing VEC table changes 113--echo # 114CREATE TABLE t1 ENGINE=connect TABLE_TYPE=vec MAX_ROWS=30 AS SELECT * FROM employee; 115CALL test.tst_up(); 116 117--echo # 118--echo # Testing VEC table changes 119--echo # 120CREATE TABLE t1 ENGINE=connect TABLE_TYPE=vec mapped=yes MAX_ROWS=30 AS SELECT * FROM employee; 121CALL test.tst_up(); 122 123--echo # 124--echo # Testing VEC table changes 125--echo # 126CREATE TABLE t1 ENGINE=connect TABLE_TYPE=vec huge=yes MAX_ROWS=30 AS SELECT * FROM employee; 127CALL test.tst_up(); 128 129--echo # 130--echo # Testing INI table changes 131--echo # 132CREATE TABLE t1 133( 134serialno CHAR(5) NOT NULL FLAG=1, 135name VARCHAR(12) NOT NULL, 136sex TINYINT(1), 137title VARCHAR(15) NOT NULL, 138manager CHAR(5), 139department CHAR(4), 140secretary CHAR(5), 141salary DOUBLE(8,2) NOT NULL 142) ENGINE=connect TABLE_TYPE=ini; 143INSERT INTO t1 SELECT * FROM employee; 144CALL test.tst_up(); 145 146--echo # 147--echo # Testing XML table changes (must be in a separate test) 148--echo # 149#CREATE TABLE t1 ENGINE=connect TABLE_TYPE=xml option_list='rownode=dd' AS SELECT * FROM employee; 150#CALL test.tst_up(); 151 152DROP PROCEDURE test.tst_up; 153DROP TABLE employee; 154 155SET sql_mode = DEFAULT; 156 157--remove_file $MYSQLD_DATADIR/test/employee.dat 158