Quelle upd.result
Sprache: Lisp
SET sql_mode = 'NO_ENGINE_SUBSTITUTION' ;
CREATE TABLE employee
(
serialno CHAR(5 ) NOT NULL,
name VARCHAR(12 ) NOT NULL FLAG=6 ,
sex TINYINT(1 ) NOT NULL,
title VARCHAR(15 ) NOT NULL FLAG=20 ,
manager CHAR(5 ) NOT NULL,
department CHAR(4 ) NOT NULL FLAG=41 ,
secretary CHAR(5 ) NOT NULL FLAG=46 ,
salary DOUBLE(8 ,2 ) NOT NULL FLAG=52
) ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=fix FILE_NAME='employee.dat' ENDING=1 ;
SELECT * FROM employee;
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
CREATE PROCEDURE test.tst_up() DETERMINISTIC
BEGIN
SELECT * FROM t1;
UPDATE t1 SET salary = salary + 1 , title = 'RESEARCH' WHERE title = 'SCIENTIST' ;
UPDATE t1 SET salary = salary + 1 , title = 'TECHNICIAN' WHERE title = 'ENGINEER' ;
UPDATE t1 SET title = 'PUPPET' WHERE name = 'TONGHO' ;
UPDATE t1 SET salary = 0 . WHERE title = 'XXX' ;
SELECT * FROM t1;
DELETE FROM t1 WHERE title = 'SECRETARY' ;
DELETE FROM t1 WHERE title = 'DIRECTOR' ;
DELETE FROM t1 WHERE title = 'TYPIST' ;
SELECT * FROM t1;
DELETE FROM t1 LIMIT 3 ;
INSERT INTO t1(serialno, name, title, salary) VALUES('66666' ,'NEWMAN' ,'ENGINEER' ,10000 .80 );
SELECT * FROM t1;
DROP TABLE t1;
END//
#
# Testing DOS table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 AS SELECT * FROM employee;
Warnings:
Warning 1105 No table_type. Will be set to DOS
Warning 1105 No file name. Table will use t1.dos
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing DOS table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 mapped=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No table_type. Will be set to DOS
Warning 1105 No file name. Table will use t1.dos
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing FIX table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=fix AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.fix
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing FIX table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=fix mapped=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.fix
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing FIX table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=fix huge=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.fix
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing CSV table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=csv AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.csv
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing CSV table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=csv mapped=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.csv
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing DBF table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=dbf AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.dbf
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing DBF table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=dbf mapped=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.dbf
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing BIN table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=bin AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.bin
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing BIN table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=bin mapped=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.bin
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing BIN table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=bin huge=yes AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.bin
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing VEC table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=vec MAX_ROWS=30 AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.vec
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing VEC table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=vec mapped=yes MAX_ROWS=30 AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.vec
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing VEC table changes
#
CREATE TABLE t1 ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=vec huge=yes MAX_ROWS=30 AS SELECT * FROM employee;
Warnings:
Warning 1105 No file name. Table will use t1.vec
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN 0 ENGINEER 10000 .80
#
# Testing INI table changes
#
CREATE TABLE t1
(
serialno CHAR(5 ) NOT NULL FLAG=1 ,
name VARCHAR(12 ) NOT NULL,
sex TINYINT(1 ),
title VARCHAR(15 ) NOT NULL,
manager CHAR(5 ),
department CHAR(4 ),
secretary CHAR(5 ),
salary DOUBLE(8 ,2 ) NOT NULL
) ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=ini;
Warnings:
Warning 1105 No file name. Table will use t1.ini
INSERT INTO t1 SELECT * FROM employee;
CALL test.tst_up();
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 ENGINEER 31416 2452 11111 9000 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 SCIENTIST 31416 2452 11111 8000 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 ENGINEER 70012 0318 24888 7400 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 ENGINEER 70012 0318 24888 6800 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 ENGINEER 87777 2452 11111 13400 .00
36666 BIGHORN 1 SCIENTIST 31416 2452 11111 11000 .00
00137 BROWNY 1 ENGINEER 40567 0319 12345 10500 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 ENGINEER 40567 0319 12345 10000 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
22222 SHORTSIGHT 2 SECRETARY 87777 0021 5500 .00
55555 MESSIFUL 2 SECRETARY 40567 0319 12345 5000 .50
27845 HONEY 2 SECRETARY 70012 0318 24888 4900 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
11111 CHERRY 2 SECRETARY 31416 2452 4500 .00
33333 MONAPENNY 2 SECRETARY 07654 0319 3800 .00
12345 KITTY 2 TYPIST 40567 0319 3000 .45
24888 PLUMHEAD 2 TYPIST 27845 0318 2800 .00
87777 STRONG 1 DIRECTOR 0021 22222 23000 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
70012 WERTHER 1 DIRECTOR 87777 0318 27845 14500 .00
40567 QUINN 1 DIRECTOR 87777 0319 55555 14000 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
74200 BANCROFT 2 SALESMAN 70012 0318 24888 9600 .00
02345 SMITH 1 TECHNICIAN 31416 2452 11111 9001 .00
78943 MERCHANT 1 SALESMAN 70012 0318 24888 8700 .00
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
serialno name sex title manager department secretary salary
07654 FUNNIGUY 1 ADMINISTRATOR 40567 0319 33333 8500 .00
45678 BUGHAPPY 1 PROGRAMMER 40567 0319 12345 8500 .00
34567 BIGHEAD 1 RESEARCH 31416 2452 11111 8001 .00
77777 SHRINKY 2 ADMINISTRATOR 70012 0318 27845 7500 .00
74234 WALTER 1 TECHNICIAN 70012 0318 24888 7401 .00
56789 FODDERMAN 1 SALESMAN 40567 0319 12345 7000 .00
73452 TONGHO 1 PUPPET 70012 0318 24888 6801 .00
98765 GOOSEPEN 1 ADMINISTRATOR 07654 0319 33333 4700 .00
76543 BULLOZER 1 SALESMAN 40567 0319 12345 14800 .00
31416 ORELLY 1 TECHNICIAN 87777 2452 11111 13401 .00
36666 BIGHORN 1 RESEARCH 31416 2452 11111 11001 .00
00137 BROWNY 1 TECHNICIAN 40567 0319 12345 10501 .00
73111 WHEELFOR 1 SALESMAN 70012 0318 24888 10030 .00
00023 MARTIN 1 TECHNICIAN 40567 0319 12345 10001 .00
66666 NEWMAN NULL ENGINEER NULL NULL NULL 10000 .80
#
# Testing XML table changes (must be in a separate test)
#
DROP PROCEDURE test.tst_up;
DROP TABLE employee;
SET sql_mode = DEFAULT;
#
# End of 10 .10 tests
#
SET sql_mode = 'NO_ENGINE_SUBSTITUTION' ;
CREATE TABLE t1
(
name char(12 ) not null,
city char(11 ) not null,
birth date not null date_format='DD/MM/YYYY' ,
hired date not null date_format='DD/MM/YYYY' flag=36
) ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=FIX FILE_NAME='boys.txt' ENDING=1 ;
CREATE TABLE t2 (
_id INT(2 ) NOT NULL,
name_first CHAR(9 ) NOT NULL JPATH='$.name.first' ,
name_aka CHAR(4 ) DEFAULT NULL JPATH='$.name.aka' ,
name_last CHAR(10 ) NOT NULL JPATH='$.name.last' ,
title CHAR(12 ) DEFAULT NULL,
birth CHAR(20 ) DEFAULT NULL,
death CHAR(20 ) DEFAULT NULL,
contribs CHAR(50 ) NOT NULL JPATH='$.contribs' ,
awards_award CHAR(42 ) DEFAULT NULL JPATH='$.awards.award' ,
awards_year CHAR(4 ) DEFAULT NULL JPATH='$.awards.year' ,
awards_by CHAR(38 ) DEFAULT NULL JPATH='$.awards.by'
) ENGINE=CONNECT CHARSET=latin1 TABLE_TYPE=JSON FILE_NAME='bios.json' ;
# Multi-update
select t1.name, t1.city from t1;
name city
John Boston
Henry Boston
George San Jose
Sam Chicago
James Dallas
Bill Boston
select t2._id, t2.name_first, t2.name_aka, t2.name_last from t2;
_id name_first name_aka name_last
1 John NULL Backus
2 John NULL McCarthy
3 Grace NULL Hopper
4 Kristen NULL Nygaard
5 Ole-Johan NULL Dahl
6 Guido NULL van Rossum
7 Dennis NULL Ritchie
8 Yukihiro Matz Matsumoto
9 James NULL Gosling
10 Martin NULL Odersky
select t1.name, t2.name_last, t2.name_aka, t1.city from t1, t2 where t1.name=t2.name_first and t1.birth
BETWEEN '1992-01-01' and '1995-01-01' ;
name name_last name_aka city
James Gosling NULL Dallas
explain update t1, t2
set t1.city='Washington' , t2.name_aka='von' where t1.name=t2.name_first and t1.birth
BETWEEN '1992-01-01' and '1995-01-01' ;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using where
1 SIMPLE t2 ALL NULL NULL NULL NULL 10 Using where
update t1, t2
set t1.city='Washington' , t2.name_aka='von' where t1.name=t2.name_first and t1.birth
BETWEEN '1992-01-01' and '1995-01-01' ;
select t1.name, t2.name_last, t2.name_aka, t1.city from t1, t2 where t1.name=t2.name_first and t1.birth
BETWEEN '1992-01-01' and '1995-01-01' ;
name name_last name_aka city
James Gosling von Washington
# Conversion to multi-update
select t1.name, t1.city from t1;
name city
John Boston
Henry Boston
George San Jose
Sam Chicago
James Washington
Bill Boston
explain update t1
set t1.city='New York' where t1.name in (select t2.name_first from t2);
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 6
1 PRIMARY t2 ALL NULL NULL NULL NULL 10 Using where; FirstMatch(t1)
update t1
set t1.city='New York' where t1.name in (select t2.name_first from t2);
select t1.name, t1.city from t1;
name city
John New York
Henry Boston
George San Jose
Sam Chicago
James New York
Bill Boston
select t1.name, t1.city from t1 where t1.name in (select a.name from t1 as a where a.birth
BETWEEN '1981-01-01' and '1982-01-01' );
name city
George San Jose
explain update t1 set t1.city='Los Angeles' where t1.name in (select a.name from t1 as a where a.birth
BETWEEN '1981-01-01' and '1982-01-01' );
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 6
1 PRIMARY a ALL NULL NULL NULL NULL 6 Using where; FirstMatch(t1)
update t1 set t1.city='Los Angeles' where t1.name in (select a.name from t1 as a where a.birth
BETWEEN '1981-01-01' and '1982-01-01' );
select t1.name, t1.city from t1 where t1.name in (select a.name from t1 as a where a.birth
BETWEEN '1981-01-01' and '1982-01-01' );
name city
George Los Angeles
# Multi-delete
explain delete t1.*, t2.* from t1, t2 where t1.name=t2.name_first and t1.birth
BETWEEN '1992-01-01' and '1995-01-01' ;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using where
1 SIMPLE t2 ALL NULL NULL NULL NULL 10 Using where
delete t1.*, t2.* from t1, t2 where t1.name=t2.name_first and t1.birth
BETWEEN '1992-01-01' and '1995-01-01' ;
select t1.name, t1.city from t1;
name city
John New York
Henry Boston
George Los Angeles
Sam Chicago
Bill Boston
select t2._id, t2.name_first, t2.name_aka, t2.name_last from t2;
_id name_first name_aka name_last
1 John NULL Backus
2 John NULL McCarthy
3 Grace NULL Hopper
4 Kristen NULL Nygaard
5 Ole-Johan NULL Dahl
6 Guido NULL van Rossum
7 Dennis NULL Ritchie
8 Yukihiro Matz Matsumoto
10 Martin NULL Odersky
# Conversion to multi-delete
explain delete from t1 where t1.name in (select t2.name_first from t2);
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 5
1 PRIMARY t2 ALL NULL NULL NULL NULL 9 Using where; FirstMatch(t1)
delete from t1 where t1.name in (select t2.name_first from t2);
select t1.name, t1.city from t1;
name city
Henry Boston
George Los Angeles
Sam Chicago
Bill Boston
explain delete from t1 where t1.name in (select a.name from t1 as a where a.birth
BETWEEN '1981-01-01' and '1982-01-01' );
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 4
1 PRIMARY a ALL NULL NULL NULL NULL 4 Using where; FirstMatch(t1)
delete from t1 where t1.name in (select a.name from t1 as a where a.birth
BETWEEN '1981-01-01' and '1982-01-01' );
select t1.name, t1.city from t1;
name city
Henry Boston
Sam Chicago
Bill Boston
drop tables t1, t2;
SET sql_mode = DEFAULT;
#
# End of 11 .0 tests
#
Messung V0.5 in Prozent C=96 H=100 G=97
¤ Dauer der Verarbeitung: 0.83 Sekunden
(vorverarbeitet am 2026-10-08)
¤
*© Formatika GbR, Deutschland
2026-10-10
Neuigkeiten
Aktuelles
Motto des Tages
Open Source Software
Jenseits des Üblichen ....
Besucherstatistik
Statistik
#Sources=1126438
#Domains=1897691