1SET sql_mode = 'NO_ENGINE_SUBSTITUTION'; 2CREATE TABLE employee 3( 4serialno CHAR(5) NOT NULL, 5name VARCHAR(12) NOT NULL FLAG=6, 6sex TINYINT(1) NOT NULL, 7title VARCHAR(15) NOT NULL FLAG=20, 8manager CHAR(5) NOT NULL, 9department CHAR(4) NOT NULL FLAG=41, 10secretary CHAR(5) NOT NULL FLAG=46, 11salary DOUBLE(8,2) NOT NULL FLAG=52 12) ENGINE=connect TABLE_TYPE=fix FILE_NAME='employee.dat' ENDING=1; 13SELECT * FROM employee; 14serialno name sex title manager department secretary salary 1574200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 1602345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 1778943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 1807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 1945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 2034567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 2177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 2274234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 2356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 2473452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 2522222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 2655555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 2727845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 2898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 2911111 CHERRY 2 SECRETARY 31416 2452 4500.00 3033333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 3112345 KITTY 2 TYPIST 40567 0319 3000.45 3224888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 3387777 STRONG 1 DIRECTOR 0021 22222 23000.00 3476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 3570012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 3640567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 3731416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 3836666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 3900137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 4073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 4100023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 42CREATE PROCEDURE test.tst_up() DETERMINISTIC 43BEGIN 44SELECT * FROM t1; 45UPDATE t1 SET salary = salary + 1, title = 'RESEARCH' WHERE title = 'SCIENTIST'; 46UPDATE t1 SET salary = salary + 1, title = 'TECHNICIAN' WHERE title = 'ENGINEER'; 47UPDATE t1 SET title = 'PUPPET' WHERE name = 'TONGHO'; 48UPDATE t1 SET salary = 0. WHERE title = 'XXX'; 49SELECT * FROM t1; 50DELETE FROM t1 WHERE title = 'SECRETARY'; 51DELETE FROM t1 WHERE title = 'DIRECTOR'; 52DELETE FROM t1 WHERE title = 'TYPIST'; 53SELECT * FROM t1; 54DELETE FROM t1 LIMIT 3; 55INSERT INTO t1(serialno, name, title, salary) VALUES('66666','NEWMAN','ENGINEER',10000.80); 56SELECT * FROM t1; 57DROP TABLE t1; 58END// 59# 60# Testing DOS table changes 61# 62CREATE TABLE t1 ENGINE=connect AS SELECT * FROM employee; 63Warnings: 64Warning 1105 No table_type. Will be set to DOS 65Warning 1105 No file name. Table will use t1.dos 66CALL test.tst_up(); 67serialno name sex title manager department secretary salary 6874200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 6902345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 7078943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 7107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 7245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 7334567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 7477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 7574234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 7656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 7773452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 7822222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 7955555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 8027845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 8198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 8211111 CHERRY 2 SECRETARY 31416 2452 4500.00 8333333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 8412345 KITTY 2 TYPIST 40567 0319 3000.45 8524888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 8687777 STRONG 1 DIRECTOR 0021 22222 23000.00 8776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 8870012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 8940567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 9031416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 9136666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 9200137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 9373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 9400023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 95serialno name sex title manager department secretary salary 9674200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 9702345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 9878943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 9907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 10045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 10134567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 10277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 10374234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 10456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 10573452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 10622222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 10755555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 10827845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 10998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 11011111 CHERRY 2 SECRETARY 31416 2452 4500.00 11133333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 11212345 KITTY 2 TYPIST 40567 0319 3000.45 11324888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 11487777 STRONG 1 DIRECTOR 0021 22222 23000.00 11576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 11670012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 11740567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 11831416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 11936666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 12000137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 12173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 12200023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 123serialno name sex title manager department secretary salary 12474200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 12502345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 12678943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 12707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 12845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 12934567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 13077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 13174234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 13256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 13373452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 13498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 13576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 13631416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 13736666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 13800137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 13973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 14000023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 141serialno name sex title manager department secretary salary 14207654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 14345678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 14434567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 14577777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 14674234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 14756789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 14873452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 14998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 15076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 15131416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 15236666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 15300137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 15473111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 15500023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 15666666 NEWMAN 0 ENGINEER 10000.80 157# 158# Testing DOS table changes 159# 160CREATE TABLE t1 ENGINE=connect mapped=yes AS SELECT * FROM employee; 161Warnings: 162Warning 1105 No table_type. Will be set to DOS 163Warning 1105 No file name. Table will use t1.dos 164CALL test.tst_up(); 165serialno name sex title manager department secretary salary 16674200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 16702345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 16878943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 16907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 17045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 17134567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 17277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 17374234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 17456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 17573452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 17622222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 17755555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 17827845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 17998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 18011111 CHERRY 2 SECRETARY 31416 2452 4500.00 18133333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 18212345 KITTY 2 TYPIST 40567 0319 3000.45 18324888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 18487777 STRONG 1 DIRECTOR 0021 22222 23000.00 18576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 18670012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 18740567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 18831416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 18936666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 19000137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 19173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 19200023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 193serialno name sex title manager department secretary salary 19474200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 19502345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 19678943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 19707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 19845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 19934567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 20077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 20174234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 20256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 20373452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 20422222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 20555555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 20627845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 20798765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 20811111 CHERRY 2 SECRETARY 31416 2452 4500.00 20933333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 21012345 KITTY 2 TYPIST 40567 0319 3000.45 21124888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 21287777 STRONG 1 DIRECTOR 0021 22222 23000.00 21376543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 21470012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 21540567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 21631416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 21736666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 21800137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 21973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 22000023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 221serialno name sex title manager department secretary salary 22274200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 22302345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 22478943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 22507654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 22645678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 22734567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 22877777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 22974234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 23056789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 23173452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 23298765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 23376543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 23431416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 23536666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 23600137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 23773111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 23800023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 239serialno name sex title manager department secretary salary 24007654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 24145678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 24234567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 24377777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 24474234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 24556789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 24673452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 24798765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 24876543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 24931416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 25036666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 25100137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 25273111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 25300023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 25466666 NEWMAN 0 ENGINEER 10000.80 255# 256# Testing FIX table changes 257# 258CREATE TABLE t1 ENGINE=connect TABLE_TYPE=fix AS SELECT * FROM employee; 259Warnings: 260Warning 1105 No file name. Table will use t1.fix 261CALL test.tst_up(); 262serialno name sex title manager department secretary salary 26374200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 26402345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 26578943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 26607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 26745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 26834567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 26977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 27074234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 27156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 27273452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 27322222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 27455555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 27527845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 27698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 27711111 CHERRY 2 SECRETARY 31416 2452 4500.00 27833333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 27912345 KITTY 2 TYPIST 40567 0319 3000.45 28024888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 28187777 STRONG 1 DIRECTOR 0021 22222 23000.00 28276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 28370012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 28440567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 28531416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 28636666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 28700137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 28873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 28900023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 290serialno name sex title manager department secretary salary 29174200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 29202345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 29378943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 29407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 29545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 29634567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 29777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 29874234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 29956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 30073452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 30122222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 30255555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 30327845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 30498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 30511111 CHERRY 2 SECRETARY 31416 2452 4500.00 30633333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 30712345 KITTY 2 TYPIST 40567 0319 3000.45 30824888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 30987777 STRONG 1 DIRECTOR 0021 22222 23000.00 31076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 31170012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 31240567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 31331416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 31436666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 31500137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 31673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 31700023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 318serialno name sex title manager department secretary salary 31974200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 32002345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 32178943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 32207654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 32345678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 32434567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 32577777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 32674234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 32756789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 32873452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 32998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 33076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 33131416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 33236666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 33300137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 33473111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 33500023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 336serialno name sex title manager department secretary salary 33707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 33845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 33934567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 34077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 34174234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 34256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 34373452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 34498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 34576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 34631416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 34736666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 34800137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 34973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 35000023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 35166666 NEWMAN 0 ENGINEER 10000.80 352# 353# Testing FIX table changes 354# 355CREATE TABLE t1 ENGINE=connect TABLE_TYPE=fix mapped=yes AS SELECT * FROM employee; 356Warnings: 357Warning 1105 No file name. Table will use t1.fix 358CALL test.tst_up(); 359serialno name sex title manager department secretary salary 36074200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 36102345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 36278943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 36307654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 36445678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 36534567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 36677777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 36774234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 36856789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 36973452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 37022222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 37155555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 37227845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 37398765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 37411111 CHERRY 2 SECRETARY 31416 2452 4500.00 37533333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 37612345 KITTY 2 TYPIST 40567 0319 3000.45 37724888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 37887777 STRONG 1 DIRECTOR 0021 22222 23000.00 37976543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 38070012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 38140567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 38231416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 38336666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 38400137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 38573111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 38600023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 387serialno name sex title manager department secretary salary 38874200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 38902345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 39078943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 39107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 39245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 39334567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 39477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 39574234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 39656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 39773452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 39822222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 39955555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 40027845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 40198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 40211111 CHERRY 2 SECRETARY 31416 2452 4500.00 40333333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 40412345 KITTY 2 TYPIST 40567 0319 3000.45 40524888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 40687777 STRONG 1 DIRECTOR 0021 22222 23000.00 40776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 40870012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 40940567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 41031416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 41136666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 41200137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 41373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 41400023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 415serialno name sex title manager department secretary salary 41674200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 41702345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 41878943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 41907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 42045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 42134567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 42277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 42374234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 42456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 42573452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 42698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 42776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 42831416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 42936666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 43000137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 43173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 43200023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 433serialno name sex title manager department secretary salary 43407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 43545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 43634567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 43777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 43874234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 43956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 44073452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 44198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 44276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 44331416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 44436666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 44500137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 44673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 44700023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 44866666 NEWMAN 0 ENGINEER 10000.80 449# 450# Testing FIX table changes 451# 452CREATE TABLE t1 ENGINE=connect TABLE_TYPE=fix huge=yes AS SELECT * FROM employee; 453Warnings: 454Warning 1105 No file name. Table will use t1.fix 455CALL test.tst_up(); 456serialno name sex title manager department secretary salary 45774200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 45802345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 45978943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 46007654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 46145678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 46234567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 46377777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 46474234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 46556789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 46673452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 46722222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 46855555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 46927845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 47098765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 47111111 CHERRY 2 SECRETARY 31416 2452 4500.00 47233333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 47312345 KITTY 2 TYPIST 40567 0319 3000.45 47424888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 47587777 STRONG 1 DIRECTOR 0021 22222 23000.00 47676543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 47770012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 47840567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 47931416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 48036666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 48100137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 48273111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 48300023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 484serialno name sex title manager department secretary salary 48574200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 48602345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 48778943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 48807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 48945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 49034567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 49177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 49274234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 49356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 49473452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 49522222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 49655555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 49727845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 49898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 49911111 CHERRY 2 SECRETARY 31416 2452 4500.00 50033333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 50112345 KITTY 2 TYPIST 40567 0319 3000.45 50224888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 50387777 STRONG 1 DIRECTOR 0021 22222 23000.00 50476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 50570012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 50640567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 50731416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 50836666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 50900137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 51073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 51100023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 512serialno name sex title manager department secretary salary 51374200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 51402345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 51578943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 51607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 51745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 51834567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 51977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 52074234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 52156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 52273452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 52398765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 52476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 52531416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 52636666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 52700137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 52873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 52900023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 530serialno name sex title manager department secretary salary 53107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 53245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 53334567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 53477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 53574234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 53656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 53773452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 53898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 53976543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 54031416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 54136666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 54200137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 54373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 54400023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 54566666 NEWMAN 0 ENGINEER 10000.80 546# 547# Testing CSV table changes 548# 549CREATE TABLE t1 ENGINE=connect TABLE_TYPE=csv AS SELECT * FROM employee; 550Warnings: 551Warning 1105 No file name. Table will use t1.csv 552CALL test.tst_up(); 553serialno name sex title manager department secretary salary 55474200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 55502345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 55678943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 55707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 55845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 55934567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 56077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 56174234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 56256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 56373452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 56422222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 56555555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 56627845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 56798765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 56811111 CHERRY 2 SECRETARY 31416 2452 4500.00 56933333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 57012345 KITTY 2 TYPIST 40567 0319 3000.45 57124888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 57287777 STRONG 1 DIRECTOR 0021 22222 23000.00 57376543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 57470012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 57540567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 57631416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 57736666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 57800137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 57973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 58000023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 581serialno name sex title manager department secretary salary 58274200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 58302345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 58478943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 58507654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 58645678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 58734567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 58877777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 58974234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 59056789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 59173452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 59222222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 59355555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 59427845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 59598765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 59611111 CHERRY 2 SECRETARY 31416 2452 4500.00 59733333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 59812345 KITTY 2 TYPIST 40567 0319 3000.45 59924888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 60087777 STRONG 1 DIRECTOR 0021 22222 23000.00 60176543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 60270012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 60340567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 60431416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 60536666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 60600137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 60773111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 60800023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 609serialno name sex title manager department secretary salary 61074200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 61102345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 61278943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 61307654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 61445678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 61534567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 61677777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 61774234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 61856789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 61973452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 62098765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 62176543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 62231416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 62336666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 62400137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 62573111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 62600023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 627serialno name sex title manager department secretary salary 62807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 62945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 63034567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 63177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 63274234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 63356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 63473452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 63598765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 63676543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 63731416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 63836666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 63900137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 64073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 64100023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 64266666 NEWMAN 0 ENGINEER 10000.80 643# 644# Testing CSV table changes 645# 646CREATE TABLE t1 ENGINE=connect TABLE_TYPE=csv mapped=yes AS SELECT * FROM employee; 647Warnings: 648Warning 1105 No file name. Table will use t1.csv 649CALL test.tst_up(); 650serialno name sex title manager department secretary salary 65174200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 65202345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 65378943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 65407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 65545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 65634567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 65777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 65874234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 65956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 66073452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 66122222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 66255555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 66327845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 66498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 66511111 CHERRY 2 SECRETARY 31416 2452 4500.00 66633333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 66712345 KITTY 2 TYPIST 40567 0319 3000.45 66824888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 66987777 STRONG 1 DIRECTOR 0021 22222 23000.00 67076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 67170012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 67240567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 67331416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 67436666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 67500137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 67673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 67700023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 678serialno name sex title manager department secretary salary 67974200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 68002345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 68178943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 68207654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 68345678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 68434567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 68577777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 68674234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 68756789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 68873452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 68922222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 69055555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 69127845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 69298765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 69311111 CHERRY 2 SECRETARY 31416 2452 4500.00 69433333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 69512345 KITTY 2 TYPIST 40567 0319 3000.45 69624888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 69787777 STRONG 1 DIRECTOR 0021 22222 23000.00 69876543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 69970012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 70040567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 70131416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 70236666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 70300137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 70473111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 70500023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 706serialno name sex title manager department secretary salary 70774200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 70802345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 70978943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 71007654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 71145678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 71234567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 71377777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 71474234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 71556789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 71673452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 71798765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 71876543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 71931416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 72036666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 72100137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 72273111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 72300023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 724serialno name sex title manager department secretary salary 72507654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 72645678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 72734567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 72877777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 72974234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 73056789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 73173452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 73298765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 73376543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 73431416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 73536666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 73600137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 73773111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 73800023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 73966666 NEWMAN 0 ENGINEER 10000.80 740# 741# Testing DBF table changes 742# 743CREATE TABLE t1 ENGINE=connect TABLE_TYPE=dbf AS SELECT * FROM employee; 744Warnings: 745Warning 1105 No file name. Table will use t1.dbf 746CALL test.tst_up(); 747serialno name sex title manager department secretary salary 74874200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 74902345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 75078943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 75107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 75245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 75334567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 75477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 75574234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 75656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 75773452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 75822222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 75955555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 76027845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 76198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 76211111 CHERRY 2 SECRETARY 31416 2452 4500.00 76333333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 76412345 KITTY 2 TYPIST 40567 0319 3000.45 76524888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 76687777 STRONG 1 DIRECTOR 0021 22222 23000.00 76776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 76870012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 76940567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 77031416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 77136666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 77200137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 77373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 77400023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 775serialno name sex title manager department secretary salary 77674200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 77702345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 77878943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 77907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 78045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 78134567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 78277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 78374234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 78456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 78573452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 78622222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 78755555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 78827845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 78998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 79011111 CHERRY 2 SECRETARY 31416 2452 4500.00 79133333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 79212345 KITTY 2 TYPIST 40567 0319 3000.45 79324888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 79487777 STRONG 1 DIRECTOR 0021 22222 23000.00 79576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 79670012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 79740567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 79831416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 79936666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 80000137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 80173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 80200023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 803serialno name sex title manager department secretary salary 80474200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 80502345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 80678943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 80707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 80845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 80934567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 81077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 81174234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 81256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 81373452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 81498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 81576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 81631416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 81736666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 81800137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 81973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 82000023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 821serialno name sex title manager department secretary salary 82207654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 82345678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 82434567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 82577777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 82674234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 82756789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 82873452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 82998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 83076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 83131416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 83236666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 83300137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 83473111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 83500023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 83666666 NEWMAN 0 ENGINEER 10000.80 837# 838# Testing DBF table changes 839# 840CREATE TABLE t1 ENGINE=connect TABLE_TYPE=dbf mapped=yes AS SELECT * FROM employee; 841Warnings: 842Warning 1105 No file name. Table will use t1.dbf 843CALL test.tst_up(); 844serialno name sex title manager department secretary salary 84574200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 84602345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 84778943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 84807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 84945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 85034567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 85177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 85274234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 85356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 85473452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 85522222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 85655555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 85727845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 85898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 85911111 CHERRY 2 SECRETARY 31416 2452 4500.00 86033333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 86112345 KITTY 2 TYPIST 40567 0319 3000.45 86224888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 86387777 STRONG 1 DIRECTOR 0021 22222 23000.00 86476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 86570012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 86640567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 86731416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 86836666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 86900137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 87073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 87100023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 872serialno name sex title manager department secretary salary 87374200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 87402345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 87578943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 87607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 87745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 87834567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 87977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 88074234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 88156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 88273452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 88322222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 88455555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 88527845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 88698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 88711111 CHERRY 2 SECRETARY 31416 2452 4500.00 88833333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 88912345 KITTY 2 TYPIST 40567 0319 3000.45 89024888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 89187777 STRONG 1 DIRECTOR 0021 22222 23000.00 89276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 89370012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 89440567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 89531416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 89636666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 89700137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 89873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 89900023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 900serialno name sex title manager department secretary salary 90174200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 90202345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 90378943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 90407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 90545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 90634567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 90777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 90874234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 90956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 91073452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 91198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 91276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 91331416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 91436666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 91500137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 91673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 91700023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 918serialno name sex title manager department secretary salary 91907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 92045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 92134567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 92277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 92374234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 92456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 92573452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 92698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 92776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 92831416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 92936666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 93000137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 93173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 93200023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 93366666 NEWMAN 0 ENGINEER 10000.80 934# 935# Testing BIN table changes 936# 937CREATE TABLE t1 ENGINE=connect TABLE_TYPE=bin AS SELECT * FROM employee; 938Warnings: 939Warning 1105 No file name. Table will use t1.bin 940CALL test.tst_up(); 941serialno name sex title manager department secretary salary 94274200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 94302345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 94478943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 94507654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 94645678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 94734567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 94877777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 94974234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 95056789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 95173452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 95222222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 95355555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 95427845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 95598765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 95611111 CHERRY 2 SECRETARY 31416 2452 4500.00 95733333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 95812345 KITTY 2 TYPIST 40567 0319 3000.45 95924888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 96087777 STRONG 1 DIRECTOR 0021 22222 23000.00 96176543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 96270012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 96340567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 96431416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 96536666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 96600137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 96773111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 96800023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 969serialno name sex title manager department secretary salary 97074200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 97102345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 97278943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 97307654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 97445678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 97534567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 97677777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 97774234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 97856789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 97973452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 98022222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 98155555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 98227845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 98398765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 98411111 CHERRY 2 SECRETARY 31416 2452 4500.00 98533333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 98612345 KITTY 2 TYPIST 40567 0319 3000.45 98724888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 98887777 STRONG 1 DIRECTOR 0021 22222 23000.00 98976543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 99070012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 99140567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 99231416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 99336666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 99400137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 99573111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 99600023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 997serialno name sex title manager department secretary salary 99874200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 99902345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 100078943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 100107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 100245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 100334567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 100477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 100574234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 100656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 100773452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 100898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 100976543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 101031416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 101136666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 101200137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 101373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 101400023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1015serialno name sex title manager department secretary salary 101607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 101745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 101834567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 101977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 102074234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 102156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 102273452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 102398765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 102476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 102531416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 102636666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 102700137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 102873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 102900023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 103066666 NEWMAN 0 ENGINEER 10000.80 1031# 1032# Testing BIN table changes 1033# 1034CREATE TABLE t1 ENGINE=connect TABLE_TYPE=bin mapped=yes AS SELECT * FROM employee; 1035Warnings: 1036Warning 1105 No file name. Table will use t1.bin 1037CALL test.tst_up(); 1038serialno name sex title manager department secretary salary 103974200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 104002345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 104178943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 104207654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 104345678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 104434567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 104577777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 104674234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 104756789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 104873452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 104922222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 105055555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 105127845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 105298765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 105311111 CHERRY 2 SECRETARY 31416 2452 4500.00 105433333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 105512345 KITTY 2 TYPIST 40567 0319 3000.45 105624888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 105787777 STRONG 1 DIRECTOR 0021 22222 23000.00 105876543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 105970012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 106040567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 106131416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 106236666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 106300137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 106473111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 106500023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 1066serialno name sex title manager department secretary salary 106774200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 106802345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 106978943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 107007654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 107145678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 107234567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 107377777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 107474234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 107556789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 107673452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 107722222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 107855555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 107927845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 108098765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 108111111 CHERRY 2 SECRETARY 31416 2452 4500.00 108233333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 108312345 KITTY 2 TYPIST 40567 0319 3000.45 108424888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 108587777 STRONG 1 DIRECTOR 0021 22222 23000.00 108676543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 108770012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 108840567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 108931416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 109036666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 109100137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 109273111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 109300023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1094serialno name sex title manager department secretary salary 109574200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 109602345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 109778943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 109807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 109945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 110034567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 110177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 110274234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 110356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 110473452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 110598765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 110676543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 110731416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 110836666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 110900137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 111073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 111100023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1112serialno name sex title manager department secretary salary 111307654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 111445678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 111534567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 111677777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 111774234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 111856789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 111973452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 112098765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 112176543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 112231416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 112336666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 112400137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 112573111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 112600023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 112766666 NEWMAN 0 ENGINEER 10000.80 1128# 1129# Testing BIN table changes 1130# 1131CREATE TABLE t1 ENGINE=connect TABLE_TYPE=bin huge=yes AS SELECT * FROM employee; 1132Warnings: 1133Warning 1105 No file name. Table will use t1.bin 1134CALL test.tst_up(); 1135serialno name sex title manager department secretary salary 113674200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 113702345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 113878943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 113907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 114045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 114134567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 114277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 114374234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 114456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 114573452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 114622222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 114755555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 114827845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 114998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 115011111 CHERRY 2 SECRETARY 31416 2452 4500.00 115133333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 115212345 KITTY 2 TYPIST 40567 0319 3000.45 115324888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 115487777 STRONG 1 DIRECTOR 0021 22222 23000.00 115576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 115670012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 115740567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 115831416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 115936666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 116000137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 116173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 116200023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 1163serialno name sex title manager department secretary salary 116474200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 116502345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 116678943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 116707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 116845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 116934567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 117077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 117174234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 117256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 117373452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 117422222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 117555555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 117627845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 117798765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 117811111 CHERRY 2 SECRETARY 31416 2452 4500.00 117933333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 118012345 KITTY 2 TYPIST 40567 0319 3000.45 118124888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 118287777 STRONG 1 DIRECTOR 0021 22222 23000.00 118376543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 118470012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 118540567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 118631416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 118736666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 118800137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 118973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 119000023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1191serialno name sex title manager department secretary salary 119274200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 119302345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 119478943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 119507654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 119645678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 119734567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 119877777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 119974234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 120056789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 120173452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 120298765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 120376543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 120431416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 120536666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 120600137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 120773111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 120800023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1209serialno name sex title manager department secretary salary 121007654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 121145678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 121234567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 121377777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 121474234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 121556789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 121673452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 121798765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 121876543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 121931416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 122036666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 122100137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 122273111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 122300023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 122466666 NEWMAN 0 ENGINEER 10000.80 1225# 1226# Testing VEC table changes 1227# 1228CREATE TABLE t1 ENGINE=connect TABLE_TYPE=vec MAX_ROWS=30 AS SELECT * FROM employee; 1229Warnings: 1230Warning 1105 No file name. Table will use t1.vec 1231CALL test.tst_up(); 1232serialno name sex title manager department secretary salary 123374200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 123402345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 123578943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 123607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 123745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 123834567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 123977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 124074234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 124156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 124273452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 124322222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 124455555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 124527845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 124698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 124711111 CHERRY 2 SECRETARY 31416 2452 4500.00 124833333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 124912345 KITTY 2 TYPIST 40567 0319 3000.45 125024888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 125187777 STRONG 1 DIRECTOR 0021 22222 23000.00 125276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 125370012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 125440567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 125531416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 125636666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 125700137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 125873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 125900023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 1260serialno name sex title manager department secretary salary 126174200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 126202345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 126378943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 126407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 126545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 126634567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 126777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 126874234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 126956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 127073452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 127122222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 127255555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 127327845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 127498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 127511111 CHERRY 2 SECRETARY 31416 2452 4500.00 127633333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 127712345 KITTY 2 TYPIST 40567 0319 3000.45 127824888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 127987777 STRONG 1 DIRECTOR 0021 22222 23000.00 128076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 128170012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 128240567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 128331416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 128436666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 128500137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 128673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 128700023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1288serialno name sex title manager department secretary salary 128974200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 129002345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 129178943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 129207654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 129345678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 129434567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 129577777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 129674234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 129756789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 129873452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 129998765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 130076543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 130131416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 130236666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 130300137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 130473111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 130500023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1306serialno name sex title manager department secretary salary 130707654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 130845678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 130934567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 131077777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 131174234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 131256789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 131373452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 131498765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 131576543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 131631416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 131736666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 131800137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 131973111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 132000023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 132166666 NEWMAN 0 ENGINEER 10000.80 1322# 1323# Testing VEC table changes 1324# 1325CREATE TABLE t1 ENGINE=connect TABLE_TYPE=vec mapped=yes MAX_ROWS=30 AS SELECT * FROM employee; 1326Warnings: 1327Warning 1105 No file name. Table will use t1.vec 1328CALL test.tst_up(); 1329serialno name sex title manager department secretary salary 133074200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 133102345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 133278943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 133307654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 133445678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 133534567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 133677777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 133774234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 133856789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 133973452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 134022222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 134155555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 134227845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 134398765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 134411111 CHERRY 2 SECRETARY 31416 2452 4500.00 134533333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 134612345 KITTY 2 TYPIST 40567 0319 3000.45 134724888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 134887777 STRONG 1 DIRECTOR 0021 22222 23000.00 134976543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 135070012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 135140567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 135231416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 135336666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 135400137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 135573111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 135600023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 1357serialno name sex title manager department secretary salary 135874200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 135902345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 136078943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 136107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 136245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 136334567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 136477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 136574234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 136656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 136773452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 136822222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 136955555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 137027845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 137198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 137211111 CHERRY 2 SECRETARY 31416 2452 4500.00 137333333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 137412345 KITTY 2 TYPIST 40567 0319 3000.45 137524888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 137687777 STRONG 1 DIRECTOR 0021 22222 23000.00 137776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 137870012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 137940567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 138031416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 138136666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 138200137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 138373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 138400023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1385serialno name sex title manager department secretary salary 138674200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 138702345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 138878943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 138907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 139045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 139134567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 139277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 139374234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 139456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 139573452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 139698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 139776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 139831416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 139936666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 140000137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 140173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 140200023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1403serialno name sex title manager department secretary salary 140407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 140545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 140634567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 140777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 140874234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 140956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 141073452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 141198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 141276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 141331416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 141436666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 141500137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 141673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 141700023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 141866666 NEWMAN 0 ENGINEER 10000.80 1419# 1420# Testing VEC table changes 1421# 1422CREATE TABLE t1 ENGINE=connect TABLE_TYPE=vec huge=yes MAX_ROWS=30 AS SELECT * FROM employee; 1423Warnings: 1424Warning 1105 No file name. Table will use t1.vec 1425CALL test.tst_up(); 1426serialno name sex title manager department secretary salary 142774200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 142802345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 142978943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 143007654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 143145678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 143234567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 143377777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 143474234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 143556789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 143673452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 143722222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 143855555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 143927845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 144098765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 144111111 CHERRY 2 SECRETARY 31416 2452 4500.00 144233333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 144312345 KITTY 2 TYPIST 40567 0319 3000.45 144424888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 144587777 STRONG 1 DIRECTOR 0021 22222 23000.00 144676543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 144770012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 144840567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 144931416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 145036666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 145100137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 145273111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 145300023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 1454serialno name sex title manager department secretary salary 145574200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 145602345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 145778943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 145807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 145945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 146034567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 146177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 146274234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 146356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 146473452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 146522222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 146655555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 146727845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 146898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 146911111 CHERRY 2 SECRETARY 31416 2452 4500.00 147033333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 147112345 KITTY 2 TYPIST 40567 0319 3000.45 147224888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 147387777 STRONG 1 DIRECTOR 0021 22222 23000.00 147476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 147570012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 147640567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 147731416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 147836666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 147900137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 148073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 148100023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1482serialno name sex title manager department secretary salary 148374200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 148402345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 148578943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 148607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 148745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 148834567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 148977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 149074234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 149156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 149273452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 149398765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 149476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 149531416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 149636666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 149700137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 149873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 149900023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1500serialno name sex title manager department secretary salary 150107654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 150245678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 150334567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 150477777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 150574234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 150656789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 150773452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 150898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 150976543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 151031416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 151136666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 151200137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 151373111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 151400023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 151566666 NEWMAN 0 ENGINEER 10000.80 1516# 1517# Testing INI table changes 1518# 1519CREATE TABLE t1 1520( 1521serialno CHAR(5) NOT NULL FLAG=1, 1522name VARCHAR(12) NOT NULL, 1523sex TINYINT(1), 1524title VARCHAR(15) NOT NULL, 1525manager CHAR(5), 1526department CHAR(4), 1527secretary CHAR(5), 1528salary DOUBLE(8,2) NOT NULL 1529) ENGINE=connect TABLE_TYPE=ini; 1530Warnings: 1531Warning 1105 No file name. Table will use t1.ini 1532INSERT INTO t1 SELECT * FROM employee; 1533CALL test.tst_up(); 1534serialno name sex title manager department secretary salary 153574200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 153602345 SMITH 1 ENGINEER 31416 2452 11111 9000.00 153778943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 153807654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 153945678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 154034567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000.00 154177777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 154274234 WALTER 1 ENGINEER 70012 0318 24888 7400.00 154356789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 154473452 TONGHO 1 ENGINEER 70012 0318 24888 6800.00 154522222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 154655555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 154727845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 154898765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 154911111 CHERRY 2 SECRETARY 31416 2452 4500.00 155033333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 155112345 KITTY 2 TYPIST 40567 0319 3000.45 155224888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 155387777 STRONG 1 DIRECTOR 0021 22222 23000.00 155476543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 155570012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 155640567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 155731416 ORELLY 1 ENGINEER 87777 2452 11111 13400.00 155836666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000.00 155900137 BROWNY 1 ENGINEER 40567 0319 12345 10500.00 156073111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 156100023 MARTIN 1 ENGINEER 40567 0319 12345 10000.00 1562serialno name sex title manager department secretary salary 156374200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 156402345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 156578943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 156607654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 156745678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 156834567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 156977777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 157074234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 157156789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 157273452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 157322222 SHORTSIGHT 2 SECRETARY 87777 0021 5500.00 157455555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000.50 157527845 HONEY 2 SECRETARY 70012 0318 24888 4900.00 157698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 157711111 CHERRY 2 SECRETARY 31416 2452 4500.00 157833333 MONAPENNY 2 SECRETARY 07654 0319 3800.00 157912345 KITTY 2 TYPIST 40567 0319 3000.45 158024888 PLUMHEAD 2 TYPIST 27845 0318 2800.00 158187777 STRONG 1 DIRECTOR 0021 22222 23000.00 158276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 158370012 WERTHER 1 DIRECTOR 87777 0318 27845 14500.00 158440567 QUINN 1 DIRECTOR 87777 0319 55555 14000.00 158531416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 158636666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 158700137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 158873111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 158900023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1590serialno name sex title manager department secretary salary 159174200 BANCROFT 2 SALESMAN 70012 0318 24888 9600.00 159202345 SMITH 1 TECHNICIAN 31416 2452 11111 9001.00 159378943 MERCHANT 1 SALESMAN 70012 0318 24888 8700.00 159407654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 159545678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 159634567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 159777777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 159874234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 159956789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 160073452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 160198765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 160276543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 160331416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 160436666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 160500137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 160673111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 160700023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 1608serialno name sex title manager department secretary salary 160907654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500.00 161045678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500.00 161134567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001.00 161277777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500.00 161374234 WALTER 1 TECHNICIAN 70012 0318 24888 7401.00 161456789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000.00 161573452 TONGHO 1 PUPPET 70012 0318 24888 6801.00 161698765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700.00 161776543 BULLOZER 1 SALESMAN 40567 0319 12345 14800.00 161831416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401.00 161936666 BIGHORN 1 RESEARCH 31416 2452 11111 11001.00 162000137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501.00 162173111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030.00 162200023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001.00 162366666 NEWMAN NULL ENGINEER NULL NULL NULL 10000.80 1624# 1625# Testing XML table changes (must be in a separate test) 1626# 1627DROP PROCEDURE test.tst_up; 1628DROP TABLE employee; 1629SET sql_mode = DEFAULT; 1630