DROP DATABASE IF EXISTS mcol641_update_db;
CREATE DATABASE mcol641_update_db;
USE mcol641_update_db;
DROP PROCEDURE IF EXISTS signedinsertproc;
DROP PROCEDURE IF EXISTS signeddeleteproc;
DROP PROCEDURE IF EXISTS unsignedinsertproc;
DROP PROCEDURE IF EXISTS unsigneddeleteproc;
CREATE PROCEDURE signedinsertproc ()
BEGIN
INSERT INTO cs1 VALUES (125, 125);
INSERT INTO cs1 VALUES (-125, -125);
INSERT INTO cs1 values (99999999999999999999999999999999999998, 9999999999999999998);
INSERT INTO cs1 values (99999999999999999999999999999999999999, 9999999999999999999);
INSERT INTO cs1 values (-99999999999999999999999999999999999998, -9999999999999999998);
INSERT INTO cs1 values (-99999999999999999999999999999999999999, -9999999999999999999);
INSERT INTO cs1 VALUES (0, 0);
INSERT INTO cs1 VALUES (NULL, NULL);
INSERT INTO cs2 VALUES (1.25, 1.25);
INSERT INTO cs2 VALUES (-1.25, -1.25);
INSERT INTO cs2 values (9999999999999999999999999999.9999999998, 999999999.9999999998);
INSERT INTO cs2 values (9999999999999999999999999999.9999999999, 999999999.9999999999);
INSERT INTO cs2 values (-9999999999999999999999999999.9999999998, -999999999.9999999998);
INSERT INTO cs2 values (-9999999999999999999999999999.9999999999, -999999999.9999999999);
INSERT INTO cs2 VALUES (1.1234567891, 1.1234567891);
INSERT INTO cs2 VALUES (1.9999999999, 1.9999999999);
INSERT INTO cs2 VALUES (-1.1234567891, -1.1234567891);
INSERT INTO cs2 VALUES (-1.9999999999, -1.9999999999);
INSERT INTO cs2 VALUES (1.0000000009, 1.0000000009);
INSERT INTO cs2 VALUES (-1.0000000009, -1.0000000009);
INSERT INTO cs2 VALUES (0, 0);
INSERT INTO cs2 VALUES (NULL, NULL);
INSERT INTO cs3 VALUES (0.125, 0.125);
INSERT INTO cs3 VALUES (-0.125, -0.125);
INSERT INTO cs3 values (0.99999999999999999999999999999999999998, 0.9999999999999999998);
INSERT INTO cs3 values (0.99999999999999999999999999999999999999, 0.9999999999999999999);
INSERT INTO cs3 values (-0.99999999999999999999999999999999999998, -0.9999999999999999998);
INSERT INTO cs3 values (-0.99999999999999999999999999999999999999, -0.9999999999999999999);
INSERT INTO cs3 VALUES (0.12345678901234567890123456789012345678, 0.1234567890123456789);
INSERT INTO cs3 VALUES (0.19999999999999999999999999999999999999, 0.1999999999999999999);
INSERT INTO cs3 VALUES (-0.12345678901234567890123456789012345678, -0.1234567890123456789);
INSERT INTO cs3 VALUES (-0.19999999999999999999999999999999999999, -0.1999999999999999999);
INSERT INTO cs3 VALUES (0.00000000000000000000000000000000000009, 0.0000000000000000009);
INSERT INTO cs3 VALUES (-0.00000000000000000000000000000000000009, -0.0000000000000000009);
INSERT INTO cs3 VALUES (0, 0);
INSERT INTO cs3 VALUES (NULL, NULL);
END//
CREATE PROCEDURE unsignedinsertproc ()
BEGIN
INSERT INTO cs4 VALUES (125, 125);
INSERT INTO cs4 values (99999999999999999999999999999999999998, 9999999999999999998);
INSERT INTO cs4 values (99999999999999999999999999999999999999, 9999999999999999999);
INSERT INTO cs4 VALUES (0, 0);
INSERT INTO cs4 VALUES (NULL, NULL);
INSERT INTO cs5 VALUES (1.25, 1.25);
INSERT INTO cs5 values (9999999999999999999999999999.9999999998, 999999999.9999999998);
INSERT INTO cs5 values (9999999999999999999999999999.9999999999, 999999999.9999999999);
INSERT INTO cs5 VALUES (1.1234567891, 1.1234567891);
INSERT INTO cs5 VALUES (1.9999999999, 1.9999999999);
INSERT INTO cs5 VALUES (1.0000000009, 1.0000000009);
INSERT INTO cs5 VALUES (0, 0);
INSERT INTO cs5 VALUES (NULL, NULL);
INSERT INTO cs6 VALUES (0.125, 0.125);
INSERT INTO cs6 values (0.99999999999999999999999999999999999998, 0.9999999999999999998);
INSERT INTO cs6 values (0.99999999999999999999999999999999999999, 0.9999999999999999999);
INSERT INTO cs6 VALUES (0.12345678901234567890123456789012345678, 0.1234567890123456789);
INSERT INTO cs6 VALUES (0.19999999999999999999999999999999999999, 0.1999999999999999999);
INSERT INTO cs6 VALUES (0.00000000000000000000000000000000000009, 0.0000000000000000009);
INSERT INTO cs6 VALUES (0, 0);
INSERT INTO cs6 VALUES (NULL, NULL);
END//
CREATE PROCEDURE signeddeleteproc ()
BEGIN
DELETE FROM cs1;
DELETE FROM cs2;
DELETE FROM cs3;
END//
CREATE PROCEDURE unsigneddeleteproc ()
BEGIN
DELETE FROM cs4;
DELETE FROM cs5;
DELETE FROM cs6;
END//
DROP TABLE IF EXISTS cs1;
DROP TABLE IF EXISTS cs2;
DROP TABLE IF EXISTS cs3;
DROP TABLE IF EXISTS cs4;
DROP TABLE IF EXISTS cs5;
DROP TABLE IF EXISTS cs6;
CREATE TABLE cs1 (d1 DECIMAL(38), d2 DECIMAL(19)) ENGINE=columnstore;
CREATE TABLE cs2 (d1 DECIMAL(38,10), d2 DECIMAL(19,10)) ENGINE=columnstore;
CREATE TABLE cs3 (d1 DECIMAL(38,38), d2 DECIMAL(19,19)) ENGINE=columnstore;
CREATE TABLE cs4 (d1 DECIMAL(38) UNSIGNED, d2 DECIMAL(19) UNSIGNED) ENGINE=columnstore;
CREATE TABLE cs5 (d1 DECIMAL(38,10) UNSIGNED, d2 DECIMAL(19,10) UNSIGNED) ENGINE=columnstore;
CREATE TABLE cs6 (d1 DECIMAL(38,38) UNSIGNED, d2 DECIMAL(19,19) UNSIGNED) ENGINE=columnstore;
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789;
SELECT "signedtest1", d1, d2 FROM cs1;
signedtest1	d1	d2
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
signedtest1	12345678901234567890123456789012345678	1234567890123456789
SELECT "signedtest1", d1, d2 FROM cs2;
signedtest1	d1	d2
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
SELECT "signedtest1", d1, d2 FROM cs3;
signedtest1	d1	d2
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=0 WHERE d1=-99999999999999999999999999999999999998;
UPDATE cs1 SET d1=0, d2=123456789012345678 WHERE d2=9999999999999999999;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=0 WHERE d1=-9999999999999999999999999999.9999999998;
UPDATE cs2 SET d1=0, d2=123456789.012345678 WHERE d2=999999999.9999999999;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0 WHERE d1=-0.99999999999999999999999999999999999998;
UPDATE cs3 SET d1=0, d2=0.123456789012345678 WHERE d2=0.9999999999999999999;
SELECT "signedtest2", d1, d2 FROM cs1;
signedtest2	d1	d2
signedtest2	125	125
signedtest2	-125	-125
signedtest2	99999999999999999999999999999999999998	9999999999999999998
signedtest2	0	123456789012345678
signedtest2	12345678901234567890123456789012345678	0
signedtest2	-99999999999999999999999999999999999999	-9999999999999999999
signedtest2	0	0
signedtest2	NULL	NULL
SELECT "signedtest2", d1, d2 FROM cs2;
signedtest2	d1	d2
signedtest2	1.2500000000	1.2500000000
signedtest2	-1.2500000000	-1.2500000000
signedtest2	9999999999999999999999999999.9999999998	999999999.9999999998
signedtest2	0.0000000000	123456789.0123456780
signedtest2	1234567890123456789012345678.9012345678	0.0000000000
signedtest2	-9999999999999999999999999999.9999999999	-999999999.9999999999
signedtest2	1.1234567891	1.1234567891
signedtest2	1.9999999999	1.9999999999
signedtest2	-1.1234567891	-1.1234567891
signedtest2	-1.9999999999	-1.9999999999
signedtest2	1.0000000009	1.0000000009
signedtest2	-1.0000000009	-1.0000000009
signedtest2	0.0000000000	0.0000000000
signedtest2	NULL	NULL
SELECT "signedtest2", d1, d2 FROM cs3;
signedtest2	d1	d2
signedtest2	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest2	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest2	0.99999999999999999999999999999999999998	0.9999999999999999998
signedtest2	0.00000000000000000000000000000000000000	0.1234567890123456780
signedtest2	0.12345678901234567890123456789012345678	0.0000000000000000000
signedtest2	-0.99999999999999999999999999999999999999	-0.9999999999999999999
signedtest2	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest2	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest2	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest2	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest2	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest2	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest2	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest2	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 in (-99999999999999999999999999999999999998, 99999999999999999999999999999999999999);
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 in (-9999999999999999999999999999.9999999998, 9999999999999999999999999999.9999999999);
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 in (-0.99999999999999999999999999999999999998, 0.99999999999999999999999999999999999999);
SELECT "signedtest3", d1, d2 FROM cs1;
signedtest3	d1	d2
signedtest3	125	125
signedtest3	-125	-125
signedtest3	99999999999999999999999999999999999998	9999999999999999998
signedtest3	12345678901234567890123456789012345678	1234567890123456789
signedtest3	12345678901234567890123456789012345678	1234567890123456789
signedtest3	-99999999999999999999999999999999999999	-9999999999999999999
signedtest3	0	0
signedtest3	NULL	NULL
SELECT "signedtest3", d1, d2 FROM cs2;
signedtest3	d1	d2
signedtest3	1.2500000000	1.2500000000
signedtest3	-1.2500000000	-1.2500000000
signedtest3	9999999999999999999999999999.9999999998	999999999.9999999998
signedtest3	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest3	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest3	-9999999999999999999999999999.9999999999	-999999999.9999999999
signedtest3	1.1234567891	1.1234567891
signedtest3	1.9999999999	1.9999999999
signedtest3	-1.1234567891	-1.1234567891
signedtest3	-1.9999999999	-1.9999999999
signedtest3	1.0000000009	1.0000000009
signedtest3	-1.0000000009	-1.0000000009
signedtest3	0.0000000000	0.0000000000
signedtest3	NULL	NULL
SELECT "signedtest3", d1, d2 FROM cs3;
signedtest3	d1	d2
signedtest3	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest3	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest3	0.99999999999999999999999999999999999998	0.9999999999999999998
signedtest3	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest3	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest3	-0.99999999999999999999999999999999999999	-0.9999999999999999999
signedtest3	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest3	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest3	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest3	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest3	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest3	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest3	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest3	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 < -99999999999999999999999999999999999998 OR d2 > 9999999999999999998;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 < -9999999999999999999999999999.9999999998 OR d2 > 999999999.9999999998;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 < -0.99999999999999999999999999999999999998 OR d2 > 0.9999999999999999998;
SELECT "signedtest4a", d1, d2 FROM cs1;
signedtest4a	d1	d2
signedtest4a	125	125
signedtest4a	-125	-125
signedtest4a	99999999999999999999999999999999999998	9999999999999999998
signedtest4a	12345678901234567890123456789012345678	1234567890123456789
signedtest4a	-99999999999999999999999999999999999998	-9999999999999999998
signedtest4a	12345678901234567890123456789012345678	1234567890123456789
signedtest4a	0	0
signedtest4a	NULL	NULL
SELECT "signedtest4a", d1, d2 FROM cs2;
signedtest4a	d1	d2
signedtest4a	1.2500000000	1.2500000000
signedtest4a	-1.2500000000	-1.2500000000
signedtest4a	9999999999999999999999999999.9999999998	999999999.9999999998
signedtest4a	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest4a	-9999999999999999999999999999.9999999998	-999999999.9999999998
signedtest4a	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest4a	1.1234567891	1.1234567891
signedtest4a	1.9999999999	1.9999999999
signedtest4a	-1.1234567891	-1.1234567891
signedtest4a	-1.9999999999	-1.9999999999
signedtest4a	1.0000000009	1.0000000009
signedtest4a	-1.0000000009	-1.0000000009
signedtest4a	0.0000000000	0.0000000000
signedtest4a	NULL	NULL
SELECT "signedtest4a", d1, d2 FROM cs3;
signedtest4a	d1	d2
signedtest4a	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest4a	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest4a	0.99999999999999999999999999999999999998	0.9999999999999999998
signedtest4a	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4a	-0.99999999999999999999999999999999999998	-0.9999999999999999998
signedtest4a	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4a	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4a	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest4a	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest4a	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest4a	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest4a	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest4a	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest4a	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 <= -99999999999999999999999999999999999998 OR d2 >= 9999999999999999998;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 <= -9999999999999999999999999999.9999999998 OR d2 >= 999999999.9999999998;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 <= -0.99999999999999999999999999999999999998 OR d2 >= 0.9999999999999999998;
SELECT "signedtest4b", d1, d2 FROM cs1;
signedtest4b	d1	d2
signedtest4b	125	125
signedtest4b	-125	-125
signedtest4b	12345678901234567890123456789012345678	1234567890123456789
signedtest4b	12345678901234567890123456789012345678	1234567890123456789
signedtest4b	12345678901234567890123456789012345678	1234567890123456789
signedtest4b	12345678901234567890123456789012345678	1234567890123456789
signedtest4b	0	0
signedtest4b	NULL	NULL
SELECT "signedtest4b", d1, d2 FROM cs2;
signedtest4b	d1	d2
signedtest4b	1.2500000000	1.2500000000
signedtest4b	-1.2500000000	-1.2500000000
signedtest4b	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest4b	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest4b	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest4b	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest4b	1.1234567891	1.1234567891
signedtest4b	1.9999999999	1.9999999999
signedtest4b	-1.1234567891	-1.1234567891
signedtest4b	-1.9999999999	-1.9999999999
signedtest4b	1.0000000009	1.0000000009
signedtest4b	-1.0000000009	-1.0000000009
signedtest4b	0.0000000000	0.0000000000
signedtest4b	NULL	NULL
SELECT "signedtest4b", d1, d2 FROM cs3;
signedtest4b	d1	d2
signedtest4b	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest4b	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest4b	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest4b	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest4b	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest4b	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest4b	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest4b	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest4b	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 is NULL;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 is NULL;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 is NULL;
SELECT "signedtest5", d1, d2 FROM cs1;
signedtest5	d1	d2
signedtest5	125	125
signedtest5	-125	-125
signedtest5	99999999999999999999999999999999999998	9999999999999999998
signedtest5	99999999999999999999999999999999999999	9999999999999999999
signedtest5	-99999999999999999999999999999999999998	-9999999999999999998
signedtest5	-99999999999999999999999999999999999999	-9999999999999999999
signedtest5	0	0
signedtest5	12345678901234567890123456789012345678	1234567890123456789
SELECT "signedtest5", d1, d2 FROM cs2;
signedtest5	d1	d2
signedtest5	1.2500000000	1.2500000000
signedtest5	-1.2500000000	-1.2500000000
signedtest5	9999999999999999999999999999.9999999998	999999999.9999999998
signedtest5	9999999999999999999999999999.9999999999	999999999.9999999999
signedtest5	-9999999999999999999999999999.9999999998	-999999999.9999999998
signedtest5	-9999999999999999999999999999.9999999999	-999999999.9999999999
signedtest5	1.1234567891	1.1234567891
signedtest5	1.9999999999	1.9999999999
signedtest5	-1.1234567891	-1.1234567891
signedtest5	-1.9999999999	-1.9999999999
signedtest5	1.0000000009	1.0000000009
signedtest5	-1.0000000009	-1.0000000009
signedtest5	0.0000000000	0.0000000000
signedtest5	1234567890123456789012345678.9012345678	123456789.0123456789
SELECT "signedtest5", d1, d2 FROM cs3;
signedtest5	d1	d2
signedtest5	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest5	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest5	0.99999999999999999999999999999999999998	0.9999999999999999998
signedtest5	0.99999999999999999999999999999999999999	0.9999999999999999999
signedtest5	-0.99999999999999999999999999999999999998	-0.9999999999999999998
signedtest5	-0.99999999999999999999999999999999999999	-0.9999999999999999999
signedtest5	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest5	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest5	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest5	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest5	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest5	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest5	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest5	0.12345678901234567890123456789012345678	0.1234567890123456789
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 != 125;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 != 1.25;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 != 0.125;
SELECT "signedtest6", d1, d2 FROM cs1;
signedtest6	d1	d2
signedtest6	125	125
signedtest6	12345678901234567890123456789012345678	1234567890123456789
signedtest6	12345678901234567890123456789012345678	1234567890123456789
signedtest6	12345678901234567890123456789012345678	1234567890123456789
signedtest6	12345678901234567890123456789012345678	1234567890123456789
signedtest6	12345678901234567890123456789012345678	1234567890123456789
signedtest6	12345678901234567890123456789012345678	1234567890123456789
signedtest6	NULL	NULL
SELECT "signedtest6", d1, d2 FROM cs2;
signedtest6	d1	d2
signedtest6	1.2500000000	1.2500000000
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest6	NULL	NULL
SELECT "signedtest6", d1, d2 FROM cs3;
signedtest6	d1	d2
signedtest6	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest6	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d2=d1 WHERE d1 = d2;
UPDATE cs2 SET d2=d1 WHERE d1 = d2;
UPDATE cs3 SET d2=d1 WHERE d1 = d2;
SELECT "signedtest7", d1, d2 FROM cs1;
signedtest7	d1	d2
signedtest7	125	125
signedtest7	-125	-125
signedtest7	99999999999999999999999999999999999998	9999999999999999998
signedtest7	99999999999999999999999999999999999999	9999999999999999999
signedtest7	-99999999999999999999999999999999999998	-9999999999999999998
signedtest7	-99999999999999999999999999999999999999	-9999999999999999999
signedtest7	0	0
signedtest7	NULL	NULL
SELECT "signedtest7", d1, d2 FROM cs2;
signedtest7	d1	d2
signedtest7	1.2500000000	1.2500000000
signedtest7	-1.2500000000	-1.2500000000
signedtest7	9999999999999999999999999999.9999999998	999999999.9999999998
signedtest7	9999999999999999999999999999.9999999999	999999999.9999999999
signedtest7	-9999999999999999999999999999.9999999998	-999999999.9999999998
signedtest7	-9999999999999999999999999999.9999999999	-999999999.9999999999
signedtest7	1.1234567891	1.1234567891
signedtest7	1.9999999999	1.9999999999
signedtest7	-1.1234567891	-1.1234567891
signedtest7	-1.9999999999	-1.9999999999
signedtest7	1.0000000009	1.0000000009
signedtest7	-1.0000000009	-1.0000000009
signedtest7	0.0000000000	0.0000000000
signedtest7	NULL	NULL
SELECT "signedtest7", d1, d2 FROM cs3;
signedtest7	d1	d2
signedtest7	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest7	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest7	0.99999999999999999999999999999999999998	0.9999999999999999998
signedtest7	0.99999999999999999999999999999999999999	0.9999999999999999999
signedtest7	-0.99999999999999999999999999999999999998	-0.9999999999999999998
signedtest7	-0.99999999999999999999999999999999999999	-0.9999999999999999999
signedtest7	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest7	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest7	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest7	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest7	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest7	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest7	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest7	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=d2 WHERE d1 != d2;
UPDATE cs2 SET d1=d2 WHERE d1 != d2;
UPDATE cs3 SET d1=d2 WHERE d1 != d2;
SELECT "signedtest8", d1, d2 FROM cs1;
signedtest8	d1	d2
signedtest8	125	125
signedtest8	-125	-125
signedtest8	9999999999999999998	9999999999999999998
signedtest8	9999999999999999999	9999999999999999999
signedtest8	-9999999999999999998	-9999999999999999998
signedtest8	-9999999999999999999	-9999999999999999999
signedtest8	0	0
signedtest8	NULL	NULL
SELECT "signedtest8", d1, d2 FROM cs2;
signedtest8	d1	d2
signedtest8	1.2500000000	1.2500000000
signedtest8	-1.2500000000	-1.2500000000
signedtest8	999999999.9999999998	999999999.9999999998
signedtest8	999999999.9999999999	999999999.9999999999
signedtest8	-999999999.9999999998	-999999999.9999999998
signedtest8	-999999999.9999999999	-999999999.9999999999
signedtest8	1.1234567891	1.1234567891
signedtest8	1.9999999999	1.9999999999
signedtest8	-1.1234567891	-1.1234567891
signedtest8	-1.9999999999	-1.9999999999
signedtest8	1.0000000009	1.0000000009
signedtest8	-1.0000000009	-1.0000000009
signedtest8	0.0000000000	0.0000000000
signedtest8	NULL	NULL
SELECT "signedtest8", d1, d2 FROM cs3;
signedtest8	d1	d2
signedtest8	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest8	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest8	0.99999999999999999980000000000000000000	0.9999999999999999998
signedtest8	0.99999999999999999990000000000000000000	0.9999999999999999999
signedtest8	-0.99999999999999999980000000000000000000	-0.9999999999999999998
signedtest8	-0.99999999999999999990000000000000000000	-0.9999999999999999999
signedtest8	0.12345678901234567890000000000000000000	0.1234567890123456789
signedtest8	0.19999999999999999990000000000000000000	0.1999999999999999999
signedtest8	-0.12345678901234567890000000000000000000	-0.1234567890123456789
signedtest8	-0.19999999999999999990000000000000000000	-0.1999999999999999999
signedtest8	0.00000000000000000090000000000000000000	0.0000000000000000009
signedtest8	-0.00000000000000000090000000000000000000	-0.0000000000000000009
signedtest8	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest8	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 < d2;
UPDATE cs2 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 < d2;
UPDATE cs3 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 < d2;
SELECT "signedtest9", d1, d2 FROM cs1;
signedtest9	d1	d2
signedtest9	125	125
signedtest9	-125	-125
signedtest9	99999999999999999999999999999999999998	9999999999999999998
signedtest9	99999999999999999999999999999999999999	9999999999999999999
signedtest9	12345678901234567890123456789012345678	1234567890123456789
signedtest9	12345678901234567890123456789012345678	1234567890123456789
signedtest9	0	0
signedtest9	NULL	NULL
SELECT "signedtest9", d1, d2 FROM cs2;
signedtest9	d1	d2
signedtest9	1.2500000000	1.2500000000
signedtest9	-1.2500000000	-1.2500000000
signedtest9	9999999999999999999999999999.9999999998	999999999.9999999998
signedtest9	9999999999999999999999999999.9999999999	999999999.9999999999
signedtest9	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest9	1234567890123456789012345678.9012345678	123456789.0123456789
signedtest9	1.1234567891	1.1234567891
signedtest9	1.9999999999	1.9999999999
signedtest9	-1.1234567891	-1.1234567891
signedtest9	-1.9999999999	-1.9999999999
signedtest9	1.0000000009	1.0000000009
signedtest9	-1.0000000009	-1.0000000009
signedtest9	0.0000000000	0.0000000000
signedtest9	NULL	NULL
SELECT "signedtest9", d1, d2 FROM cs3;
signedtest9	d1	d2
signedtest9	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest9	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest9	0.99999999999999999999999999999999999998	0.9999999999999999998
signedtest9	0.99999999999999999999999999999999999999	0.9999999999999999999
signedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest9	0.19999999999999999999999999999999999999	0.1999999999999999999
signedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
signedtest9	-0.00000000000000000000000000000000000009	-0.0000000000000000009
signedtest9	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest9	NULL	NULL
CALL signeddeleteproc();
CALL signedinsertproc();
UPDATE cs1 SET d1=d2 WHERE d1 > d2;
UPDATE cs2 SET d1=d2 WHERE d1 > d2;
UPDATE cs3 SET d1=d2 WHERE d1 > d2;
SELECT "signedtest10", d1, d2 FROM cs1;
signedtest10	d1	d2
signedtest10	125	125
signedtest10	-125	-125
signedtest10	9999999999999999998	9999999999999999998
signedtest10	9999999999999999999	9999999999999999999
signedtest10	-99999999999999999999999999999999999998	-9999999999999999998
signedtest10	-99999999999999999999999999999999999999	-9999999999999999999
signedtest10	0	0
signedtest10	NULL	NULL
SELECT "signedtest10", d1, d2 FROM cs2;
signedtest10	d1	d2
signedtest10	1.2500000000	1.2500000000
signedtest10	-1.2500000000	-1.2500000000
signedtest10	999999999.9999999998	999999999.9999999998
signedtest10	999999999.9999999999	999999999.9999999999
signedtest10	-9999999999999999999999999999.9999999998	-999999999.9999999998
signedtest10	-9999999999999999999999999999.9999999999	-999999999.9999999999
signedtest10	1.1234567891	1.1234567891
signedtest10	1.9999999999	1.9999999999
signedtest10	-1.1234567891	-1.1234567891
signedtest10	-1.9999999999	-1.9999999999
signedtest10	1.0000000009	1.0000000009
signedtest10	-1.0000000009	-1.0000000009
signedtest10	0.0000000000	0.0000000000
signedtest10	NULL	NULL
SELECT "signedtest10", d1, d2 FROM cs3;
signedtest10	d1	d2
signedtest10	0.12500000000000000000000000000000000000	0.1250000000000000000
signedtest10	-0.12500000000000000000000000000000000000	-0.1250000000000000000
signedtest10	0.99999999999999999980000000000000000000	0.9999999999999999998
signedtest10	0.99999999999999999990000000000000000000	0.9999999999999999999
signedtest10	-0.99999999999999999999999999999999999998	-0.9999999999999999998
signedtest10	-0.99999999999999999999999999999999999999	-0.9999999999999999999
signedtest10	0.12345678901234567890000000000000000000	0.1234567890123456789
signedtest10	0.19999999999999999990000000000000000000	0.1999999999999999999
signedtest10	-0.12345678901234567890123456789012345678	-0.1234567890123456789
signedtest10	-0.19999999999999999999999999999999999999	-0.1999999999999999999
signedtest10	0.00000000000000000000000000000000000009	0.0000000000000000009
signedtest10	-0.00000000000000000090000000000000000000	-0.0000000000000000009
signedtest10	0.00000000000000000000000000000000000000	0.0000000000000000000
signedtest10	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789;
SELECT "unsignedtest1", d1, d2 FROM cs4;
unsignedtest1	d1	d2
unsignedtest1	12345678901234567890123456789012345678	1234567890123456789
unsignedtest1	12345678901234567890123456789012345678	1234567890123456789
unsignedtest1	12345678901234567890123456789012345678	1234567890123456789
unsignedtest1	12345678901234567890123456789012345678	1234567890123456789
unsignedtest1	12345678901234567890123456789012345678	1234567890123456789
SELECT "unsignedtest1", d1, d2 FROM cs5;
unsignedtest1	d1	d2
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest1	1234567890123456789012345678.9012345678	123456789.0123456789
SELECT "unsignedtest1", d1, d2 FROM cs6;
unsignedtest1	d1	d2
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest1	0.12345678901234567890123456789012345678	0.1234567890123456789
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=0 WHERE d1=99999999999999999999999999999999999998;
UPDATE cs4 SET d1=0, d2=123456789012345678 WHERE d2=9999999999999999999;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=0 WHERE d1=9999999999999999999999999999.9999999998;
UPDATE cs5 SET d1=0, d2=123456789.012345678 WHERE d2=999999999.9999999999;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0 WHERE d1=0.99999999999999999999999999999999999998;
UPDATE cs6 SET d1=0, d2=0.123456789012345678 WHERE d2=0.9999999999999999999;
SELECT "unsignedtest2", d1, d2 FROM cs4;
unsignedtest2	d1	d2
unsignedtest2	125	125
unsignedtest2	12345678901234567890123456789012345678	0
unsignedtest2	0	123456789012345678
unsignedtest2	0	0
unsignedtest2	NULL	NULL
SELECT "unsignedtest2", d1, d2 FROM cs5;
unsignedtest2	d1	d2
unsignedtest2	1.2500000000	1.2500000000
unsignedtest2	1234567890123456789012345678.9012345678	0.0000000000
unsignedtest2	0.0000000000	123456789.0123456780
unsignedtest2	1.1234567891	1.1234567891
unsignedtest2	1.9999999999	1.9999999999
unsignedtest2	1.0000000009	1.0000000009
unsignedtest2	0.0000000000	0.0000000000
unsignedtest2	NULL	NULL
SELECT "unsignedtest2", d1, d2 FROM cs6;
unsignedtest2	d1	d2
unsignedtest2	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest2	0.12345678901234567890123456789012345678	0.0000000000000000000
unsignedtest2	0.00000000000000000000000000000000000000	0.1234567890123456780
unsignedtest2	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest2	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest2	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest2	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest2	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 in (99999999999999999999999999999999999998, 99999999999999999999999999999999999999);
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 in (9999999999999999999999999999.9999999998, 9999999999999999999999999999.9999999999);
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 in (0.99999999999999999999999999999999999998, 0.99999999999999999999999999999999999999);
SELECT "unsignedtest3", d1, d2 FROM cs4;
unsignedtest3	d1	d2
unsignedtest3	125	125
unsignedtest3	12345678901234567890123456789012345678	1234567890123456789
unsignedtest3	12345678901234567890123456789012345678	1234567890123456789
unsignedtest3	0	0
unsignedtest3	NULL	NULL
SELECT "unsignedtest3", d1, d2 FROM cs5;
unsignedtest3	d1	d2
unsignedtest3	1.2500000000	1.2500000000
unsignedtest3	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest3	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest3	1.1234567891	1.1234567891
unsignedtest3	1.9999999999	1.9999999999
unsignedtest3	1.0000000009	1.0000000009
unsignedtest3	0.0000000000	0.0000000000
unsignedtest3	NULL	NULL
SELECT "unsignedtest3", d1, d2 FROM cs6;
unsignedtest3	d1	d2
unsignedtest3	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest3	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest3	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest3	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest3	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest3	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest3	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest3	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 > 99999999999999999999999999999999999998 OR d2 > 9999999999999999998;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 > 9999999999999999999999999999.9999999998 OR d2 > 999999999.9999999998;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 > 0.99999999999999999999999999999999999998 OR d2 > 0.9999999999999999998;
SELECT "unsignedtest4a", d1, d2 FROM cs4;
unsignedtest4a	d1	d2
unsignedtest4a	125	125
unsignedtest4a	99999999999999999999999999999999999998	9999999999999999998
unsignedtest4a	12345678901234567890123456789012345678	1234567890123456789
unsignedtest4a	0	0
unsignedtest4a	NULL	NULL
SELECT "unsignedtest4a", d1, d2 FROM cs5;
unsignedtest4a	d1	d2
unsignedtest4a	1.2500000000	1.2500000000
unsignedtest4a	9999999999999999999999999999.9999999998	999999999.9999999998
unsignedtest4a	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest4a	1.1234567891	1.1234567891
unsignedtest4a	1.9999999999	1.9999999999
unsignedtest4a	1.0000000009	1.0000000009
unsignedtest4a	0.0000000000	0.0000000000
unsignedtest4a	NULL	NULL
SELECT "unsignedtest4a", d1, d2 FROM cs6;
unsignedtest4a	d1	d2
unsignedtest4a	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest4a	0.99999999999999999999999999999999999998	0.9999999999999999998
unsignedtest4a	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest4a	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest4a	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest4a	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest4a	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest4a	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 >= 99999999999999999999999999999999999998 OR d2 >= 9999999999999999998;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 >= 9999999999999999999999999999.9999999998 OR d2 >= 999999999.9999999998;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 >= 0.99999999999999999999999999999999999998 OR d2 >= 0.9999999999999999998;
SELECT "unsignedtest4b", d1, d2 FROM cs4;
unsignedtest4b	d1	d2
unsignedtest4b	125	125
unsignedtest4b	12345678901234567890123456789012345678	1234567890123456789
unsignedtest4b	12345678901234567890123456789012345678	1234567890123456789
unsignedtest4b	0	0
unsignedtest4b	NULL	NULL
SELECT "unsignedtest4b", d1, d2 FROM cs5;
unsignedtest4b	d1	d2
unsignedtest4b	1.2500000000	1.2500000000
unsignedtest4b	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest4b	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest4b	1.1234567891	1.1234567891
unsignedtest4b	1.9999999999	1.9999999999
unsignedtest4b	1.0000000009	1.0000000009
unsignedtest4b	0.0000000000	0.0000000000
unsignedtest4b	NULL	NULL
SELECT "unsignedtest4b", d1, d2 FROM cs6;
unsignedtest4b	d1	d2
unsignedtest4b	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest4b	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest4b	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest4b	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest4b	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest4b	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 is NULL;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 is NULL;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 is NULL;
SELECT "unsignedtest5", d1, d2 FROM cs4;
unsignedtest5	d1	d2
unsignedtest5	125	125
unsignedtest5	99999999999999999999999999999999999998	9999999999999999998
unsignedtest5	99999999999999999999999999999999999999	9999999999999999999
unsignedtest5	0	0
unsignedtest5	12345678901234567890123456789012345678	1234567890123456789
SELECT "unsignedtest5", d1, d2 FROM cs5;
unsignedtest5	d1	d2
unsignedtest5	1.2500000000	1.2500000000
unsignedtest5	9999999999999999999999999999.9999999998	999999999.9999999998
unsignedtest5	9999999999999999999999999999.9999999999	999999999.9999999999
unsignedtest5	1.1234567891	1.1234567891
unsignedtest5	1.9999999999	1.9999999999
unsignedtest5	1.0000000009	1.0000000009
unsignedtest5	0.0000000000	0.0000000000
unsignedtest5	1234567890123456789012345678.9012345678	123456789.0123456789
SELECT "unsignedtest5", d1, d2 FROM cs6;
unsignedtest5	d1	d2
unsignedtest5	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest5	0.99999999999999999999999999999999999998	0.9999999999999999998
unsignedtest5	0.99999999999999999999999999999999999999	0.9999999999999999999
unsignedtest5	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest5	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest5	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest5	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest5	0.12345678901234567890123456789012345678	0.1234567890123456789
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 != 125;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 != 1.25;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 != 0.125;
SELECT "unsignedtest6", d1, d2 FROM cs4;
unsignedtest6	d1	d2
unsignedtest6	125	125
unsignedtest6	12345678901234567890123456789012345678	1234567890123456789
unsignedtest6	12345678901234567890123456789012345678	1234567890123456789
unsignedtest6	12345678901234567890123456789012345678	1234567890123456789
unsignedtest6	NULL	NULL
SELECT "unsignedtest6", d1, d2 FROM cs5;
unsignedtest6	d1	d2
unsignedtest6	1.2500000000	1.2500000000
unsignedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest6	1234567890123456789012345678.9012345678	123456789.0123456789
unsignedtest6	NULL	NULL
SELECT "unsignedtest6", d1, d2 FROM cs6;
unsignedtest6	d1	d2
unsignedtest6	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest6	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest6	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d2=d1 WHERE d1 = d2;
UPDATE cs5 SET d2=d1 WHERE d1 = d2;
UPDATE cs6 SET d2=d1 WHERE d1 = d2;
SELECT "unsignedtest7", d1, d2 FROM cs4;
unsignedtest7	d1	d2
unsignedtest7	125	125
unsignedtest7	99999999999999999999999999999999999998	9999999999999999998
unsignedtest7	99999999999999999999999999999999999999	9999999999999999999
unsignedtest7	0	0
unsignedtest7	NULL	NULL
SELECT "unsignedtest7", d1, d2 FROM cs5;
unsignedtest7	d1	d2
unsignedtest7	1.2500000000	1.2500000000
unsignedtest7	9999999999999999999999999999.9999999998	999999999.9999999998
unsignedtest7	9999999999999999999999999999.9999999999	999999999.9999999999
unsignedtest7	1.1234567891	1.1234567891
unsignedtest7	1.9999999999	1.9999999999
unsignedtest7	1.0000000009	1.0000000009
unsignedtest7	0.0000000000	0.0000000000
unsignedtest7	NULL	NULL
SELECT "unsignedtest7", d1, d2 FROM cs6;
unsignedtest7	d1	d2
unsignedtest7	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest7	0.99999999999999999999999999999999999998	0.9999999999999999998
unsignedtest7	0.99999999999999999999999999999999999999	0.9999999999999999999
unsignedtest7	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest7	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest7	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest7	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest7	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=d2 WHERE d1 != d2;
UPDATE cs5 SET d1=d2 WHERE d1 != d2;
UPDATE cs6 SET d1=d2 WHERE d1 != d2;
SELECT "unsignedtest8", d1, d2 FROM cs4;
unsignedtest8	d1	d2
unsignedtest8	125	125
unsignedtest8	9999999999999999998	9999999999999999998
unsignedtest8	9999999999999999999	9999999999999999999
unsignedtest8	0	0
unsignedtest8	NULL	NULL
SELECT "unsignedtest8", d1, d2 FROM cs5;
unsignedtest8	d1	d2
unsignedtest8	1.2500000000	1.2500000000
unsignedtest8	999999999.9999999998	999999999.9999999998
unsignedtest8	999999999.9999999999	999999999.9999999999
unsignedtest8	1.1234567891	1.1234567891
unsignedtest8	1.9999999999	1.9999999999
unsignedtest8	1.0000000009	1.0000000009
unsignedtest8	0.0000000000	0.0000000000
unsignedtest8	NULL	NULL
SELECT "unsignedtest8", d1, d2 FROM cs6;
unsignedtest8	d1	d2
unsignedtest8	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest8	0.99999999999999999980000000000000000000	0.9999999999999999998
unsignedtest8	0.99999999999999999990000000000000000000	0.9999999999999999999
unsignedtest8	0.12345678901234567890000000000000000000	0.1234567890123456789
unsignedtest8	0.19999999999999999990000000000000000000	0.1999999999999999999
unsignedtest8	0.00000000000000000090000000000000000000	0.0000000000000000009
unsignedtest8	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest8	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=12345678901234567890123456789012345678, d2=1234567890123456789 WHERE d1 < d2;
UPDATE cs5 SET d1=1234567890123456789012345678.9012345678, d2=123456789.0123456789 WHERE d1 < d2;
UPDATE cs6 SET d1=0.12345678901234567890123456789012345678, d2=0.1234567890123456789 WHERE d1 < d2;
SELECT "unsignedtest9", d1, d2 FROM cs4;
unsignedtest9	d1	d2
unsignedtest9	125	125
unsignedtest9	99999999999999999999999999999999999998	9999999999999999998
unsignedtest9	99999999999999999999999999999999999999	9999999999999999999
unsignedtest9	0	0
unsignedtest9	NULL	NULL
SELECT "unsignedtest9", d1, d2 FROM cs5;
unsignedtest9	d1	d2
unsignedtest9	1.2500000000	1.2500000000
unsignedtest9	9999999999999999999999999999.9999999998	999999999.9999999998
unsignedtest9	9999999999999999999999999999.9999999999	999999999.9999999999
unsignedtest9	1.1234567891	1.1234567891
unsignedtest9	1.9999999999	1.9999999999
unsignedtest9	1.0000000009	1.0000000009
unsignedtest9	0.0000000000	0.0000000000
unsignedtest9	NULL	NULL
SELECT "unsignedtest9", d1, d2 FROM cs6;
unsignedtest9	d1	d2
unsignedtest9	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest9	0.99999999999999999999999999999999999998	0.9999999999999999998
unsignedtest9	0.99999999999999999999999999999999999999	0.9999999999999999999
unsignedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest9	0.19999999999999999999999999999999999999	0.1999999999999999999
unsignedtest9	0.12345678901234567890123456789012345678	0.1234567890123456789
unsignedtest9	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest9	NULL	NULL
CALL unsigneddeleteproc();
CALL unsignedinsertproc();
UPDATE cs4 SET d1=d2 WHERE d1 > d2;
UPDATE cs5 SET d1=d2 WHERE d1 > d2;
UPDATE cs6 SET d1=d2 WHERE d1 > d2;
SELECT "unsignedtest10a", d1, d2 FROM cs4;
unsignedtest10a	d1	d2
unsignedtest10a	125	125
unsignedtest10a	9999999999999999998	9999999999999999998
unsignedtest10a	9999999999999999999	9999999999999999999
unsignedtest10a	0	0
unsignedtest10a	NULL	NULL
SELECT "unsignedtest10a", d1, d2 FROM cs5;
unsignedtest10a	d1	d2
unsignedtest10a	1.2500000000	1.2500000000
unsignedtest10a	999999999.9999999998	999999999.9999999998
unsignedtest10a	999999999.9999999999	999999999.9999999999
unsignedtest10a	1.1234567891	1.1234567891
unsignedtest10a	1.9999999999	1.9999999999
unsignedtest10a	1.0000000009	1.0000000009
unsignedtest10a	0.0000000000	0.0000000000
unsignedtest10a	NULL	NULL
SELECT "unsignedtest10a", d1, d2 FROM cs6;
unsignedtest10a	d1	d2
unsignedtest10a	0.12500000000000000000000000000000000000	0.1250000000000000000
unsignedtest10a	0.99999999999999999980000000000000000000	0.9999999999999999998
unsignedtest10a	0.99999999999999999990000000000000000000	0.9999999999999999999
unsignedtest10a	0.12345678901234567890000000000000000000	0.1234567890123456789
unsignedtest10a	0.19999999999999999990000000000000000000	0.1999999999999999999
unsignedtest10a	0.00000000000000000000000000000000000009	0.0000000000000000009
unsignedtest10a	0.00000000000000000000000000000000000000	0.0000000000000000000
unsignedtest10a	NULL	NULL
DROP PROCEDURE IF EXISTS signedinsertproc;
DROP PROCEDURE IF EXISTS signeddeleteproc;
DROP PROCEDURE IF EXISTS unsignedinsertproc;
DROP PROCEDURE IF EXISTS unsigneddeleteproc;
DROP DATABASE mcol641_update_db;