summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorAlexey Kopytov <Alexey.Kopytov@Sun.com>2010-03-20 21:34:51 +0300
committerAlexey Kopytov <Alexey.Kopytov@Sun.com>2010-03-20 21:34:51 +0300
commit0a7b4fe1dd09f12162ebff814ba3776e8ac5110f (patch)
tree6dd403f67ada36ff69c3035c8a3a68ca996446a8 /mysql-test
parent72afe82ab98da1c0977d3bfe8fabc2e53d675e43 (diff)
downloadmariadb-git-0a7b4fe1dd09f12162ebff814ba3776e8ac5110f.tar.gz
Streamlined funcs_1.storedproc broken by the patch for bug #8433.
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/suite/funcs_1/r/storedproc.result493
1 files changed, 95 insertions, 398 deletions
diff --git a/mysql-test/suite/funcs_1/r/storedproc.result b/mysql-test/suite/funcs_1/r/storedproc.result
index 1b18298d2f3..082da9938f7 100644
--- a/mysql-test/suite/funcs_1/r/storedproc.result
+++ b/mysql-test/suite/funcs_1/r/storedproc.result
@@ -16315,10 +16315,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
return f1;
END//
SELECT fn4(-9.22e+15);
-fn4(-9.22e+15)
-0
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP FUNCTION IF EXISTS fn5;
CREATE FUNCTION fn5( f1 decimal) returns decimal
BEGIN
@@ -16854,11 +16851,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
return f1;
END//
SELECT fn56(-8388601);
-fn56(-8388601)
-16777215
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP FUNCTION IF EXISTS fn57;
CREATE FUNCTION fn57( f1 numeric) returns numeric
BEGIN
@@ -17157,11 +17150,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
return f1;
END//
SELECT fn84(-32601);
-fn84(-32601)
-65535
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP FUNCTION IF EXISTS fn85;
CREATE FUNCTION fn85( f1 tinyint) returns tinyint
BEGIN
@@ -17196,11 +17185,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
return f1;
END//
SELECT fn88(-101);
-fn88(-101)
-255
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP FUNCTION IF EXISTS fn89;
CREATE FUNCTION fn89( f1 enum('1enum', '2enum')) returns enum('1enum', '2enum')
BEGIN
@@ -17425,10 +17410,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
SELECT f1;
END//
CALL sp4(-9.22e+15);
-f1
-00000000000000000000
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE IF EXISTS sp5;
CREATE PROCEDURE sp5( f1 decimal)
BEGIN
@@ -17985,11 +17967,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
SELECT f1;
END//
CALL sp56(-8388601);
-f1
-16777215
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE IF EXISTS sp57;
CREATE PROCEDURE sp57( f1 numeric)
BEGIN
@@ -18321,11 +18299,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
SELECT f1;
END//
CALL sp84(-32601);
-f1
-65535
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE IF EXISTS sp85;
CREATE PROCEDURE sp85( f1 tinyint)
BEGIN
@@ -18360,11 +18334,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); set f1 = (f1 - 10); set f1 = (f1 + 10);
SELECT f1;
END//
CALL sp88(-101);
-f1
-255
-Warnings:
-Warning 1264 Out of range value for column 'f1' at row 1
-Warning 1264 Out of range value for column 'f1' at row 1
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE IF EXISTS sp89;
CREATE PROCEDURE sp89( f1 enum('1enum', '2enum'))
BEGIN
@@ -18691,10 +18661,7 @@ CALL sp4(-9.22e+18, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute04();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-6744073709551616 6744073709551616 -9220000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f1@0 * 2)'
DROP PROCEDURE spexecute04;
DROP PROCEDURE sp4;
DROP PROCEDURE IF EXISTS sp6;
@@ -18807,22 +18774,7 @@ f7 f8 f9
-9220000000000000000 -9220000000000000000 NULL
f10 f11 f12
-9220000000000000000 -9220000000000000000 NULL
-f1 f2 f3
-18353255926290448384 18353255926290448384 18353255926290448384
-f4 f5 f6
--9220000000000000000 6744073709551616 6744073709551616
-f7 f8 f9
--9220000000000000000 6744073709551616 6744073709551616
-f10 f11 f12
--9220000000000000000 6744073709551616 6744073709551616
-var1 var2
-18353255926290448384 18353255926290448384
-var3 var4
-6744073709551616 6744073709551616
-var5 var6
-6744073709551616 6744073709551616
-var7 var8
-6744073709551616 6744073709551616
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 * 2)'
DROP PROCEDURE spexecute07;
DROP PROCEDURE sp07;
DROP PROCEDURE IF EXISTS sp8;
@@ -18873,10 +18825,7 @@ CALL sp8(1.84e+17, var1, var2, -9.22e+18, var3, var4,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute08();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-00368000000000000000 00368000000000000000 00368000000000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-00368000000000000000 00368000000000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute08;
DROP PROCEDURE sp8;
DROP PROCEDURE IF EXISTS sp9;
@@ -18927,10 +18876,7 @@ CALL sp9(-9.22e+15, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute09();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-00000000000000000000 00000000000000000000 00000000000000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-00000000000000000000 00000000000000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE spexecute09;
DROP PROCEDURE sp9;
DROP PROCEDURE IF EXISTS sp10;
@@ -18973,10 +18919,7 @@ CALL sp10(-1.00e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute10();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--1000000000 -1000000000 -999999990 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--1000000000 -999999990 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute10;
DROP PROCEDURE sp10;
DROP PROCEDURE IF EXISTS sp11;
@@ -19008,10 +18951,7 @@ CALL sp11(--1.00e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute11();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1000000000 1000000000 1000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1000000000 1000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute11;
DROP PROCEDURE sp11;
DROP PROCEDURE IF EXISTS sp12;
@@ -19043,10 +18983,7 @@ CALL sp12(99999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute12();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-9999999999 9999999999 9999999999 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-9999999999 9999999999 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute12;
DROP PROCEDURE sp12;
DROP PROCEDURE IF EXISTS sp13;
@@ -19078,10 +19015,7 @@ CALL sp13(-1.00e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute13();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000010 0000000010 0000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000010 0000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute13;
DROP PROCEDURE sp13;
DROP PROCEDURE IF EXISTS sp14;
@@ -19113,10 +19047,7 @@ CALL sp14(-1.00e+21, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute14();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--1000000000000000000000.000000000000000000000000000000 -1000000000000000000000.000000000000000000000000000000 -999999999999999999990.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--1000000000000000000000.000000000000000000000000000000 -999999999999999999990.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute14;
DROP PROCEDURE sp14;
DROP PROCEDURE IF EXISTS sp15;
@@ -19147,10 +19078,7 @@ CALL sp15(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute15();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1 1 11 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1 11 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute15;
DROP PROCEDURE sp15;
DROP PROCEDURE IF EXISTS sp16;
@@ -19181,10 +19109,7 @@ CALL sp16(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute16();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000010 0000000000000000000010 0000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000010 0000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute16;
DROP PROCEDURE sp16;
DROP PROCEDURE IF EXISTS sp17;
@@ -19215,10 +19140,7 @@ CALL sp17(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute17();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute17;
DROP PROCEDURE sp17;
DROP PROCEDURE IF EXISTS sp18;
@@ -19249,10 +19171,7 @@ CALL sp18(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute18();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000010 0000000000000000000010 0000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000010 0000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute18;
DROP PROCEDURE sp18;
DROP PROCEDURE IF EXISTS sp19;
@@ -19283,10 +19202,7 @@ CALL sp19(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute19();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute19;
DROP PROCEDURE sp19;
DROP PROCEDURE IF EXISTS sp20;
@@ -19317,10 +19233,7 @@ CALL sp20(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute20();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute20;
DROP PROCEDURE sp20;
DROP PROCEDURE IF EXISTS sp21;
@@ -19351,10 +19264,7 @@ CALL sp21(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute21();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute21;
DROP PROCEDURE sp21;
DROP PROCEDURE IF EXISTS sp22;
@@ -19385,10 +19295,7 @@ CALL sp22(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute22();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1 1 11 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1 11 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute22;
DROP PROCEDURE sp22;
DROP PROCEDURE IF EXISTS sp23;
@@ -19419,10 +19326,7 @@ CALL sp23(-999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute23();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--1000000000 -1000000000 -999999990 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--1000000000 -999999990 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute23;
DROP PROCEDURE sp23;
DROP PROCEDURE IF EXISTS sp24;
@@ -19453,10 +19357,7 @@ CALL sp24(1.1, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute24();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1.0999999999999996 1.0999999999999996 11.1 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1.0999999999999996 11.1 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute24;
DROP PROCEDURE sp24;
DROP PROCEDURE IF EXISTS sp25;
@@ -19487,10 +19388,7 @@ CALL sp25(-32701, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.2
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute25();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--32758 -32758 -32748 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--32758 -32748 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute25;
DROP PROCEDURE sp25;
DROP PROCEDURE IF EXISTS sp26;
@@ -19521,10 +19419,7 @@ CALL sp26( '1997-12-31', var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute26();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1998-01-31 1998-01-31 1998-03-03 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1998-01-31 1998-03-03 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute26;
DROP PROCEDURE sp26;
DROP PROCEDURE IF EXISTS sp27;
@@ -19555,10 +19450,7 @@ CALL sp27( '23:59:59.999999', var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute27();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-25:59:59 25:59:59 27:59:59 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-25:59:59 27:59:59 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute27;
DROP PROCEDURE sp27;
DROP PROCEDURE IF EXISTS sp28;
@@ -19589,10 +19481,7 @@ CALL sp28('1997-12-31 23:59:59.999999', var1, var2, -9.22e+18, var3, var4, -9.22
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute28();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1998-01-02 01:01:00 1998-01-02 01:01:00 1998-01-03 02:02:01 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1998-01-02 01:01:00 1998-01-03 02:02:01 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute28;
DROP PROCEDURE sp28;
DROP PROCEDURE IF EXISTS sp29;
@@ -19623,10 +19512,7 @@ CALL sp29(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute29();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute29;
DROP PROCEDURE sp29;
DROP PROCEDURE IF EXISTS sp30;
@@ -19657,10 +19543,7 @@ CALL sp30(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute30();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute30;
DROP PROCEDURE sp30;
DROP PROCEDURE IF EXISTS sp31;
@@ -19691,10 +19574,7 @@ CALL sp31(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute31();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1 1 11 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1 11 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute31;
DROP PROCEDURE sp31;
DROP PROCEDURE IF EXISTS sp32;
@@ -19725,10 +19605,7 @@ CALL sp32(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute32();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute32;
DROP PROCEDURE sp32;
DROP PROCEDURE IF EXISTS sp33;
@@ -19759,10 +19636,7 @@ CALL sp33(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute33();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute33;
DROP PROCEDURE sp33;
DROP PROCEDURE IF EXISTS sp34;
@@ -19793,10 +19667,7 @@ CALL sp34(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute34();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1 1 11 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1 11 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute34;
DROP PROCEDURE sp34;
DROP PROCEDURE IF EXISTS sp35;
@@ -19827,10 +19698,7 @@ CALL sp35(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute35();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute35;
DROP PROCEDURE sp35;
DROP PROCEDURE IF EXISTS sp36;
@@ -19861,10 +19729,7 @@ CALL sp36(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute36();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute36;
DROP PROCEDURE sp36;
DROP PROCEDURE IF EXISTS sp37;
@@ -19895,10 +19760,7 @@ CALL sp37(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute37();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1 1 11 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1 11 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute37;
DROP PROCEDURE sp37;
DROP PROCEDURE IF EXISTS sp38;
@@ -19929,10 +19791,7 @@ CALL sp38(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute38();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute38;
DROP PROCEDURE sp38;
DROP PROCEDURE IF EXISTS sp39;
@@ -19963,10 +19822,7 @@ CALL sp39(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute39();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000010 0000000000000000000010 0000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000010 0000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute39;
DROP PROCEDURE sp39;
DROP PROCEDURE IF EXISTS sp40;
@@ -19997,10 +19853,7 @@ CALL sp40(1.1, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute40();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute40;
DROP PROCEDURE sp40;
DROP PROCEDURE IF EXISTS sp41;
@@ -20031,10 +19884,7 @@ CALL sp41(1.1, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute41();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000010 0000000000000000000010 0000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000010 0000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute41;
DROP PROCEDURE sp41;
DROP PROCEDURE IF EXISTS sp42;
@@ -20065,10 +19915,7 @@ CALL sp42(1.1, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute42();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000010 0000000000000000000010 0000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000010 0000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute42;
DROP PROCEDURE sp42;
DROP PROCEDURE IF EXISTS sp43;
@@ -20099,10 +19946,7 @@ CALL sp43(-999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute43();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--1000000000 -1000000000 -999999990 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--1000000000 -999999990 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute43;
DROP PROCEDURE sp43;
DROP PROCEDURE IF EXISTS sp44;
@@ -20133,10 +19977,7 @@ CALL sp44(9999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute44();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-9999999999 9999999999 9999999999 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-9999999999 9999999999 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute44;
DROP PROCEDURE sp44;
DROP PROCEDURE IF EXISTS sp45;
@@ -20167,10 +20008,7 @@ CALL sp45(-99999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute45();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000010 0000000010 0000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000010 0000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute45;
DROP PROCEDURE sp45;
DROP PROCEDURE IF EXISTS sp46;
@@ -20201,10 +20039,7 @@ CALL sp46(-999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute46();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--1000000000 -1000000000 -999999990 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--1000000000 -999999990 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute46;
DROP PROCEDURE sp46;
DROP PROCEDURE IF EXISTS sp47;
@@ -20235,10 +20070,7 @@ CALL sp47(9999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute47();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-9999999999 9999999999 9999999999 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-9999999999 9999999999 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute47;
DROP PROCEDURE sp47;
DROP PROCEDURE IF EXISTS sp48;
@@ -20269,10 +20101,7 @@ CALL sp48(-99999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute48();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000010 0000000010 0000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000010 0000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute48;
DROP PROCEDURE sp48;
DROP PROCEDURE IF EXISTS sp49;
@@ -20303,10 +20132,7 @@ CALL sp49(-999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute49();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute49;
DROP PROCEDURE sp49;
DROP PROCEDURE IF EXISTS sp50;
@@ -20337,10 +20163,7 @@ CALL sp50(9999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6,
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute50();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-9999999999 9999999999 9999999999 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-9999999999 9999999999 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute50;
DROP PROCEDURE sp50;
DROP PROCEDURE IF EXISTS sp51;
@@ -20371,10 +20194,7 @@ CALL sp51(-99999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute51();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000010 0000000010 0000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000010 0000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute51;
DROP PROCEDURE sp51;
DROP PROCEDURE IF EXISTS sp52;
@@ -20405,10 +20225,7 @@ CALL sp52(-1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute52();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--100000000000000000000.000000000000000000000000000000 -10000000000000000000000.000000000000000000000000000000 -99999999999999999990.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--10000000000000000000000.000000000000000000000000000000 -99999999999999999990.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute52;
DROP PROCEDURE sp52;
DROP PROCEDURE IF EXISTS sp53;
@@ -20439,10 +20256,7 @@ CALL sp53(-1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute53();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--100000000000000000000 -10000000000000000000000 -99999999999999999990 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--10000000000000000000000 -99999999999999999990 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute53;
DROP PROCEDURE sp53;
DROP PROCEDURE IF EXISTS sp54;
@@ -20473,10 +20287,7 @@ CALL sp54(1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute54();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-100000000000000000000 10000000000000000000000 100000000000000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10000000000000000000000 100000000000000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute54;
DROP PROCEDURE sp54;
DROP PROCEDURE IF EXISTS sp55;
@@ -20507,10 +20318,7 @@ CALL sp55(-1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute55();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000000000000000000000000000000000000000000000010 0000000000000000000000000000000000000000000000000000000000000010 0000000000000000000000000000000000000000000000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000000000000000000000000000000000000000000000010 0000000000000000000000000000000000000000000000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute55;
DROP PROCEDURE sp55;
DROP PROCEDURE IF EXISTS sp56;
@@ -20847,10 +20655,7 @@ CALL sp65(999999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute65();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-1000000000 1000000000 1000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-1000000000 1000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute65;
DROP PROCEDURE sp65;
DROP PROCEDURE IF EXISTS sp66;
@@ -20881,10 +20686,7 @@ CALL sp66(1.00e+16, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute66();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10000000000000000.000000000000000000000000000000 10000000000000000.000000000000000000000000000000 10000000000000010.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10000000000000000.000000000000000000000000000000 10000000000000010.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute66;
DROP PROCEDURE sp66;
DROP PROCEDURE IF EXISTS sp67;
@@ -20915,10 +20717,7 @@ CALL sp67(1.00e+16, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute67();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000000000010000000000000000.000000000000000000000000000000 000000000000000010000000000000000.000000000000000000000000000000 000000000000000010000000000000010.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000000000010000000000000000.000000000000000000000000000000 000000000000000010000000000000010.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute67;
DROP PROCEDURE sp67;
DROP PROCEDURE IF EXISTS sp68;
@@ -20949,10 +20748,7 @@ CALL sp68(-1.00e+21, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute68();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000000000000000000000000010.000000000000000000000000000000 000000000000000000000000000000010.000000000000000000000000000000 000000000000000000000000000000020.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000000000000000000000000010.000000000000000000000000000000 000000000000000000000000000000020.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute68;
DROP PROCEDURE sp68;
DROP PROCEDURE IF EXISTS sp69;
@@ -20983,10 +20779,7 @@ CALL sp69(-1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute69();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--100000000000000000000 -10000000000000000000000 -99999999999999999990 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--10000000000000000000000 -99999999999999999990 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute69;
DROP PROCEDURE sp69;
DROP PROCEDURE IF EXISTS sp70;
@@ -21017,10 +20810,7 @@ CALL sp70(1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute70();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-100000000000000000000 10000000000000000000000 100000000000000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10000000000000000000000 100000000000000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute70;
DROP PROCEDURE sp70;
DROP PROCEDURE IF EXISTS sp71;
@@ -21051,10 +20841,7 @@ CALL sp71(1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute71();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000000000000000000000000000100000000000000000000 0000000000000000000000000000000000000000010000000000000000000000 0000000000000000000000000000000000000000000100000000000000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000000000000000000000000010000000000000000000000 0000000000000000000000000000000000000000000100000000000000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute71;
DROP PROCEDURE sp71;
DROP PROCEDURE IF EXISTS sp72;
@@ -21085,10 +20872,7 @@ CALL sp72(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute72();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000000000000000000000000000000000000000000000010 0000000000000000000000000000000000000000000000000000000000000010 0000000000000000000000000000000000000000000000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000000000000000000000000000000000000000000000010 0000000000000000000000000000000000000000000000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute72;
DROP PROCEDURE sp72;
DROP PROCEDURE IF EXISTS sp73;
@@ -21119,10 +20903,7 @@ CALL sp73(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute73();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-10 10 20 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10 20 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute73;
DROP PROCEDURE sp73;
DROP PROCEDURE IF EXISTS sp74;
@@ -21153,10 +20934,7 @@ CALL sp74(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute74();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000010 0000000010 0000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000010 0000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute74;
DROP PROCEDURE sp74;
DROP PROCEDURE IF EXISTS sp75;
@@ -21187,10 +20965,7 @@ CALL sp75(-1.00e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute75();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000010 0000000010 0000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000010 0000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute75;
DROP PROCEDURE sp75;
DROP PROCEDURE IF EXISTS sp76;
@@ -21221,10 +20996,7 @@ CALL sp76(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute76();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute76;
DROP PROCEDURE sp76;
DROP PROCEDURE IF EXISTS sp77;
@@ -21255,10 +21027,7 @@ CALL sp77(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute77();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute77;
DROP PROCEDURE sp77;
DROP PROCEDURE IF EXISTS sp78;
@@ -21289,10 +21058,7 @@ CALL sp78(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute78();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000010 000000000010 000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010 000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute78;
DROP PROCEDURE sp78;
DROP PROCEDURE IF EXISTS sp79;
@@ -21323,10 +21089,7 @@ CALL sp79(1.00e+00, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute79();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000010 0000000000000000000010 0000000000000000000020 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000010 0000000000000000000020 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute79;
DROP PROCEDURE sp79;
DROP PROCEDURE IF EXISTS sp80;
@@ -21357,10 +21120,7 @@ CALL sp80(-2.15e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute80();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--2147483638 -2147483638 -2147483628 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--2147483638 -2147483628 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute80;
DROP PROCEDURE sp80;
DROP PROCEDURE IF EXISTS sp81;
@@ -21391,10 +21151,7 @@ CALL sp81(4.29e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute81();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-4290000000 4290000000 4290000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-4290000000 4290000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute81;
DROP PROCEDURE sp81;
DROP PROCEDURE IF EXISTS sp82;
@@ -21425,10 +21182,7 @@ CALL sp82(4.29e+09, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute82();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-4290000000 4290000000 4290000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-4290000000 4290000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute82;
DROP PROCEDURE sp82;
DROP PROCEDURE IF EXISTS sp83;
@@ -21459,10 +21213,7 @@ CALL sp83(2.15e+08, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute83();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0215000000 0215000000 0215000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0215000000 0215000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute83;
DROP PROCEDURE sp83;
DROP PROCEDURE IF EXISTS sp84;
@@ -21493,10 +21244,7 @@ CALL sp84(-8388600, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute84();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--8388598 -8388598 -8388588 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--8388598 -8388588 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute84;
DROP PROCEDURE sp84;
DROP PROCEDURE IF EXISTS sp85;
@@ -21527,10 +21275,7 @@ CALL sp85(16777201, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute85();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-16777202 16777202 16777212 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-16777202 16777212 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute85;
DROP PROCEDURE sp85;
DROP PROCEDURE IF EXISTS sp86;
@@ -21561,10 +21306,7 @@ CALL sp86(16777210, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute86();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-16777210 16777210 16777215 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-16777210 16777215 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute86;
DROP PROCEDURE sp86;
DROP PROCEDURE IF EXISTS sp87;
@@ -21595,10 +21337,7 @@ CALL sp87(-8388601, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute87();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-16777215 16777215 16777215 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-16777215 16777215 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE spexecute87;
DROP PROCEDURE sp87;
DROP PROCEDURE IF EXISTS sp88;
@@ -21629,10 +21368,7 @@ CALL sp88(99999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute88();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0100000000 0100000000 0100000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0100000000 0100000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute88;
DROP PROCEDURE sp88;
DROP PROCEDURE IF EXISTS sp89;
@@ -21663,10 +21399,7 @@ CALL sp89(99999999, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute89();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0100000000 0100000000 0100000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0100000000 0100000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute89;
DROP PROCEDURE sp89;
DROP PROCEDURE IF EXISTS sp90;
@@ -21697,10 +21430,7 @@ CALL sp90(1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute90();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-100000000000000000000.000000000000000000000000000000 10000000000000000000000.000000000000000000000000000000 100000000000000000010.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-10000000000000000000000.000000000000000000000000000000 100000000000000000010.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute90;
DROP PROCEDURE sp90;
DROP PROCEDURE IF EXISTS sp91;
@@ -21731,10 +21461,7 @@ CALL sp91(1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute91();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000000100000000000000000000.000000000000000000000000000000 000000000010000000000000000000000.000000000000000000000000000000 000000000000100000000000000000010.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000010000000000000000000000.000000000000000000000000000000 000000000000100000000000000000010.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute91;
DROP PROCEDURE sp91;
DROP PROCEDURE IF EXISTS sp92;
@@ -21765,10 +21492,7 @@ CALL sp92(-1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute92();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-000000000000000000000000000000010.000000000000000000000000000000 000000000000000000000000000000010.000000000000000000000000000000 000000000000000000000000000000020.000000000000000000000000000000 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-000000000000000000000000000000010.000000000000000000000000000000 000000000000000000000000000000020.000000000000000000000000000000 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute92;
DROP PROCEDURE sp92;
DROP PROCEDURE IF EXISTS sp93;
@@ -21799,10 +21523,7 @@ CALL sp93(1.00e+20, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute93();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-0000000000000000000000000000000000000000000100000000000000000000 0000000000000000000000000000000000000000010000000000000000000000 0000000000000000000000000000000000000000000100000000000000000010 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-0000000000000000000000000000000000000000010000000000000000000000 0000000000000000000000000000000000000000000100000000000000000010 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute93;
DROP PROCEDURE sp93;
DROP PROCEDURE IF EXISTS sp94;
@@ -21833,10 +21554,7 @@ CALL sp94(-32701, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.2
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute94();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--32702 -32702 -32692 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--32702 -32692 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute94;
DROP PROCEDURE sp94;
DROP PROCEDURE IF EXISTS sp95;
@@ -21867,10 +21585,7 @@ CALL sp95(65531, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute95();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-65532 65532 65535 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-65532 65535 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute95;
DROP PROCEDURE sp95;
DROP PROCEDURE IF EXISTS sp96;
@@ -21901,10 +21616,7 @@ CALL sp96(65531, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute96();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-65532 65532 65535 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-65532 65535 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute96;
DROP PROCEDURE sp96;
DROP PROCEDURE IF EXISTS sp97;
@@ -21935,10 +21647,7 @@ CALL sp97(-32601, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.2
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute97();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-65535 65535 65535 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-65535 65535 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE spexecute97;
DROP PROCEDURE sp97;
DROP PROCEDURE IF EXISTS sp98;
@@ -21969,10 +21678,7 @@ CALL sp98(-115, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute98();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
--116 -116 -106 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
--116 -106 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute98;
DROP PROCEDURE sp98;
DROP PROCEDURE IF EXISTS sp99;
@@ -22003,10 +21709,7 @@ CALL sp99(251, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e+
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute99();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-252 252 255 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-252 255 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute99;
DROP PROCEDURE sp99;
DROP PROCEDURE IF EXISTS sp100;
@@ -22037,10 +21740,7 @@ CALL sp100(201, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22e
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute100();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-202 202 212 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-202 212 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT value is out of range in '(f5@4 * 2)'
DROP PROCEDURE spexecute100;
DROP PROCEDURE sp100;
DROP PROCEDURE IF EXISTS sp101;
@@ -22071,10 +21771,7 @@ CALL sp101(-101, var1, var2, -9.22e+18, var3, var4, -9.22e+18, var5, var6, -9.22
SELECT var1, var2, var3, var4, var5, var6, var7, var8;
END//
CALL spexecute101();
-f1 f2 f3 f4 f5 f6 f7 f8 f9 f10 f11 f12
-255 255 255 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616 -9220000000000000000 6744073709551616 6744073709551616
-var1 var2 var3 var4 var5 var6 var7 var8
-255 255 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616 6744073709551616
+ERROR 22003: BIGINT UNSIGNED value is out of range in '(f1@0 - 10)'
DROP PROCEDURE spexecute101;
DROP PROCEDURE sp101;
USE db_storedproc;
View Lorry Controller Status