http://git-wip-us.apache.org/repos/asf/trafodion/blob/319abf81/core/sql/regress/executor/EXPECTED022.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/EXPECTED022.SB b/core/sql/regress/executor/EXPECTED022.SB index b3b566e..bfa0c4f 100644 --- a/core/sql/regress/executor/EXPECTED022.SB +++ b/core/sql/regress/executor/EXPECTED022.SB @@ -1,11 +1,5 @@ >>obey TEST022 (test); >>------------------------------------------------------------------------------- ->>create table t022t1 (a int); - ---- SQL operation complete. ->>create table t022t2 (a int); - ---- SQL operation complete. >>create table t022t3 (a int unsigned); --- SQL operation complete. @@ -13,12 +7,6 @@ --- SQL operation complete. >> ->>insert into t022t1 values (1); - ---- 1 row(s) inserted. ->>insert into t022t2 values (1), (2); - ---- 2 row(s) inserted. >>insert into t022t3 values (4294967295), (3000000000); --- 2 row(s) inserted. @@ -26,18 +14,10 @@ --- 1 row(s) inserted. >> ->>?ifMX ->>create table t022u (a int); - ---- SQL operation complete. ->>insert into t022u values (1), (2); - ---- 2 row(s) inserted. >>create table t022a7 (c1 float(22), c2 float not null); --- SQL operation complete. ->>?ifNT ->>-- The ifNT setting is also enabled when run on Linux platforms. +>> >>prepare insertIntoT022A7 from insert into t022a7 values (?,?); --- SQL command prepared. @@ -50,17 +30,10 @@ >>sh sh -c 'echo "execute insertIntoT022A7 using 1 , 2.E3 ; " >> t022xxx >>'; >>sh sh -c 'echo "execute insertIntoT022A7 using 3 , 123.456E2 ; " >> t022xxx >>'; >>sh sh -c 'echo "commit work;" >> t022xxx >>'; ->>?ifNT ->>?ifNSK ->>sh echo 0 , 1. > t022xxx; ->>sh echo 1 , 2.E3 >> t022xxx; ->>sh echo 3 , 123.456E2 >> t022xxx; ->>?ifNSK ->>?ifMX >> >>-- Positive cases to test the limits of each data type. >> ->>select cast (-9 as numeric(1)) from t022t1; +>>select cast (-9 as numeric(1)) from dual; (EXPR) ------ @@ -68,7 +41,7 @@ -9 --- 1 row(s) selected. ->>select cast (9 as numeric(1)) from t022t1; +>>select cast (9 as numeric(1)) from dual; (EXPR) ------ @@ -76,7 +49,7 @@ 9 --- 1 row(s) selected. ->>select cast (-9999 as numeric(4)) from t022t1; +>>select cast (-9999 as numeric(4)) from dual; (EXPR) ------ @@ -84,7 +57,7 @@ -9999 --- 1 row(s) selected. ->>select cast (9999 as numeric(4)) from t022t1; +>>select cast (9999 as numeric(4)) from dual; (EXPR) ------ @@ -92,7 +65,7 @@ 9999 --- 1 row(s) selected. ->>select cast (-32768 as smallint) from t022t1; +>>select cast (-32768 as smallint) from dual; (EXPR) ------ @@ -100,7 +73,7 @@ -32768 --- 1 row(s) selected. ->>select cast (32767 as smallint) from t022t1; +>>select cast (32767 as smallint) from dual; (EXPR) ------ @@ -109,7 +82,7 @@ --- 1 row(s) selected. >> ->>select cast (0 as numeric(1) unsigned) from t022t1; +>>select cast (0 as numeric(1) unsigned) from dual; (EXPR) ------ @@ -117,7 +90,7 @@ 0 --- 1 row(s) selected. ->>select cast (9 as numeric(1) unsigned) from t022t1; +>>select cast (9 as numeric(1) unsigned) from dual; (EXPR) ------ @@ -125,7 +98,7 @@ 9 --- 1 row(s) selected. ->>select cast (0 as numeric(4) unsigned) from t022t1; +>>select cast (0 as numeric(4) unsigned) from dual; (EXPR) ------ @@ -133,7 +106,7 @@ 0 --- 1 row(s) selected. ->>select cast (9999 as numeric(4) unsigned) from t022t1; +>>select cast (9999 as numeric(4) unsigned) from dual; (EXPR) ------ @@ -141,7 +114,7 @@ 9999 --- 1 row(s) selected. ->>select cast (0 as smallint unsigned) from t022t1; +>>select cast (0 as smallint unsigned) from dual; (EXPR) ------ @@ -149,7 +122,7 @@ 0 --- 1 row(s) selected. ->>select cast (65535 as smallint unsigned) from t022t1; +>>select cast (65535 as smallint unsigned) from dual; (EXPR) ------ @@ -158,7 +131,7 @@ --- 1 row(s) selected. >> ->>select cast (-99999 as numeric(5)) from t022t1; +>>select cast (-99999 as numeric(5)) from dual; (EXPR) ----------- @@ -166,7 +139,7 @@ -99999 --- 1 row(s) selected. ->>select cast (99999 as numeric(5)) from t022t1; +>>select cast (99999 as numeric(5)) from dual; (EXPR) ----------- @@ -174,7 +147,7 @@ 99999 --- 1 row(s) selected. ->>select cast (-999999999 as numeric(9)) from t022t1; +>>select cast (-999999999 as numeric(9)) from dual; (EXPR) ----------- @@ -182,7 +155,7 @@ -999999999 --- 1 row(s) selected. ->>select cast (999999999 as numeric(9)) from t022t1; +>>select cast (999999999 as numeric(9)) from dual; (EXPR) ----------- @@ -190,7 +163,7 @@ 999999999 --- 1 row(s) selected. ->>select cast (-2147483648 as int) from t022t1; +>>select cast (-2147483648 as int) from dual; (EXPR) ----------- @@ -198,7 +171,7 @@ -2147483648 --- 1 row(s) selected. ->>select cast (2147483647 as int) from t022t1; +>>select cast (2147483647 as int) from dual; (EXPR) ----------- @@ -207,7 +180,7 @@ --- 1 row(s) selected. >> ->>select cast (0 as numeric(5) unsigned) from t022t1; +>>select cast (0 as numeric(5) unsigned) from dual; (EXPR) ---------- @@ -215,7 +188,7 @@ 0 --- 1 row(s) selected. ->>select cast (99999 as numeric(5) unsigned) from t022t1; +>>select cast (99999 as numeric(5) unsigned) from dual; (EXPR) ---------- @@ -223,7 +196,7 @@ 99999 --- 1 row(s) selected. ->>select cast (0 as numeric(9) unsigned) from t022t1; +>>select cast (0 as numeric(9) unsigned) from dual; (EXPR) ---------- @@ -231,7 +204,7 @@ 0 --- 1 row(s) selected. ->>select cast (999999999 as numeric(9) unsigned) from t022t1; +>>select cast (999999999 as numeric(9) unsigned) from dual; (EXPR) ---------- @@ -239,7 +212,7 @@ 999999999 --- 1 row(s) selected. ->>select cast (0 as int unsigned) from t022t1; +>>select cast (0 as int unsigned) from dual; (EXPR) ---------- @@ -247,7 +220,7 @@ 0 --- 1 row(s) selected. ->>select cast (4294967295 as int unsigned) from t022t1; +>>select cast (4294967295 as int unsigned) from dual; (EXPR) ---------- @@ -256,7 +229,7 @@ --- 1 row(s) selected. >> ->>select cast (-9999999999 as numeric(10)) from t022t1; +>>select cast (-9999999999 as numeric(10)) from dual; (EXPR) -------------------- @@ -264,7 +237,7 @@ -9999999999 --- 1 row(s) selected. ->>select cast (9999999999 as numeric(10)) from t022t1; +>>select cast (9999999999 as numeric(10)) from dual; (EXPR) -------------------- @@ -272,7 +245,7 @@ 9999999999 --- 1 row(s) selected. ->>select cast (-999999999999999999 as numeric(18)) from t022t1; +>>select cast (-999999999999999999 as numeric(18)) from dual; (EXPR) -------------------- @@ -280,7 +253,7 @@ -999999999999999999 --- 1 row(s) selected. ->>select cast (999999999999999999 as numeric(18)) from t022t1; +>>select cast (999999999999999999 as numeric(18)) from dual; (EXPR) -------------------- @@ -288,7 +261,7 @@ 999999999999999999 --- 1 row(s) selected. ->>select cast (-9223372036854775808 as largeint) from t022t1; +>>select cast (-9223372036854775808 as largeint) from dual; (EXPR) -------------------- @@ -296,7 +269,7 @@ -9223372036854775808 --- 1 row(s) selected. ->>select cast (9223372036854775807 as largeint) from t022t1; +>>select cast (9223372036854775807 as largeint) from dual; (EXPR) -------------------- @@ -305,7 +278,7 @@ --- 1 row(s) selected. >> ->>select cast (-9 as decimal(1)) from t022t1; +>>select cast (-9 as decimal(1)) from dual; (EXPR) ------ @@ -313,7 +286,7 @@ -9 --- 1 row(s) selected. ->>select cast (9 as decimal(1)) from t022t1; +>>select cast (9 as decimal(1)) from dual; (EXPR) ------ @@ -321,7 +294,7 @@ 9 --- 1 row(s) selected. ->>select cast (-999999999999999999 as decimal(18)) from t022t1; +>>select cast (-999999999999999999 as decimal(18)) from dual; (EXPR) ------------------- @@ -329,7 +302,7 @@ -999999999999999999 --- 1 row(s) selected. ->>select cast (999999999999999999 as decimal(18)) from t022t1; +>>select cast (999999999999999999 as decimal(18)) from dual; (EXPR) ------------------- @@ -338,7 +311,7 @@ --- 1 row(s) selected. >> ->>select cast (0 as decimal(1) unsigned) from t022t1; +>>select cast (0 as decimal(1) unsigned) from dual; (EXPR) ------ @@ -346,7 +319,7 @@ 0 --- 1 row(s) selected. ->>select cast (9 as decimal(1) unsigned) from t022t1; +>>select cast (9 as decimal(1) unsigned) from dual; (EXPR) ------ @@ -354,7 +327,7 @@ 9 --- 1 row(s) selected. ->>select cast (0 as decimal(9) unsigned) from t022t1; +>>select cast (0 as decimal(9) unsigned) from dual; (EXPR) --------- @@ -362,7 +335,7 @@ 0 --- 1 row(s) selected. ->>select cast (999999999 as decimal(9) unsigned) from t022t1; +>>select cast (999999999 as decimal(9) unsigned) from dual; (EXPR) --------- @@ -371,7 +344,7 @@ --- 1 row(s) selected. >> ->>select cast (10 as tinyint) from t022t1; +>>select cast (10 as tinyint) from dual; (EXPR) ------ @@ -379,7 +352,7 @@ 10 --- 1 row(s) selected. ->>select cast (-10 as tinyint) from t022t1; +>>select cast (-10 as tinyint) from dual; (EXPR) ------ @@ -387,7 +360,7 @@ -10 --- 1 row(s) selected. ->>select cast (127 as tinyint) from t022t1; +>>select cast (127 as tinyint) from dual; (EXPR) ------ @@ -395,7 +368,7 @@ 127 --- 1 row(s) selected. ->>select cast (-128 as tinyint) from t022t1; +>>select cast (-128 as tinyint) from dual; (EXPR) ------ @@ -403,7 +376,7 @@ -128 --- 1 row(s) selected. ->>select cast (10 as tinyint unsigned) from t022t1; +>>select cast (10 as tinyint unsigned) from dual; (EXPR) ------ @@ -411,7 +384,7 @@ 10 --- 1 row(s) selected. ->>select cast (0 as tinyint unsigned) from t022t1; +>>select cast (0 as tinyint unsigned) from dual; (EXPR) ------ @@ -419,7 +392,7 @@ 0 --- 1 row(s) selected. ->>select cast (255 as tinyint unsigned) from t022t1; +>>select cast (255 as tinyint unsigned) from dual; (EXPR) ------ @@ -428,7 +401,7 @@ --- 1 row(s) selected. >> ->>select cast (date'12/31/9999' as timestamp(3)) from t022t1; +>>select cast (date'12/31/9999' as timestamp(3)) from dual; (EXPR) ----------------------- @@ -436,7 +409,7 @@ 9999-12-31 00:00:00.000 --- 1 row(s) selected. ->>select cast (timestamp'12/31/9999 11:59:59.999999 pm' as date) from t022t1; +>>select cast (timestamp'12/31/9999 11:59:59.999999 pm' as date) from dual; (EXPR) ---------- @@ -444,7 +417,7 @@ 9999-12-31 --- 1 row(s) selected. ->>select cast (timestamp'12/31/9999 11:59:59.999999 pm' as time(3)) from t022t1; +>>select cast (timestamp'12/31/9999 11:59:59.999999 pm' as time(3)) from dual; (EXPR) ------------ @@ -453,7 +426,7 @@ --- 1 row(s) selected. >> ->>select interval'0.1'second + timestamp'12/31/9998 11:59:59.9 pm' from t022t1; +>>select interval'0.1'second + timestamp'12/31/9998 11:59:59.9 pm' from dual; (EXPR) --------------------- @@ -461,7 +434,7 @@ 9999-01-01 00:00:00.0 --- 1 row(s) selected. ->>select timestamp'12/31/9998 11:59:59.9 pm' + interval'0.1'second from t022t1; +>>select timestamp'12/31/9998 11:59:59.9 pm' + interval'0.1'second from dual; (EXPR) --------------------- @@ -469,7 +442,7 @@ 9999-01-01 00:00:00.0 --- 1 row(s) selected. ->>select timestamp'01/01/9999 00:00:00.0' + interval-'0.1'second from t022t1; +>>select timestamp'01/01/9999 00:00:00.0' + interval-'0.1'second from dual; (EXPR) --------------------- @@ -477,7 +450,7 @@ 9998-12-31 23:59:59.9 --- 1 row(s) selected. ->>select timestamp'01/01/9999 00:00:00.0' - interval'0.1'second from t022t1; +>>select timestamp'01/01/9999 00:00:00.0' - interval'0.1'second from dual; (EXPR) --------------------- @@ -485,7 +458,7 @@ 9998-12-31 23:59:59.9 --- 1 row(s) selected. ->>select (date'12/31/9999' - date'12/31/9998') day(3) from t022t1; +>>select (date'12/31/9999' - date'12/31/9998') day(3) from dual; (EXPR) ------ @@ -493,7 +466,7 @@ 365 --- 1 row(s) selected. ->>select (date'12/31/9998' - date'12/31/9999') day(3) from t022t1; +>>select (date'12/31/9998' - date'12/31/9999') day(3) from dual; (EXPR) ------ @@ -502,7 +475,7 @@ --- 1 row(s) selected. >> ->>select interval'1'month + timestamp'12/31/9998 11:59:59.999 pm' from t022t1; +>>select interval'1'month + timestamp'12/31/9998 11:59:59.999 pm' from dual; (EXPR) ----------------------- @@ -510,7 +483,7 @@ 9999-01-31 23:59:59.999 --- 1 row(s) selected. ->>select timestamp'12/31/9998 11:59:59.999 pm' + interval'1'month from t022t1; +>>select timestamp'12/31/9998 11:59:59.999 pm' + interval'1'month from dual; (EXPR) ----------------------- @@ -518,7 +491,7 @@ 9999-01-31 23:59:59.999 --- 1 row(s) selected. ->>select timestamp'01/31/9999 11:59:59.999 pm' + interval-'1'month from t022t1; +>>select timestamp'01/31/9999 11:59:59.999 pm' + interval-'1'month from dual; (EXPR) ----------------------- @@ -526,7 +499,7 @@ 9998-12-31 23:59:59.999 --- 1 row(s) selected. ->>select timestamp'01/31/9999 11:59:59.999 pm' - interval'1'month from t022t1; +>>select timestamp'01/31/9999 11:59:59.999 pm' - interval'1'month from dual; (EXPR) ----------------------- @@ -534,32 +507,32 @@ 9998-12-31 23:59:59.999 --- 1 row(s) selected. ->>select (date'12/31/9999' - date'12/31/9998') month from t022t1; +>>select (date'12/31/9999' - date'12/31/9998') month from dual; -*** ERROR[4035] Type INTERVAL DAY(12) cannot be cast to type INTERVAL MONTH(2). +*** ERROR[4035] Type INTERVAL DAY(18) cannot be cast to type INTERVAL MONTH(2). *** ERROR[8822] The statement was not prepared. ->>select (date'12/31/9998' - date'12/31/9999') month from t022t1; +>>select (date'12/31/9998' - date'12/31/9999') month from dual; -*** ERROR[4035] Type INTERVAL DAY(12) cannot be cast to type INTERVAL MONTH(2). +*** ERROR[4035] Type INTERVAL DAY(18) cannot be cast to type INTERVAL MONTH(2). *** ERROR[8822] The statement was not prepared. ->>select (date'12/31/9999' - date'12/31/9998') year to month from t022t1; +>>select (date'12/31/9999' - date'12/31/9998') year to month from dual; -*** ERROR[4035] Type INTERVAL DAY(12) cannot be cast to type INTERVAL YEAR(2) TO MONTH. +*** ERROR[4035] Type INTERVAL DAY(18) cannot be cast to type INTERVAL YEAR(2) TO MONTH. *** ERROR[8822] The statement was not prepared. ->>select (date'12/31/9998' - date'12/31/9999') year to month from t022t1; +>>select (date'12/31/9998' - date'12/31/9999') year to month from dual; -*** ERROR[4035] Type INTERVAL DAY(12) cannot be cast to type INTERVAL YEAR(2) TO MONTH. +*** ERROR[4035] Type INTERVAL DAY(18) cannot be cast to type INTERVAL YEAR(2) TO MONTH. *** ERROR[8822] The statement was not prepared. >> ->>select interval'1'second + time'11:59:59 pm' from t022t1; +>>select interval'1'second + time'11:59:59 pm' from dual; (EXPR) -------- @@ -567,7 +540,7 @@ 00:00:00 --- 1 row(s) selected. ->>select time'11:59:59 pm' + interval'1'second from t022t1; +>>select time'11:59:59 pm' + interval'1'second from dual; (EXPR) -------- @@ -575,7 +548,7 @@ 00:00:00 --- 1 row(s) selected. ->>select time'12:00:00 am' + interval-'1'second from t022t1; +>>select time'12:00:00 am' + interval-'1'second from dual; (EXPR) -------- @@ -583,7 +556,7 @@ 23:59:59 --- 1 row(s) selected. ->>select time'12:00:00 am' - interval'1'second from t022t1; +>>select time'12:00:00 am' - interval'1'second from dual; (EXPR) -------- @@ -592,7 +565,7 @@ --- 1 row(s) selected. >> ->>select timestamp '2015-05-31T10:11:12' from t022t1; +>>select timestamp '2015-05-31T10:11:12' from dual; (EXPR) ------------------- @@ -600,7 +573,7 @@ 2015-05-31 10:11:12 --- 1 row(s) selected. ->>select timestamp '2015-05-31T10:11:12Z' from t022t1; +>>select timestamp '2015-05-31T10:11:12Z' from dual; (EXPR) ------------------- @@ -608,7 +581,7 @@ 2015-05-31 10:11:12 --- 1 row(s) selected. ->>select timestamp '2015-05-31T10:11:12-05:00' from t022t1; +>>select timestamp '2015-05-31T10:11:12-05:00' from dual; (EXPR) ------------------- @@ -616,7 +589,7 @@ 2015-05-31 15:11:12 --- 1 row(s) selected. ->>select timestamp '2015-05-31T10:11:12+05:00' from t022t1; +>>select timestamp '2015-05-31T10:11:12+05:00' from dual; (EXPR) ------------------- @@ -624,7 +597,7 @@ 2015-05-31 05:11:12 --- 1 row(s) selected. ->>select timestamp '2015-05-31T10:11:12.123-05:00' from t022t1; +>>select timestamp '2015-05-31T10:11:12.123-05:00' from dual; (EXPR) ----------------------- @@ -632,7 +605,7 @@ 2015-05-31 15:11:12.123 --- 1 row(s) selected. ->>select timestamp '2015-05-31T10:11:12.123+05:00' from t022t1; +>>select timestamp '2015-05-31T10:11:12.123+05:00' from dual; (EXPR) ----------------------- @@ -641,7 +614,7 @@ --- 1 row(s) selected. >> ->>select cast('2015-05-31T10:11:12' as timestamp) from t022t1; +>>select cast('2015-05-31T10:11:12' as timestamp) from dual; (EXPR) -------------------------- @@ -649,7 +622,7 @@ 2015-05-31 10:11:12.000000 --- 1 row(s) selected. ->>select cast('2015-05-31T10:11:12Z' as timestamp) from t022t1; +>>select cast('2015-05-31T10:11:12Z' as timestamp) from dual; (EXPR) -------------------------- @@ -657,7 +630,7 @@ 2015-05-31 10:11:12.000000 --- 1 row(s) selected. ->>select cast('2015-05-31T10:11:12-05:00' as timestamp) from t022t1; +>>select cast('2015-05-31T10:11:12-05:00' as timestamp) from dual; (EXPR) -------------------------- @@ -665,7 +638,7 @@ 2015-05-31 15:11:12.000000 --- 1 row(s) selected. ->>select cast('2015-05-31T10:11:12+05:00' as timestamp) from t022t1; +>>select cast('2015-05-31T10:11:12+05:00' as timestamp) from dual; (EXPR) -------------------------- @@ -673,7 +646,7 @@ 2015-05-31 05:11:12.000000 --- 1 row(s) selected. ->>select cast('2015-05-31T10:11:12.123-05:00' as timestamp) from t022t1; +>>select cast('2015-05-31T10:11:12.123-05:00' as timestamp) from dual; (EXPR) -------------------------- @@ -681,7 +654,7 @@ 2015-05-31 15:11:12.123000 --- 1 row(s) selected. ->>select cast('2015-05-31T10:11:12.123+05:00' as timestamp) from t022t1; +>>select cast('2015-05-31T10:11:12.123+05:00' as timestamp) from dual; (EXPR) -------------------------- @@ -690,7 +663,7 @@ --- 1 row(s) selected. >> ->>select time '10:11:12' from t022t1; +>>select time '10:11:12' from dual; (EXPR) -------- @@ -698,7 +671,7 @@ 10:11:12 --- 1 row(s) selected. ->>select time '10:11:12Z' from t022t1; +>>select time '10:11:12Z' from dual; (EXPR) -------- @@ -706,7 +679,7 @@ 10:11:12 --- 1 row(s) selected. ->>select time '10:11:12-05:00' from t022t1; +>>select time '10:11:12-05:00' from dual; (EXPR) -------- @@ -714,7 +687,7 @@ 15:11:12 --- 1 row(s) selected. ->>select time '10:11:12+05:00' from t022t1; +>>select time '10:11:12+05:00' from dual; (EXPR) -------- @@ -722,7 +695,7 @@ 05:11:12 --- 1 row(s) selected. ->>select time '10:11:12.123-05:00' from t022t1; +>>select time '10:11:12.123-05:00' from dual; (EXPR) ------------ @@ -730,7 +703,7 @@ 15:11:12.123 --- 1 row(s) selected. ->>select time '10:11:12.123+05:00' from t022t1; +>>select time '10:11:12.123+05:00' from dual; (EXPR) ------------ @@ -739,7 +712,7 @@ --- 1 row(s) selected. >> ->>select cast('10:11:12' as time) from t022t1; +>>select cast('10:11:12' as time) from dual; (EXPR) -------- @@ -747,7 +720,7 @@ 10:11:12 --- 1 row(s) selected. ->>select cast('10:11:12Z' as time) from t022t1; +>>select cast('10:11:12Z' as time) from dual; (EXPR) -------- @@ -755,7 +728,7 @@ 10:11:12 --- 1 row(s) selected. ->>select cast('10:11:12-05:00' as time) from t022t1; +>>select cast('10:11:12-05:00' as time) from dual; (EXPR) -------- @@ -763,7 +736,7 @@ 15:11:12 --- 1 row(s) selected. ->>select cast('10:11:12+05:00' as time) from t022t1; +>>select cast('10:11:12+05:00' as time) from dual; (EXPR) -------- @@ -771,7 +744,7 @@ 05:11:12 --- 1 row(s) selected. ->>select cast('10:11:12.123-05:00' as time) from t022t1; +>>select cast('10:11:12.123-05:00' as time) from dual; (EXPR) -------- @@ -779,7 +752,7 @@ 15:11:12 --- 1 row(s) selected. ->>select cast('10:11:12.123+05:00' as time) from t022t1; +>>select cast('10:11:12.123+05:00' as time) from dual; (EXPR) -------- @@ -788,7 +761,7 @@ --- 1 row(s) selected. >> ->>select time '23:11:06.123' from t022t1; +>>select time '23:11:06.123' from dual; (EXPR) ------------ @@ -796,7 +769,7 @@ 23:11:06.123 --- 1 row(s) selected. ->>select cast ('23:11:06.123' as time(2)) from t022t1; +>>select cast ('23:11:06.123' as time(2)) from dual; (EXPR) ----------- @@ -805,7 +778,7 @@ --- 1 row(s) selected. >> ->>select cast('2010-01-01' as timestamp(3)) from t022t1; +>>select cast('2010-01-01' as timestamp(3)) from dual; (EXPR) ----------------------- @@ -813,7 +786,7 @@ 2010-01-01 00:00:00.000 --- 1 row(s) selected. ->>select cast('2010-01-01 10' as timestamp) from t022t1; +>>select cast('2010-01-01 10' as timestamp) from dual; (EXPR) -------------------------- @@ -841,61 +814,61 @@ A B C --- 1 row(s) selected. >> >>-- negative cases ->>select cast('2016-01-29Z' as date) from t022t1; +>>select cast('2016-01-29Z' as date) from dual; *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 2016-01-29Z --- 0 row(s) selected. ->>select cast('2016-01-29+05:00' as date) from t022t1; +>>select cast('2016-01-29+05:00' as date) from dual; *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 2016-01-29+05:00 --- 0 row(s) selected. ->>select cast('10:11:12-05:000' as time) from t022t1; +>>select cast('10:11:12-05:000' as time) from dual; *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 10:11:12-05:000 --- 0 row(s) selected. ->>select date '2016-01-29Z' from t022t1; +>>select date '2016-01-29Z' from dual; *** ERROR[3045] The date '2016-01-29Z' is not valid. *** ERROR[8822] The statement was not prepared. ->>select date '2016-01-29+05:00' from t022t1; +>>select date '2016-01-29+05:00' from dual; *** ERROR[3045] The date '2016-01-29+05:00' is not valid. *** ERROR[8822] The statement was not prepared. ->>select time '25:11:11' from t022t1; +>>select time '25:11:11' from dual; *** ERROR[3046] The time '25:11:11' is not valid. *** ERROR[8822] The statement was not prepared. ->>select time '23:11:11.1234567' from t022t1; +>>select time '23:11:11.1234567890' from dual; -*** ERROR[3046] The time '23:11:11.1234567' is not valid. +*** ERROR[3046] The time '23:11:11.1234567890' is not valid. *** ERROR[8822] The statement was not prepared. ->>select cast ('23:11:61' as time) from t022t1; +>>select cast ('23:11:61' as time) from dual; *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 23:11:61 --- 0 row(s) selected. ->>select cast ('23:11:06' as timestamp) from t022t1; +>>select cast ('23:11:06' as timestamp) from dual; *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 23:11:06 --- 0 row(s) selected. ->>select cast('2010-01-01' as time) from t022t1; +>>select cast('2010-01-01' as time) from dual; *** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted. Source data: 2010-01-01 --- 0 row(s) selected. ->>select timestamp'2010-01-01 10' from t022t1; +>>select timestamp'2010-01-01 10' from dual; *** ERROR[3047] The timestamp '2010-01-01 10' is not valid. @@ -904,7 +877,7 @@ A B C >> >>-- Prove these cases work since they're used in the succeeding negative >>tests. >> ->>select cast (cast (-10 as smallint) as numeric(2)) from t022t1; +>>select cast (cast (-10 as smallint) as numeric(2)) from dual; (EXPR) ------ @@ -912,7 +885,7 @@ A B C -10 --- 1 row(s) selected. ->>select cast (cast (10 as smallint) as numeric(2)) from t022t1; +>>select cast (cast (10 as smallint) as numeric(2)) from dual; (EXPR) ------ @@ -920,7 +893,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (cast (-10 as numeric(2)) as smallint) from t022t1; +>>select cast (cast (-10 as numeric(2)) as smallint) from dual; (EXPR) ------ @@ -928,7 +901,7 @@ A B C -10 --- 1 row(s) selected. ->>select cast (cast (10 as numeric(2)) as smallint) from t022t1; +>>select cast (cast (10 as numeric(2)) as smallint) from dual; (EXPR) ------ @@ -936,7 +909,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (-1 as smallint) from t022t1; +>>select cast (-1 as smallint) from dual; (EXPR) ------ @@ -945,7 +918,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (32768 as smallint unsigned) from t022t1; +>>select cast (32768 as smallint unsigned) from dual; (EXPR) ------ @@ -953,7 +926,7 @@ A B C 32768 --- 1 row(s) selected. ->>select cast (10 as smallint unsigned) from t022t1; +>>select cast (10 as smallint unsigned) from dual; (EXPR) ------ @@ -962,7 +935,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (-32769 as int) from t022t1; +>>select cast (-32769 as int) from dual; (EXPR) ----------- @@ -970,7 +943,7 @@ A B C -32769 --- 1 row(s) selected. ->>select cast (32768 as int) from t022t1; +>>select cast (32768 as int) from dual; (EXPR) ----------- @@ -978,7 +951,7 @@ A B C 32768 --- 1 row(s) selected. ->>select cast (-10 as int) from t022t1; +>>select cast (-10 as int) from dual; (EXPR) ----------- @@ -986,7 +959,7 @@ A B C -10 --- 1 row(s) selected. ->>select cast (10 as int) from t022t1; +>>select cast (10 as int) from dual; (EXPR) ----------- @@ -994,7 +967,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (-1 as int) from t022t1; +>>select cast (-1 as int) from dual; (EXPR) ----------- @@ -1002,7 +975,7 @@ A B C -1 --- 1 row(s) selected. ->>select cast (65536 as int) from t022t1; +>>select cast (65536 as int) from dual; (EXPR) ----------- @@ -1010,7 +983,7 @@ A B C 65536 --- 1 row(s) selected. ->>select cast (-100000 as int) from t022t1; +>>select cast (-100000 as int) from dual; (EXPR) ----------- @@ -1018,7 +991,7 @@ A B C -100000 --- 1 row(s) selected. ->>select cast (100000 as int) from t022t1; +>>select cast (100000 as int) from dual; (EXPR) ----------- @@ -1027,7 +1000,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (32768 as int unsigned) from t022t1; +>>select cast (32768 as int unsigned) from dual; (EXPR) ---------- @@ -1035,7 +1008,7 @@ A B C 32768 --- 1 row(s) selected. ->>select cast (10 as int unsigned) from t022t1; +>>select cast (10 as int unsigned) from dual; (EXPR) ---------- @@ -1043,7 +1016,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (65536 as int unsigned) from t022t1; +>>select cast (65536 as int unsigned) from dual; (EXPR) ---------- @@ -1051,7 +1024,7 @@ A B C 65536 --- 1 row(s) selected. ->>select cast (2147483648 as int unsigned) from t022t1; +>>select cast (2147483648 as int unsigned) from dual; (EXPR) ---------- @@ -1059,7 +1032,7 @@ A B C 2147483648 --- 1 row(s) selected. ->>select cast (100000 as int unsigned) from t022t1; +>>select cast (100000 as int unsigned) from dual; (EXPR) ---------- @@ -1068,7 +1041,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (-32769 as largeint) from t022t1; +>>select cast (-32769 as largeint) from dual; (EXPR) -------------------- @@ -1076,7 +1049,7 @@ A B C -32769 --- 1 row(s) selected. ->>select cast (32768 as largeint) from t022t1; +>>select cast (32768 as largeint) from dual; (EXPR) -------------------- @@ -1084,7 +1057,7 @@ A B C 32768 --- 1 row(s) selected. ->>select cast (-10 as largeint) from t022t1; +>>select cast (-10 as largeint) from dual; (EXPR) -------------------- @@ -1092,7 +1065,7 @@ A B C -10 --- 1 row(s) selected. ->>select cast (10 as largeint) from t022t1; +>>select cast (10 as largeint) from dual; (EXPR) -------------------- @@ -1100,7 +1073,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (-1 as largeint) from t022t1; +>>select cast (-1 as largeint) from dual; (EXPR) -------------------- @@ -1108,7 +1081,7 @@ A B C -1 --- 1 row(s) selected. ->>select cast (65536 as largeint) from t022t1; +>>select cast (65536 as largeint) from dual; (EXPR) -------------------- @@ -1116,7 +1089,7 @@ A B C 65536 --- 1 row(s) selected. ->>select cast (-2147483649 as largeint) from t022t1; +>>select cast (-2147483649 as largeint) from dual; (EXPR) -------------------- @@ -1124,7 +1097,7 @@ A B C -2147483649 --- 1 row(s) selected. ->>select cast (2147483648 as largeint) from t022t1; +>>select cast (2147483648 as largeint) from dual; (EXPR) -------------------- @@ -1132,7 +1105,7 @@ A B C 2147483648 --- 1 row(s) selected. ->>select cast (-100000 as largeint) from t022t1; +>>select cast (-100000 as largeint) from dual; (EXPR) -------------------- @@ -1140,7 +1113,7 @@ A B C -100000 --- 1 row(s) selected. ->>select cast (100000 as largeint) from t022t1; +>>select cast (100000 as largeint) from dual; (EXPR) -------------------- @@ -1148,7 +1121,7 @@ A B C 100000 --- 1 row(s) selected. ->>select cast (4294967296 as largeint) from t022t1; +>>select cast (4294967296 as largeint) from dual; (EXPR) -------------------- @@ -1156,7 +1129,7 @@ A B C 4294967296 --- 1 row(s) selected. ->>select cast (-10000000000 as largeint) from t022t1; +>>select cast (-10000000000 as largeint) from dual; (EXPR) -------------------- @@ -1164,7 +1137,7 @@ A B C -10000000000 --- 1 row(s) selected. ->>select cast (10000000000 as largeint) from t022t1; +>>select cast (10000000000 as largeint) from dual; (EXPR) -------------------- @@ -1173,7 +1146,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (-32769 as decimal(5)) from t022t1; +>>select cast (-32769 as decimal(5)) from dual; (EXPR) ------ @@ -1181,7 +1154,7 @@ A B C -32769 --- 1 row(s) selected. ->>select cast (32768 as decimal(5)) from t022t1; +>>select cast (32768 as decimal(5)) from dual; (EXPR) ------ @@ -1189,7 +1162,7 @@ A B C 32768 --- 1 row(s) selected. ->>select cast (-10 as decimal(2)) from t022t1; +>>select cast (-10 as decimal(2)) from dual; (EXPR) ------ @@ -1197,7 +1170,7 @@ A B C -10 --- 1 row(s) selected. ->>select cast (10 as decimal(2)) from t022t1; +>>select cast (10 as decimal(2)) from dual; (EXPR) ------ @@ -1205,7 +1178,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (-1 as decimal(1)) from t022t1; +>>select cast (-1 as decimal(1)) from dual; (EXPR) ------ @@ -1213,7 +1186,7 @@ A B C -1 --- 1 row(s) selected. ->>select cast (65536 as decimal(5)) from t022t1; +>>select cast (65536 as decimal(5)) from dual; (EXPR) ------ @@ -1221,7 +1194,7 @@ A B C 65536 --- 1 row(s) selected. ->>select cast (-2147483649 as decimal(10)) from t022t1; +>>select cast (-2147483649 as decimal(10)) from dual; (EXPR) ----------- @@ -1229,7 +1202,7 @@ A B C -2147483649 --- 1 row(s) selected. ->>select cast (2147483648 as decimal(10)) from t022t1; +>>select cast (2147483648 as decimal(10)) from dual; (EXPR) ----------- @@ -1237,7 +1210,7 @@ A B C 2147483648 --- 1 row(s) selected. ->>select cast (-100000 as decimal(6)) from t022t1; +>>select cast (-100000 as decimal(6)) from dual; (EXPR) ------- @@ -1245,7 +1218,7 @@ A B C -100000 --- 1 row(s) selected. ->>select cast (100000 as decimal(6)) from t022t1; +>>select cast (100000 as decimal(6)) from dual; (EXPR) ------- @@ -1253,7 +1226,7 @@ A B C 100000 --- 1 row(s) selected. ->>select cast (4294967296 as decimal(10)) from t022t1; +>>select cast (4294967296 as decimal(10)) from dual; (EXPR) ----------- @@ -1261,7 +1234,7 @@ A B C 4294967296 --- 1 row(s) selected. ->>select cast (-10000000000 as decimal(11)) from t022t1; +>>select cast (-10000000000 as decimal(11)) from dual; (EXPR) ------------ @@ -1269,7 +1242,7 @@ A B C -10000000000 --- 1 row(s) selected. ->>select cast (10000000000 as decimal(11)) from t022t1; +>>select cast (10000000000 as decimal(11)) from dual; (EXPR) ------------ @@ -1278,7 +1251,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (32768 as decimal(5) unsigned) from t022t1; +>>select cast (32768 as decimal(5) unsigned) from dual; (EXPR) ------ @@ -1286,7 +1259,7 @@ A B C 32768 --- 1 row(s) selected. ->>select cast (10 as decimal(2) unsigned) from t022t1; +>>select cast (10 as decimal(2) unsigned) from dual; (EXPR) ------ @@ -1294,7 +1267,7 @@ A B C 10 --- 1 row(s) selected. ->>select cast (65536 as decimal(5) unsigned) from t022t1; +>>select cast (65536 as decimal(5) unsigned) from dual; (EXPR) ------ @@ -1302,7 +1275,7 @@ A B C 65536 --- 1 row(s) selected. ->>select cast (100000 as decimal(6) unsigned) from t022t1; +>>select cast (100000 as decimal(6) unsigned) from dual; (EXPR) ------ @@ -1311,7 +1284,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (-32769 as real) from t022t1; +>>select cast (-32769 as real) from dual; (EXPR) --------------- @@ -1319,7 +1292,7 @@ A B C -3.2769000E+004 --- 1 row(s) selected. ->>select cast (32768 as real) from t022t1; +>>select cast (32768 as real) from dual; (EXPR) --------------- @@ -1327,7 +1300,7 @@ A B C 3.2768000E+004 --- 1 row(s) selected. ->>select cast (-10 as real) from t022t1; +>>select cast (-10 as real) from dual; (EXPR) --------------- @@ -1335,7 +1308,7 @@ A B C -1.0000000E+001 --- 1 row(s) selected. ->>select cast (10 as real) from t022t1; +>>select cast (10 as real) from dual; (EXPR) --------------- @@ -1343,7 +1316,7 @@ A B C 1.0000000E+001 --- 1 row(s) selected. ->>select cast (-1 as real) from t022t1; +>>select cast (-1 as real) from dual; (EXPR) --------------- @@ -1351,7 +1324,7 @@ A B C -1.0000000E+000 --- 1 row(s) selected. ->>select cast (65536 as real) from t022t1; +>>select cast (65536 as real) from dual; (EXPR) --------------- @@ -1359,7 +1332,7 @@ A B C 6.5536000E+004 --- 1 row(s) selected. ->>select cast (-2147483649 as real) from t022t1; +>>select cast (-2147483649 as real) from dual; (EXPR) --------------- @@ -1367,7 +1340,7 @@ A B C -2.1474836E+009 --- 1 row(s) selected. ->>select cast (9999999999 as real) from t022t1; +>>select cast (9999999999 as real) from dual; (EXPR) --------------- @@ -1375,7 +1348,7 @@ A B C 1.0000000E+010 --- 1 row(s) selected. ->>select cast (-100000 as real) from t022t1; +>>select cast (-100000 as real) from dual; (EXPR) --------------- @@ -1383,7 +1356,7 @@ A B C -1.0000000E+005 --- 1 row(s) selected. ->>select cast (100000 as real) from t022t1; +>>select cast (100000 as real) from dual; (EXPR) --------------- @@ -1391,7 +1364,7 @@ A B C 1.0000000E+005 --- 1 row(s) selected. ->>select cast (9999999999 as real) from t022t1; +>>select cast (9999999999 as real) from dual; (EXPR) --------------- @@ -1400,7 +1373,7 @@ A B C --- 1 row(s) selected. >> ->>select cast (-32769 as double precision) from t022t1; +>>select cast (-32769 as double precision) from dual; (EXPR) ------------------------- @@ -1408,7 +1381,7 @@ A B C -3.27690000000000064E+004 --- 1 row(s) selected. ->>select cast (32768 as double precision) from t022t1; +>>select cast (32768 as double precision) from dual; (EXPR) ------------------------- @@ -1416,7 +1389,7 @@ A B C 3.27680000000000000E+004 --- 1 row(s) selected. ->>select cast (-10 as double precision) from t022t1; +>>select cast (-10 as double precision) from dual; (EXPR) ------------------------- @@ -1424,7 +1397,7 @@ A B C -1.00000000000000000E+001 --- 1 row(s) selected. ->>select cast (10 as double precision) from t022t1; +>>select cast (10 as double precision) from dual; (EXPR) ------------------------- @@ -1432,7 +1405,7 @@ A B C 1.00000000000000000E+001 --- 1 row(s) selected. ->>select cast (-1 as double precision) from t022t1; +>>select cast (-1 as double precision) from dual; (EXPR) ------------------------- @@ -1440,7 +1413,7 @@ A B C -1.00000000000000000E+000 --- 1 row(s) selected. ->>select cast (65536 as double precision) from t022t1; +>>select cast (65536 as double precision) from dual; (EXPR) ------------------------- @@ -1448,7 +1421,7 @@ A B C 6.55360000000000000E+004 --- 1 row(s) selected. ->>select cast (-2147483649 as double precision) from t022t1; +>>select cast (-2147483649 as double precision) from dual; (EXPR) ------------------------- @@ -1456,7 +1429,7 @@ A B C -2.14748364900000032E+009 --- 1 row(s) selected. ->>select cast (2147483648 as double precision) from t022t1; +>>select cast (2147483648 as double precision) from dual; (EXPR) ------------------------- @@ -1464,7 +1437,7 @@ A B C 2.14748364800000000E+009 --- 1 row(s) selected. ->>select cast (-100000 as double precision) from t022t1; +>>select cast (-100000 as double precision) from dual; (EXPR) ------------------------- @@ -1472,7 +1445,7 @@ A B C -1.00000000000000000E+005 --- 1 row(s) selected. ->>select cast (100000 as double precision) from t022t1; +>>select cast (100000 as double precision) from dual; (EXPR) ------------------------- @@ -1480,7 +1453,7 @@ A B C 1.00000000000000000E+005 --- 1 row(s) selected. ->>select cast (4294967296 as double precision) from t022t1; +>>select cast (4294967296 as double precision) from dual; (EXPR) ------------------------- @@ -1489,43 +1462,39 @@ A B C --- 1 row(s) selected. >> ->>select cast ('Hello, world!' as char(13)) from t022t2; +>>select cast ('Hello, world!' as char(13)) from dual; (EXPR) ------------- Hello, world! -Hello, world! ---- 2 row(s) selected. ->>select cast ('Hello, world!' as varchar(13)) from t022t2; +--- 1 row(s) selected. +>>select cast ('Hello, world!' as varchar(13)) from dual; (EXPR) ------------- Hello, world! -Hello, world! ---- 2 row(s) selected. ->>select cast (cast ('Hello ' as char(13)) as char(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello ' as char(13)) as char(5)) from dual; (EXPR) ------ Hello -Hello ---- 2 row(s) selected. ->>select cast (cast ('Hello ' as char(13)) as varchar(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello ' as char(13)) as varchar(5)) from dual; (EXPR) ------ Hello -Hello ---- 2 row(s) selected. ->>select cast (cast ('Hello, world!' as char(13)) as char(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello, world!' as char(13)) as char(5)) from dual; *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. @@ -1534,12 +1503,8 @@ Hello Hello -*** WARNING[8402] A string overflow occurred during the evaluation of a character expression. - -Hello - ---- 2 row(s) selected. ->>select cast (cast ('Hello, world!' as char(13)) as varchar(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello, world!' as char(13)) as varchar(5)) from dual; *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. @@ -1548,30 +1513,24 @@ Hello Hello -*** WARNING[8402] A string overflow occurred during the evaluation of a character expression. - -Hello - ---- 2 row(s) selected. ->>select cast (cast ('Hello ' as varchar(13)) as char(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello ' as varchar(13)) as char(5)) from dual; (EXPR) ------ Hello -Hello ---- 2 row(s) selected. ->>select cast (cast ('Hello ' as varchar(13)) as varchar(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello ' as varchar(13)) as varchar(5)) from dual; (EXPR) ------ Hello -Hello ---- 2 row(s) selected. ->>select cast (cast ('Hello, world!' as varchar(13)) as char(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello, world!' as varchar(13)) as char(5)) from dual; *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. @@ -1580,12 +1539,8 @@ Hello Hello -*** WARNING[8402] A string overflow occurred during the evaluation of a character expression. - -Hello - ---- 2 row(s) selected. ->>select cast (cast ('Hello, world!' as varchar(13)) as varchar(5)) from t022t2; +--- 1 row(s) selected. +>>select cast (cast ('Hello, world!' as varchar(13)) as varchar(5)) from dual; *** WARNING[8402] A string overflow occurred during the evaluation of a character expression. @@ -1594,12 +1549,8 @@ Hello Hello -*** WARNING[8402] A string overflow occurred during the evaluation of a character expression. - -Hello - ---- 2 row(s) selected. ->>select cast (cast (-2147483649 as double precision) as largeint) from t022t1; +--- 1 row(s) selected. +>>select cast (cast (-2147483649 as double precision) as largeint) from dual; (EXPR) -------------------- @@ -1607,7 +1558,7 @@ Hello -2147483649 --- 1 row(s) selected. ->>select cast (cast (2147483648 as double precision) as largeint) from t022t1; +>>select cast (cast (2147483648 as double precision) as largeint) from dual; (EXPR) -------------------- @@ -1618,7 +1569,7 @@ Hello >> >>-- Positive cases to test division. >> ->>select cast (1 as numeric(1)) / cast (1 as numeric(1)) from t022t1; +>>select cast (1 as numeric(1)) / cast (1 as numeric(1)) from dual; (EXPR) ------- @@ -1626,7 +1577,7 @@ Hello 1.0 --- 1 row(s) selected. ->>select cast (1 as numeric(5)) / cast (1 as numeric(1)) from t022t1; +>>select cast (1 as numeric(5)) / cast (1 as numeric(1)) from dual; (EXPR) ------------ @@ -1634,7 +1585,7 @@ Hello 1.0 --- 1 row(s) selected. ->>select cast (1 as numeric(1)) / cast (1 as numeric(5)) from t022t1; +>>select cast (1 as numeric(1)) / cast (1 as numeric(5)) from dual; (EXPR) ------------ @@ -1642,7 +1593,7 @@ Hello 1.00000 --- 1 row(s) selected. ->>select cast (1 as numeric(5)) / cast (1 as numeric(5)) from t022t1; +>>select cast (1 as numeric(5)) / cast (1 as numeric(5)) from dual; (EXPR) --------------------- @@ -1650,7 +1601,7 @@ Hello 1.00000 --- 1 row(s) selected. ->>select cast (1 as numeric(10)) / cast (1 as numeric(10)) from t022t1; +>>select cast (1 as numeric(10)) / cast (1 as numeric(10)) from dual; (EXPR) --------------------- @@ -1660,7 +1611,7 @@ Hello --- 1 row(s) selected. >> >>select cast (1 as numeric(1) unsigned) / -+> cast (1 as numeric(1) unsigned) from t022t1; ++> cast (1 as numeric(1) unsigned) from dual; (EXPR) ------ @@ -1669,7 +1620,7 @@ Hello --- 1 row(s) selected. >>select cast (1 as numeric(5) unsigned) / -+> cast (1 as numeric(1) unsigned) from t022t1; ++> cast (1 as numeric(1) unsigned) from dual; (EXPR) ----------- @@ -1678,7 +1629,7 @@ Hello --- 1 row(s) selected. >>select cast (1 as numeric(1) unsigned) / -+> cast (1 as numeric(5) unsigned) from t022t1; ++> cast (1 as numeric(5) unsigned) from dual; (EXPR) ----------- @@ -1687,7 +1638,7 @@ Hello --- 1 row(s) selected. >>select cast (1 as numeric(5) unsigned) / -+> cast (1 as numeric(5) unsigned) from t022t1; ++> cast (1 as numeric(5) unsigned) from dual; (EXPR) --------------------- @@ -1696,7 +1647,7 @@ Hello --- 1 row(s) selected. >>select cast (1 as numeric(9) unsigned) / -+> cast (1 as numeric(9) unsigned) from t022t1; ++> cast (1 as numeric(9) unsigned) from dual; (EXPR) --------------------- @@ -1705,7 +1656,7 @@ Hello --- 1 row(s) selected. >> ->>select cast (1 as double precision) / cast (1 as double precision) from t022t1; +>>select cast (1 as double precision) / cast (1 as double precision) from dual; (EXPR) ------------------------- @@ -1716,771 +1667,766 @@ Hello >> >>-- Negative tests. >> ->>select cast (cast (-10 as smallint) as numeric(1)) from t022t1; +>>select cast (cast (-10 as smallint) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:-10 Target Type:LARGEINT(IBIN64S) Min Target Value:-9. Instruction:RANGE_LOW_S16S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (10 as smallint) as numeric(1)) from t022t1; +>>select cast (cast (10 as smallint) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_S16S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-10 as numeric(2)) as numeric(1)) from t022t1; +>>select cast (cast (-10 as numeric(2)) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:TINYINT SIGNED(MBIN8S) Source Value:-10 Target Type:LARGEINT(IBIN64S) Min Target Value:-9. Instruction:RANGE_LOW_S8S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (10 as numeric(2)) as numeric(1)) from t022t1; +>>select cast (cast (10 as numeric(2)) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:TINYINT SIGNED(MBIN8S) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_S8S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-1 as smallint) as smallint unsigned) from t022t1; +>>select cast (cast (-1 as smallint) as smallint unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:-1 Target Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S16S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (10 as smallint) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as smallint) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_S16S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-1 as smallint) as int unsigned) from t022t1; +>>select cast (cast (-1 as smallint) as int unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. Source Type:SMALLINT SIGNED(MBIN16S) Source Value:-1 Target Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S16S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (-10 as smallint) as decimal(1)) from t022t1; +>>select cast (cast (-10 as smallint) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (10 as smallint) as decimal(1)) from t022t1; +>>select cast (cast (10 as smallint) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (-1 as smallint) as decimal(1) unsigned) from t022t1; +>>select cast (cast (-1 as smallint) as decimal(1) unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (10 as smallint) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as smallint) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (32768 as smallint unsigned) as smallint) from t022t1; +>>select cast (cast (32768 as smallint unsigned) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:SMALLINT UNSIGNED(MBIN16U) Source Value:32768 Target Type:LARGEINT(IBIN64S) Max Target Value:32767. Instruction:RANGE_HIGH_U16S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as smallint unsigned) as numeric(1)) from t022t1; +>>select cast (cast (10 as smallint unsigned) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:SMALLINT UNSIGNED(MBIN16U) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_U16S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as smallint unsigned) as numeric(1)unsigned) from t022t1; +>>select cast (cast (10 as smallint unsigned) as numeric(1)unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:SMALLINT UNSIGNED(MBIN16U) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_U16S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as smallint unsigned) as decimal(1)) from t022t1; +>>select cast (cast (10 as smallint unsigned) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (10 as smallint unsigned) as decimal(1)unsigned) from t022t1; +>>select cast (cast (10 as smallint unsigned) as decimal(1)unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (-32769 as int) as smallint) from t022t1; +>>select cast (cast (-32769 as int) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:-32769 Target Type:LARGEINT(IBIN64S) Min Target Value:-32768. Instruction:RANGE_LOW_S32S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (32768 as int) as smallint) from t022t1; +>>select cast (cast (32768 as int) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:32768 Target Type:LARGEINT(IBIN64S) Max Target Value:32767. Instruction:RANGE_HIGH_S32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-10 as int) as numeric(1)) from t022t1; +>>select cast (cast (-10 as int) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:INTEGER SIGNED(REC_BIN32_SIGNED) Source Value:-10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as int) as numeric(1)) from t022t1; +>>select cast (cast (10 as int) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:INTEGER SIGNED(REC_BIN32_SIGNED) Source Value:10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as int) as smallint unsigned) from t022t1; +>>select cast (cast (-1 as int) as smallint unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. Source Type:INTEGER SIGNED(MBIN32S) Source Value:-1 Target Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S32S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (65536 as int) as smallint unsigned) from t022t1; +>>select cast (cast (65536 as int) as smallint unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:65536 Target Type:LARGEINT(IBIN64S) Max Target Value:65535. Instruction:RANGE_HIGH_S32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as int) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as int) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:INTEGER SIGNED(REC_BIN32_SIGNED) Source Value:10 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (-100000 as int) as numeric(5)) from t022t1; +>>select cast (cast (-100000 as int) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:-100000 Target Type:LARGEINT(IBIN64S) Min Target Value:-99999. Instruction:RANGE_LOW_S32S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (100000 as int) as numeric(5)) from t022t1; +>>select cast (cast (100000 as int) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:100000 Target Type:LARGEINT(IBIN64S) Max Target Value:99999. Instruction:RANGE_HIGH_S32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-1 as int) as int unsigned) from t022t1; +>>select cast (cast (-1 as int) as int unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. Source Type:INTEGER SIGNED(MBIN32S) Source Value:-1 Target Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S32S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (100000 as int) as numeric(5) unsigned) from t022t1; +>>select cast (cast (100000 as int) as numeric(5) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:100000 Target Type:LARGEINT(IBIN64S) Max Target Value:99999. Instruction:RANGE_HIGH_S32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-10 as int) as decimal(1)) from t022t1; +>>select cast (cast (-10 as int) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (10 as int) as decimal(1)) from t022t1; +>>select cast (cast (10 as int) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (-1 as int) as decimal(1) unsigned) from t022t1; +>>select cast (cast (-1 as int) as decimal(1) unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (10 as int) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as int) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (32768 as int unsigned) as smallint) from t022t1; +>>select cast (cast (32768 as int unsigned) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:32768 Target Type:LARGEINT(IBIN64S) Max Target Value:32767. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as int unsigned) as numeric(1)) from t022t1; +>>select cast (cast (10 as int unsigned) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED) Source Value:10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (65536 as int unsigned) as smallint unsigned) from t022t1; +>>select cast (cast (65536 as int unsigned) as smallint unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:65536 Target Type:LARGEINT(IBIN64S) Max Target Value:65535. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as int unsigned) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as int unsigned) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED) Source Value:10 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (2147483648 as int unsigned) as int) from t022t1; +>>select cast (cast (2147483648 as int unsigned) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:2147483648 Target Type:LARGEINT(IBIN64S) Max Target Value:2147483647. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (100000 as int unsigned) as numeric(5)) from t022t1; +>>select cast (cast (100000 as int unsigned) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:100000 Target Type:LARGEINT(IBIN64S) Max Target Value:99999. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (100000 as int unsigned) as numeric(5) unsigned) from t022t1; +>>select cast (cast (100000 as int unsigned) as numeric(5) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:100000 Target Type:LARGEINT(IBIN64S) Max Target Value:99999. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as int unsigned) as decimal(1)) from t022t1; +>>select cast (cast (10 as int unsigned) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (10 as int unsigned) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as int unsigned) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (-32769 as largeint) as smallint) from t022t1; +>>select cast (cast (-32769 as largeint) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:-32769 Target Type:LARGEINT(IBIN64S) Min Target Value:-32768. Instruction:RANGE_LOW_S64S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (32768 as largeint) as smallint) from t022t1; +>>select cast (cast (32768 as largeint) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:32768 Target Type:LARGEINT(IBIN64S) Max Target Value:32767. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-10 as largeint) as numeric(1)) from t022t1; +>>select cast (cast (-10 as largeint) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as largeint) as numeric(1)) from t022t1; +>>select cast (cast (10 as largeint) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as largeint) as smallint unsigned) from t022t1; +>>select cast (cast (-1 as largeint) as smallint unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (65536 as largeint) as smallint unsigned) from t022t1; +>>select cast (cast (65536 as largeint) as smallint unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:65536 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as largeint) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as largeint) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (-2147483649 as largeint) as int) from t022t1; +>>select cast (cast (-2147483649 as largeint) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:-2147483649 Target Type:LARGEINT(IBIN64S) Min Target Value:-2147483648. Instruction:RANGE_LOW_S64S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (2147483648 as largeint) as int) from t022t1; +>>select cast (cast (2147483648 as largeint) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:2147483648 Target Type:LARGEINT(IBIN64S) Max Target Value:2147483647. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-100000 as largeint) as numeric(5)) from t022t1; +>>select cast (cast (-100000 as largeint) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:-100000 Target Type:LARGEINT(IBIN64S) Min Target Value:-99999. Instruction:RANGE_LOW_S64S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (100000 as largeint) as numeric(5)) from t022t1; +>>select cast (cast (100000 as largeint) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:100000 Target Type:LARGEINT(IBIN64S) Max Target Value:99999. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-1 as largeint) as int unsigned) from t022t1; +>>select cast (cast (-1 as largeint) as int unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. Source Type:LARGEINT(MBIN64S) Source Value:-1 Target Type:LARGEINT(IBIN64S) Max Target Value:0. Instruction:RANGE_LOW_S64S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (4294967296 as largeint) as int unsigned) from t022t1; +>>select cast (cast (4294967296 as largeint) as int unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:4294967296 Target Type:LARGEINT(IBIN64S) Max Target Value:4294967295. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (100000 as largeint) as numeric(5) unsigned) from t022t1; +>>select cast (cast (100000 as largeint) as numeric(5) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:100000 Target Type:LARGEINT(IBIN64S) Max Target Value:99999. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (-10000000000 as largeint) as numeric(10)) from t022t1; +>>select cast (cast (-10000000000 as largeint) as numeric(10)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:-10000000000 Target Type:LARGEINT(IBIN64S) Min Target Value:-9999999999. Instruction:RANGE_LOW_S64S64 Operation:RANGE_LOW. --- 0 row(s) selected. ->>select cast (cast (10000000000 as largeint) as numeric(10)) from t022t1; +>>select cast (cast (10000000000 as largeint) as numeric(10)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:10000000000 Target Type:LARGEINT(IBIN64S) Max Target Value:9999999999. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH. --- 0 row(s) selected. ->>select cast (cast (10 as largeint) as decimal(1)) from t022t1; +>>select cast (cast (10 as largeint) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (-1 as largeint) as decimal(1) unsigned) from t022t1; +>>select cast (cast (-1 as largeint) as decimal(1) unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (10 as largeint) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as largeint) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (-32769 as decimal(5)) as smallint) from t022t1; +>>select cast (cast (-32769 as decimal(5)) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-32769 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (32768 as decimal(5)) as smallint) from t022t1; +>>select cast (cast (32768 as decimal(5)) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:32768 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-10 as decimal(2)) as numeric(1)) from t022t1; +>>select cast (cast (-10 as decimal(2)) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2)) as numeric(1)) from t022t1; +>>select cast (cast (10 as decimal(2)) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as decimal(1)) as smallint unsigned) from t022t1; +>>select cast (cast (-1 as decimal(1)) as smallint unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (65536 as decimal(5)) as smallint unsigned) from t022t1; +>>select cast (cast (65536 as decimal(5)) as smallint unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:65536 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2)) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as decimal(2)) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (-2147483649 as decimal(10)) as int) from t022t1; +>>select cast (cast (-2147483649 as decimal(10)) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-2147483649 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (2147483648 as decimal(10)) as int) from t022t1; +>>select cast (cast (2147483648 as decimal(10)) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:2147483648 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-100000 as decimal(6)) as numeric(5)) from t022t1; +>>select cast (cast (-100000 as decimal(6)) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-100000 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (100000 as decimal(6)) as numeric(5)) from t022t1; +>>select cast (cast (100000 as decimal(6)) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:100000 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as decimal(1)) as int unsigned) from t022t1; +>>select cast (cast (-1 as decimal(1)) as int unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (4294967296 as decimal(10)) as int unsigned) from t022t1; +>>select cast (cast (4294967296 as decimal(10)) as int unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:4294967296 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (100000 as decimal(6)) as numeric(5) unsigned) from t022t1; +>>select cast (cast (100000 as decimal(6)) as numeric(5) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:100000 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (-10000000000 as decimal(11)) as numeric(10)) from t022t1; +>>select cast (cast (-10000000000 as decimal(11)) as numeric(10)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:-10000000000 to Target Type:LARGEINT(REC_BIN64_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10000000000 as decimal(11)) as numeric(10)) from t022t1; +>>select cast (cast (10000000000 as decimal(11)) as numeric(10)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10000000000 to Target Type:LARGEINT(REC_BIN64_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2)) as decimal(1)) from t022t1; +>>select cast (cast (10 as decimal(2)) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (-1 as decimal(1)) as decimal(1) unsigned) from t022t1; +>>select cast (cast (-1 as decimal(1)) as decimal(1) unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2)) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as decimal(2)) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (32768 as decimal(5) unsigned) as smallint) from t022t1; +>>select cast (cast (32768 as decimal(5) unsigned) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:32768 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2) unsigned) as numeric(1)) from t022t1; +>>select cast (cast (10 as decimal(2) unsigned) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (65536 as decimal(5) unsigned) as smallint unsigned) from t022t1; +>>select cast (cast (65536 as decimal(5) unsigned) as smallint unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:65536 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2) unsigned) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as decimal(2) unsigned) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (100000 as decimal(6) unsigned) as numeric(5)) from t022t1; +>>select cast (cast (100000 as decimal(6) unsigned) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:100000 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (100000 as decimal(6) unsigned) as numeric(5) unsigned) from t022t1; +>>select cast (cast (100000 as decimal(6) unsigned) as numeric(5) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:100000 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2) unsigned) as decimal(1)) from t022t1; +>>select cast (cast (10 as decimal(2) unsigned) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (10 as decimal(2) unsigned) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as decimal(2) unsigned) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Intermediate conversion of Source Type:LARGEINT(REC_BIN64_SIGNED) Source Value:10 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (-32769 as real) as smallint) from t022t1; +>>select cast (cast (-32769 as real) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:-3.2769000E+004 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (32768 as real) as smallint) from t022t1; +>>select cast (cast (32768 as real) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:3.2768000E+004 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-10 as real) as numeric(1)) from t022t1; +>>select cast (cast (-10 as real) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:0.0000000E+000 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as real) as numeric(1)) from t022t1; +>>select cast (cast (10 as real) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.4012984E-044 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as real) as smallint unsigned) from t022t1; +>>select cast (cast (-1 as real) as smallint unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (65536 as real) as smallint unsigned) from t022t1; +>>select cast (cast (65536 as real) as smallint unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:6.5536000E+004 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as real) as numeric(1) unsigned) from t022t1; +>>select cast (cast (10 as real) as numeric(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.4012984E-044 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (-2147484160 as real) as int) from t022t1; +>>select cast (cast (-2147484160 as real) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:-2.1474841E+009 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (9999999999 as real) as int) from t022t1; +>>select cast (cast (9999999999 as real) as int) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.0000000E+010 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-100000 as real) as numeric(5)) from t022t1; +>>select cast (cast (-100000 as real) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:0.0000000E+000 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (100000 as real) as numeric(5)) from t022t1; +>>select cast (cast (100000 as real) as numeric(5)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.4012984E-040 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as real) as int unsigned) from t022t1; +>>select cast (cast (-1 as real) as int unsigned) from dual; *** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype. --- 0 row(s) selected. ->>select cast (cast (9999999999 as real) as int unsigned) from t022t1; +>>select cast (cast (9999999999 as real) as int unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.0000000E+010 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (100000 as real) as numeric(5) unsigned) from t022t1; +>>select cast (cast (100000 as real) as numeric(5) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.4012984E-040 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as real) as decimal(1)) from t022t1; +>>select cast (cast (10 as real) as decimal(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.0000000E+001 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE). --- 0 row(s) selected. ->>select cast (cast (-1 as real) as decimal(1) unsigned) from t022t1; +>>select cast (cast (-1 as real) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:-1.0000000E+000 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as real) as decimal(1) unsigned) from t022t1; +>>select cast (cast (10 as real) as decimal(1) unsigned) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE FLOAT(REC_IEEE_FLOAT32) Source Value:1.0000000E+001 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED). --- 0 row(s) selected. >> ->>select cast (cast (-32769 as double precision) as smallint) from t022t1; +>>select cast (cast (-32769 as double precision) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE DOUBLE PRECISION(REC_IEEE_FLOAT64) Source Value:-3.27690000000000064E+004 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (32768 as double precision) as smallint) from t022t1; +>>select cast (cast (32768 as double precision) as smallint) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE DOUBLE PRECISION(REC_IEEE_FLOAT64) Source Value:3.27680000000000000E+004 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-10 as double precision) as numeric(1)) from t022t1; +>>select cast (cast (-10 as double precision) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE DOUBLE PRECISION(REC_IEEE_FLOAT64) Source Value:0.00000000000000000E+000 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (10 as double precision) as numeric(1)) from t022t1; +>>select cast (cast (10 as double precision) as numeric(1)) from dual; *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:IEEE DOUBLE PRECISION(REC_IEEE_FLOAT64) Source Value:4.94065645841246592E-323 to Target Type:SMALLINT SIGNED(REC_BIN16_SIGNED). --- 0 row(s) selected. ->>select cast (cast (-1 as double precision) as smallint unsigned) from t022t1; +>>select cast (cast (-1 as double precision) as
<TRUNCATED>
