List:Commits« Previous MessageNext Message »
From:Alexey Kopytov Date:March 20 2010 6:34pm
Subject:bzr commit into mysql-trunk-bugfixing branch (Alexey.Kopytov:3002)
Bug#8433
View as plain text  
#At file:///data/src/bzr/mysql-trunk-bugfixing/ based on revid:alexey.kopytov@stripped

 3002 Alexey Kopytov	2010-03-20
      Streamlined funcs_1.storedproc broken by the patch for bug #8433.

    modified:
      mysql-test/suite/funcs_1/r/storedproc.result
=== modified file 'mysql-test/suite/funcs_1/r/storedproc.result'
--- a/mysql-test/suite/funcs_1/r/storedproc.result	2010-02-24 12:53:09 +0000
+++ b/mysql-test/suite/funcs_1/r/storedproc.result	2010-03-20 18:34:51 +0000
@@ -16315,10 +16315,7 @@ set f1 = (f1 / 2); set f1 = (f1 * 2); se
 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); se
 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); se
 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); se
 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); se
 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); se
 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); se
 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); se
 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+1
 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
 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+1
 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+
 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
 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.22
 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+
 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+
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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
 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, va
 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,
 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.
 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
 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', 
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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, va
 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, va
 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, va
 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
 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
 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+
 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
 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
 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+
 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
 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
 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+
 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+
 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+
 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+1
 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+
 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+
 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+1
 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+1
 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+
 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+
 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+1
 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+1
 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+1
 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+1
 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+1
 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+
 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+1
 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+1
 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+1
 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+1
 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+
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+1
 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+
 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+1
 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,
 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, 
 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, 
 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,
 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, v
 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, va
 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, v
 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, 
 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;


Attachment: [text/bzr-bundle] bzr/alexey.kopytov@sun.com-20100320183451-ep2sbc2zgnwosnu4.bundle
Thread
bzr commit into mysql-trunk-bugfixing branch (Alexey.Kopytov:3002)Bug#8433Alexey Kopytov20 Mar