| Quellcodebibliothek Statistik Leitseite products/Sources/formale Sprachen/C/MariaDB/storage/connect/mysql-test/connect/r/ (MariaDB Server Version 8.1-8.4©) Datei vom 1.9.2026 mit Größe 83 kB |
|
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 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 em 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 empl 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 em 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 em 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 em 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 empl 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 e 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 SE 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 SELE 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_firs 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_firs 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 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 #
¤ Diese beiden folgenden Angebotsgruppen bietet das Unternehmen0.72Angebot (Wie Sie bei der Firma Beratungs- und Dienstleistungen beauftragen können 2026-10-08) ¤*Eine klare Vorstellung vom Zielzustand |
|
||||||||||||||
2026-10-10