You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/02/23 00:48:55 UTC
[3/5] incubator-trafodion git commit: JIRA TRAFODION-1825. Fix for
core caused by input datetime values.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/44fb4f56/core/sql/regress/executor/EXPECTED022.LINUX
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED022.LINUX b/core/sql/regress/executor/EXPECTED022.LINUX
deleted file mode 100755
index 87d8312..0000000
--- a/core/sql/regress/executor/EXPECTED022.LINUX
+++ /dev/null
@@ -1,9365 +0,0 @@
->>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.
->>create table t022t4 (a smallint unsigned, b smallint);
-
---- 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.
->>insert into t022t4 values (65535, 32767);
-
---- 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.
->>sh sh -c 'rm -f t022xxx > /dev/null 2>&1 ';
->>-- Must use "sh sh -c" if we want the command to work on NT platforms.
->>-- The space between t022xxx and the single quote (') is required by the SQLCI sh command.
->>-- If the space is not specified, the output is going into the file "t022xxx'" - Strange!
->>sh sh -c 'echo "begin work;" > t022xxx ';
->>sh sh -c 'echo "execute insertIntoT022A7 using 0 , 1. ; " >> t022xxx ';
->>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;
-
-(EXPR)
-------
-
- -9
-
---- 1 row(s) selected.
->>select cast (9 as numeric(1)) from t022t1;
-
-(EXPR)
-------
-
- 9
-
---- 1 row(s) selected.
->>select cast (-9999 as numeric(4)) from t022t1;
-
-(EXPR)
-------
-
- -9999
-
---- 1 row(s) selected.
->>select cast (9999 as numeric(4)) from t022t1;
-
-(EXPR)
-------
-
- 9999
-
---- 1 row(s) selected.
->>select cast (-32768 as smallint) from t022t1;
-
-(EXPR)
-------
-
--32768
-
---- 1 row(s) selected.
->>select cast (32767 as smallint) from t022t1;
-
-(EXPR)
-------
-
- 32767
-
---- 1 row(s) selected.
->>
->>select cast (0 as numeric(1) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 0
-
---- 1 row(s) selected.
->>select cast (9 as numeric(1) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 9
-
---- 1 row(s) selected.
->>select cast (0 as numeric(4) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 0
-
---- 1 row(s) selected.
->>select cast (9999 as numeric(4) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 9999
-
---- 1 row(s) selected.
->>select cast (0 as smallint unsigned) from t022t1;
-
-(EXPR)
-------
-
- 0
-
---- 1 row(s) selected.
->>select cast (65535 as smallint unsigned) from t022t1;
-
-(EXPR)
-------
-
- 65535
-
---- 1 row(s) selected.
->>
->>select cast (-99999 as numeric(5)) from t022t1;
-
-(EXPR)
------------
-
- -99999
-
---- 1 row(s) selected.
->>select cast (99999 as numeric(5)) from t022t1;
-
-(EXPR)
------------
-
- 99999
-
---- 1 row(s) selected.
->>select cast (-999999999 as numeric(9)) from t022t1;
-
-(EXPR)
------------
-
- -999999999
-
---- 1 row(s) selected.
->>select cast (999999999 as numeric(9)) from t022t1;
-
-(EXPR)
------------
-
- 999999999
-
---- 1 row(s) selected.
->>select cast (-2147483648 as int) from t022t1;
-
-(EXPR)
------------
-
--2147483648
-
---- 1 row(s) selected.
->>select cast (2147483647 as int) from t022t1;
-
-(EXPR)
------------
-
- 2147483647
-
---- 1 row(s) selected.
->>
->>select cast (0 as numeric(5) unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 0
-
---- 1 row(s) selected.
->>select cast (99999 as numeric(5) unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 99999
-
---- 1 row(s) selected.
->>select cast (0 as numeric(9) unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 0
-
---- 1 row(s) selected.
->>select cast (999999999 as numeric(9) unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 999999999
-
---- 1 row(s) selected.
->>select cast (0 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 0
-
---- 1 row(s) selected.
->>select cast (4294967295 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
-4294967295
-
---- 1 row(s) selected.
->>
->>select cast (-9999999999 as numeric(10)) from t022t1;
-
-(EXPR)
---------------------
-
- -9999999999
-
---- 1 row(s) selected.
->>select cast (9999999999 as numeric(10)) from t022t1;
-
-(EXPR)
---------------------
-
- 9999999999
-
---- 1 row(s) selected.
->>select cast (-999999999999999999 as numeric(18)) from t022t1;
-
-(EXPR)
---------------------
-
- -999999999999999999
-
---- 1 row(s) selected.
->>select cast (999999999999999999 as numeric(18)) from t022t1;
-
-(EXPR)
---------------------
-
- 999999999999999999
-
---- 1 row(s) selected.
->>select cast (-9223372036854775808 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
--9223372036854775808
-
---- 1 row(s) selected.
->>select cast (9223372036854775807 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 9223372036854775807
-
---- 1 row(s) selected.
->>
->>select cast (-9 as decimal(1)) from t022t1;
-
-(EXPR)
-------
-
- -9
-
---- 1 row(s) selected.
->>select cast (9 as decimal(1)) from t022t1;
-
-(EXPR)
-------
-
- 9
-
---- 1 row(s) selected.
->>select cast (-999999999999999999 as decimal(18)) from t022t1;
-
-(EXPR)
--------------------
-
--999999999999999999
-
---- 1 row(s) selected.
->>select cast (999999999999999999 as decimal(18)) from t022t1;
-
-(EXPR)
--------------------
-
- 999999999999999999
-
---- 1 row(s) selected.
->>
->>select cast (0 as decimal(1) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 0
-
---- 1 row(s) selected.
->>select cast (9 as decimal(1) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 9
-
---- 1 row(s) selected.
->>select cast (0 as decimal(9) unsigned) from t022t1;
-
-(EXPR)
----------
-
- 0
-
---- 1 row(s) selected.
->>select cast (999999999 as decimal(9) unsigned) from t022t1;
-
-(EXPR)
----------
-
-999999999
-
---- 1 row(s) selected.
->>
->>select cast (date'12/31/9999' as timestamp(3)) from t022t1;
-
-(EXPR)
------------------------
-
-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;
-
-(EXPR)
-----------
-
-9999-12-31
-
---- 1 row(s) selected.
->>select cast (timestamp'12/31/9999 11:59:59.999999 pm' as time(3)) from t022t1;
-
-(EXPR)
-------------
-
-23:59:59.999
-
---- 1 row(s) selected.
->>
->>select interval'0.1'second + timestamp'12/31/9998 11:59:59.9 pm' from t022t1;
-
-(EXPR)
----------------------
-
-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;
-
-(EXPR)
----------------------
-
-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;
-
-(EXPR)
----------------------
-
-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;
-
-(EXPR)
----------------------
-
-9998-12-31 23:59:59.9
-
---- 1 row(s) selected.
->>select (date'12/31/9999' - date'12/31/9998') day(3) from t022t1;
-
-(EXPR)
-------
-
- 365
-
---- 1 row(s) selected.
->>select (date'12/31/9998' - date'12/31/9999') day(3) from t022t1;
-
-(EXPR)
-------
-
- -365
-
---- 1 row(s) selected.
->>
->>select interval'1'month + timestamp'12/31/9998 11:59:59.999 pm' from t022t1;
-
-(EXPR)
------------------------
-
-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;
-
-(EXPR)
------------------------
-
-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;
-
-(EXPR)
------------------------
-
-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;
-
-(EXPR)
------------------------
-
-9998-12-31 23:59:59.999
-
---- 1 row(s) selected.
->>select (date'12/31/9999' - date'12/31/9998') month from t022t1;
-
-*** ERROR[4035] Type INTERVAL DAY(12) 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;
-
-*** ERROR[4035] Type INTERVAL DAY(12) 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;
-
-*** ERROR[4035] Type INTERVAL DAY(12) 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;
-
-*** ERROR[4035] Type INTERVAL DAY(12) 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;
-
-(EXPR)
---------
-
-00:00:00
-
---- 1 row(s) selected.
->>select time'11:59:59 pm' + interval'1'second from t022t1;
-
-(EXPR)
---------
-
-00:00:00
-
---- 1 row(s) selected.
->>select time'12:00:00 am' + interval-'1'second from t022t1;
-
-(EXPR)
---------
-
-23:59:59
-
---- 1 row(s) selected.
->>select time'12:00:00 am' - interval'1'second from t022t1;
-
-(EXPR)
---------
-
-23:59:59
-
---- 1 row(s) selected.
->>
->>select timestamp '2015-05-31T10:11:12' from t022t1;
-
-(EXPR)
--------------------
-
-2015-05-31 10:11:12
-
---- 1 row(s) selected.
->>select timestamp '2015-05-31T10:11:12Z' from t022t1;
-
-(EXPR)
--------------------
-
-2015-05-31 10:11:12
-
---- 1 row(s) selected.
->>select timestamp '2015-05-31T10:11:12-05:00' from t022t1;
-
-(EXPR)
--------------------
-
-2015-05-31 15:11:12
-
---- 1 row(s) selected.
->>select timestamp '2015-05-31T10:11:12+05:00' from t022t1;
-
-(EXPR)
--------------------
-
-2015-05-31 05:11:12
-
---- 1 row(s) selected.
->>select timestamp '2015-05-31T10:11:12.123-05:00' from t022t1;
-
-(EXPR)
------------------------
-
-2015-05-31 15:11:12.123
-
---- 1 row(s) selected.
->>select timestamp '2015-05-31T10:11:12.123+05:00' from t022t1;
-
-(EXPR)
------------------------
-
-2015-05-31 05:11:12.123
-
---- 1 row(s) selected.
->>
->>select cast('2015-05-31T10:11:12' as timestamp) from t022t1;
-
-(EXPR)
---------------------------
-
-2015-05-31 10:11:12.000000
-
---- 1 row(s) selected.
->>select cast('2015-05-31T10:11:12Z' as timestamp) from t022t1;
-
-(EXPR)
---------------------------
-
-2015-05-31 10:11:12.000000
-
---- 1 row(s) selected.
->>select cast('2015-05-31T10:11:12-05:00' as timestamp) from t022t1;
-
-(EXPR)
---------------------------
-
-2015-05-31 15:11:12.000000
-
---- 1 row(s) selected.
->>select cast('2015-05-31T10:11:12+05:00' as timestamp) from t022t1;
-
-(EXPR)
---------------------------
-
-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;
-
-(EXPR)
---------------------------
-
-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;
-
-(EXPR)
---------------------------
-
-2015-05-31 05:11:12.123000
-
---- 1 row(s) selected.
->>
->>select time '10:11:12' from t022t1;
-
-(EXPR)
---------
-
-10:11:12
-
---- 1 row(s) selected.
->>select time '10:11:12Z' from t022t1;
-
-(EXPR)
---------
-
-10:11:12
-
---- 1 row(s) selected.
->>select time '10:11:12-05:00' from t022t1;
-
-(EXPR)
---------
-
-15:11:12
-
---- 1 row(s) selected.
->>select time '10:11:12+05:00' from t022t1;
-
-(EXPR)
---------
-
-05:11:12
-
---- 1 row(s) selected.
->>select time '10:11:12.123-05:00' from t022t1;
-
-(EXPR)
-------------
-
-15:11:12.123
-
---- 1 row(s) selected.
->>select time '10:11:12.123+05:00' from t022t1;
-
-(EXPR)
-------------
-
-05:11:12.123
-
---- 1 row(s) selected.
->>
->>select cast('10:11:12' as time) from t022t1;
-
-(EXPR)
---------
-
-10:11:12
-
---- 1 row(s) selected.
->>select cast('10:11:12Z' as time) from t022t1;
-
-(EXPR)
---------
-
-10:11:12
-
---- 1 row(s) selected.
->>select cast('10:11:12-05:00' as time) from t022t1;
-
-(EXPR)
---------
-
-15:11:12
-
---- 1 row(s) selected.
->>select cast('10:11:12+05:00' as time) from t022t1;
-
-(EXPR)
---------
-
-05:11:12
-
---- 1 row(s) selected.
->>select cast('10:11:12.123-05:00' as time) from t022t1;
-
-(EXPR)
---------
-
-15:11:12
-
---- 1 row(s) selected.
->>select cast('10:11:12.123+05:00' as time) from t022t1;
-
-(EXPR)
---------
-
-05:11:12
-
---- 1 row(s) selected.
->>
->>select time '23:11:06.123' from t022t1;
-
-(EXPR)
-------------
-
-23:11:06.123
-
---- 1 row(s) selected.
->>select cast ('23:11:06.123' as time(2)) from t022t1;
-
-(EXPR)
------------
-
-23:11:06.12
-
---- 1 row(s) selected.
->>
->>-- negative cases
->>select cast('2016-01-29Z' as date) from t022t1;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>select cast('2016-01-29+05:00' as date) from t022t1;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>select cast('10:11:12-05:000' as time) from t022t1;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>select date '2016-01-29Z' from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** ERROR[3046] The time '23:11:11.1234567' is not valid.
-
-*** ERROR[8822] The statement was not prepared.
-
->>select cast ('23:11:61' as time) from t022t1;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>
->>-- Prove these cases work since they're used in the succeeding negative tests.
->>
->>select cast (cast (-10 as smallint) as numeric(2)) from t022t1;
-
-(EXPR)
-------
-
- -10
-
---- 1 row(s) selected.
->>select cast (cast (10 as smallint) as numeric(2)) from t022t1;
-
-(EXPR)
-------
-
- 10
-
---- 1 row(s) selected.
->>select cast (cast (-10 as numeric(2)) as smallint) from t022t1;
-
-(EXPR)
-------
-
- -10
-
---- 1 row(s) selected.
->>select cast (cast (10 as numeric(2)) as smallint) from t022t1;
-
-(EXPR)
-------
-
- 10
-
---- 1 row(s) selected.
->>select cast (-1 as smallint) from t022t1;
-
-(EXPR)
-------
-
- -1
-
---- 1 row(s) selected.
->>
->>select cast (32768 as smallint unsigned) from t022t1;
-
-(EXPR)
-------
-
- 32768
-
---- 1 row(s) selected.
->>select cast (10 as smallint unsigned) from t022t1;
-
-(EXPR)
-------
-
- 10
-
---- 1 row(s) selected.
->>
->>select cast (-32769 as int) from t022t1;
-
-(EXPR)
------------
-
- -32769
-
---- 1 row(s) selected.
->>select cast (32768 as int) from t022t1;
-
-(EXPR)
------------
-
- 32768
-
---- 1 row(s) selected.
->>select cast (-10 as int) from t022t1;
-
-(EXPR)
------------
-
- -10
-
---- 1 row(s) selected.
->>select cast (10 as int) from t022t1;
-
-(EXPR)
------------
-
- 10
-
---- 1 row(s) selected.
->>select cast (-1 as int) from t022t1;
-
-(EXPR)
------------
-
- -1
-
---- 1 row(s) selected.
->>select cast (65536 as int) from t022t1;
-
-(EXPR)
------------
-
- 65536
-
---- 1 row(s) selected.
->>select cast (-100000 as int) from t022t1;
-
-(EXPR)
------------
-
- -100000
-
---- 1 row(s) selected.
->>select cast (100000 as int) from t022t1;
-
-(EXPR)
------------
-
- 100000
-
---- 1 row(s) selected.
->>
->>select cast (32768 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 32768
-
---- 1 row(s) selected.
->>select cast (10 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 10
-
---- 1 row(s) selected.
->>select cast (65536 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 65536
-
---- 1 row(s) selected.
->>select cast (2147483648 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
-2147483648
-
---- 1 row(s) selected.
->>select cast (100000 as int unsigned) from t022t1;
-
-(EXPR)
-----------
-
- 100000
-
---- 1 row(s) selected.
->>
->>select cast (-32769 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- -32769
-
---- 1 row(s) selected.
->>select cast (32768 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 32768
-
---- 1 row(s) selected.
->>select cast (-10 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- -10
-
---- 1 row(s) selected.
->>select cast (10 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 10
-
---- 1 row(s) selected.
->>select cast (-1 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- -1
-
---- 1 row(s) selected.
->>select cast (65536 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 65536
-
---- 1 row(s) selected.
->>select cast (-2147483649 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- -2147483649
-
---- 1 row(s) selected.
->>select cast (2147483648 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 2147483648
-
---- 1 row(s) selected.
->>select cast (-100000 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- -100000
-
---- 1 row(s) selected.
->>select cast (100000 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 100000
-
---- 1 row(s) selected.
->>select cast (4294967296 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 4294967296
-
---- 1 row(s) selected.
->>select cast (-10000000000 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- -10000000000
-
---- 1 row(s) selected.
->>select cast (10000000000 as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 10000000000
-
---- 1 row(s) selected.
->>
->>select cast (-32769 as decimal(5)) from t022t1;
-
-(EXPR)
-------
-
--32769
-
---- 1 row(s) selected.
->>select cast (32768 as decimal(5)) from t022t1;
-
-(EXPR)
-------
-
- 32768
-
---- 1 row(s) selected.
->>select cast (-10 as decimal(2)) from t022t1;
-
-(EXPR)
-------
-
- -10
-
---- 1 row(s) selected.
->>select cast (10 as decimal(2)) from t022t1;
-
-(EXPR)
-------
-
- 10
-
---- 1 row(s) selected.
->>select cast (-1 as decimal(1)) from t022t1;
-
-(EXPR)
-------
-
- -1
-
---- 1 row(s) selected.
->>select cast (65536 as decimal(5)) from t022t1;
-
-(EXPR)
-------
-
- 65536
-
---- 1 row(s) selected.
->>select cast (-2147483649 as decimal(10)) from t022t1;
-
-(EXPR)
------------
-
--2147483649
-
---- 1 row(s) selected.
->>select cast (2147483648 as decimal(10)) from t022t1;
-
-(EXPR)
------------
-
- 2147483648
-
---- 1 row(s) selected.
->>select cast (-100000 as decimal(6)) from t022t1;
-
-(EXPR)
--------
-
--100000
-
---- 1 row(s) selected.
->>select cast (100000 as decimal(6)) from t022t1;
-
-(EXPR)
--------
-
- 100000
-
---- 1 row(s) selected.
->>select cast (4294967296 as decimal(10)) from t022t1;
-
-(EXPR)
------------
-
- 4294967296
-
---- 1 row(s) selected.
->>select cast (-10000000000 as decimal(11)) from t022t1;
-
-(EXPR)
-------------
-
--10000000000
-
---- 1 row(s) selected.
->>select cast (10000000000 as decimal(11)) from t022t1;
-
-(EXPR)
-------------
-
- 10000000000
-
---- 1 row(s) selected.
->>
->>select cast (32768 as decimal(5) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 32768
-
---- 1 row(s) selected.
->>select cast (10 as decimal(2) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 10
-
---- 1 row(s) selected.
->>select cast (65536 as decimal(5) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 65536
-
---- 1 row(s) selected.
->>select cast (100000 as decimal(6) unsigned) from t022t1;
-
-(EXPR)
-------
-
-100000
-
---- 1 row(s) selected.
->>
->>-- Floating point results are different depending on whether you are
->>-- running on NSK (Tandem floating point) or NT (IEEE floating point)
->>?ifNSK
->>select cast (-32769 as real) from t022t1;
->>select cast (32768 as real) from t022t1;
->>select cast (-10 as real) from t022t1;
->>select cast (10 as real) from t022t1;
->>select cast (-1 as real) from t022t1;
->>select cast (65536 as real) from t022t1;
->>select cast (-2147483649 as real) from t022t1;
->>select cast (9999999999 as real) from t022t1;
->>select cast (-100000 as real) from t022t1;
->>select cast (100000 as real) from t022t1;
->>select cast (9999999999 as real) from t022t1;
->>
->>select cast (-32769 as double precision) from t022t1;
->>select cast (32768 as double precision) from t022t1;
->>select cast (-10 as double precision) from t022t1;
->>select cast (10 as double precision) from t022t1;
->>select cast (-1 as double precision) from t022t1;
->>select cast (65536 as double precision) from t022t1;
->>select cast (-2147483649 as double precision) from t022t1;
->>select cast (2147483648 as double precision) from t022t1;
->>select cast (-100000 as double precision) from t022t1;
->>select cast (100000 as double precision) from t022t1;
->>select cast (4294967296 as double precision) from t022t1;
->>?ifNSK
->>?ifNT
->>select cast (-32769 as real) from t022t1;
-
-(EXPR)
----------------
-
--3.2769000E+004
-
---- 1 row(s) selected.
->>select cast (32768 as real) from t022t1;
-
-(EXPR)
----------------
-
- 3.2768000E+004
-
---- 1 row(s) selected.
->>select cast (-10 as real) from t022t1;
-
-(EXPR)
----------------
-
--1.0000000E+001
-
---- 1 row(s) selected.
->>select cast (10 as real) from t022t1;
-
-(EXPR)
----------------
-
- 1.0000000E+001
-
---- 1 row(s) selected.
->>select cast (-1 as real) from t022t1;
-
-(EXPR)
----------------
-
--1.0000000E+000
-
---- 1 row(s) selected.
->>select cast (65536 as real) from t022t1;
-
-(EXPR)
----------------
-
- 6.5536000E+004
-
---- 1 row(s) selected.
->>select cast (-2147483649 as real) from t022t1;
-
-(EXPR)
----------------
-
--2.1474836E+009
-
---- 1 row(s) selected.
->>select cast (9999999999 as real) from t022t1;
-
-(EXPR)
----------------
-
- 1.0000000E+010
-
---- 1 row(s) selected.
->>select cast (-100000 as real) from t022t1;
-
-(EXPR)
----------------
-
--1.0000000E+005
-
---- 1 row(s) selected.
->>select cast (100000 as real) from t022t1;
-
-(EXPR)
----------------
-
- 1.0000000E+005
-
---- 1 row(s) selected.
->>select cast (9999999999 as real) from t022t1;
-
-(EXPR)
----------------
-
- 1.0000000E+010
-
---- 1 row(s) selected.
->>
->>select cast (-32769 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
--3.27690000000000064E+004
-
---- 1 row(s) selected.
->>select cast (32768 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 3.27680000000000000E+004
-
---- 1 row(s) selected.
->>select cast (-10 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
--1.00000000000000000E+001
-
---- 1 row(s) selected.
->>select cast (10 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 1.00000000000000000E+001
-
---- 1 row(s) selected.
->>select cast (-1 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
--1.00000000000000000E+000
-
---- 1 row(s) selected.
->>select cast (65536 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 6.55360000000000000E+004
-
---- 1 row(s) selected.
->>select cast (-2147483649 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
--2.14748364900000032E+009
-
---- 1 row(s) selected.
->>select cast (2147483648 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 2.14748364800000000E+009
-
---- 1 row(s) selected.
->>select cast (-100000 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
--1.00000000000000000E+005
-
---- 1 row(s) selected.
->>select cast (100000 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 1.00000000000000000E+005
-
---- 1 row(s) selected.
->>select cast (4294967296 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 4.29496729600000000E+009
-
---- 1 row(s) selected.
->>?ifNT
->>
->>select cast ('Hello, world!' as char(13)) from t022t2;
-
-(EXPR)
--------------
-
-Hello, world!
-Hello, world!
-
---- 2 row(s) selected.
->>select cast ('Hello, world!' as varchar(13)) from t022t2;
-
-(EXPR)
--------------
-
-Hello, world!
-Hello, world!
-
---- 2 row(s) selected.
->>select cast (cast ('Hello ' as char(13)) as char(5)) from t022t2;
-
-(EXPR)
-------
-
-Hello
-Hello
-
---- 2 row(s) selected.
->>select cast (cast ('Hello ' as char(13)) as varchar(5)) from t022t2;
-
-(EXPR)
-------
-
-Hello
-Hello
-
---- 2 row(s) selected.
->>select cast (cast ('Hello, world!' as char(13)) as char(5)) from t022t2;
-
-*** WARNING[8402] A string overflow occurred during the evaluation of a character expression.
-
-(EXPR)
-------
-
-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;
-
-*** WARNING[8402] A string overflow occurred during the evaluation of a character expression.
-
-(EXPR)
-------
-
-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;
-
-(EXPR)
-------
-
-Hello
-Hello
-
---- 2 row(s) selected.
->>select cast (cast ('Hello ' as varchar(13)) as varchar(5)) from t022t2;
-
-(EXPR)
-------
-
-Hello
-Hello
-
---- 2 row(s) selected.
->>select cast (cast ('Hello, world!' as varchar(13)) as char(5)) from t022t2;
-
-*** WARNING[8402] A string overflow occurred during the evaluation of a character expression.
-
-(EXPR)
-------
-
-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;
-
-*** WARNING[8402] A string overflow occurred during the evaluation of a character expression.
-
-(EXPR)
-------
-
-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;
-
-(EXPR)
---------------------
-
- -2147483649
-
---- 1 row(s) selected.
->>select cast (cast (2147483648 as double precision) as largeint) from t022t1;
-
-(EXPR)
---------------------
-
- 2147483648
-
---- 1 row(s) selected.
->>
->>-- Positive cases to test division.
->>
->>select cast (1 as numeric(1)) / cast (1 as numeric(1)) from t022t1;
-
-(EXPR)
--------
-
- 1.0
-
---- 1 row(s) selected.
->>select cast (1 as numeric(5)) / cast (1 as numeric(1)) from t022t1;
-
-(EXPR)
-------------
-
- 1.0
-
---- 1 row(s) selected.
->>select cast (1 as numeric(1)) / cast (1 as numeric(5)) from t022t1;
-
-(EXPR)
-------------
-
- 1.00000
-
---- 1 row(s) selected.
->>select cast (1 as numeric(5)) / cast (1 as numeric(5)) from t022t1;
-
-(EXPR)
----------------------
-
- 1.00000
-
---- 1 row(s) selected.
->>select cast (1 as numeric(10)) / cast (1 as numeric(10)) from t022t1;
-
-(EXPR)
----------------------
-
- 1.00000000
-
---- 1 row(s) selected.
->>
->>select cast (1 as numeric(1) unsigned) /
-+> cast (1 as numeric(1) unsigned) from t022t1;
-
-(EXPR)
-------
-
- 1.0
-
---- 1 row(s) selected.
->>select cast (1 as numeric(5) unsigned) /
-+> cast (1 as numeric(1) unsigned) from t022t1;
-
-(EXPR)
------------
-
- 1.0
-
---- 1 row(s) selected.
->>select cast (1 as numeric(1) unsigned) /
-+> cast (1 as numeric(5) unsigned) from t022t1;
-
-(EXPR)
------------
-
- 1.00000
-
---- 1 row(s) selected.
->>select cast (1 as numeric(5) unsigned) /
-+> cast (1 as numeric(5) unsigned) from t022t1;
-
-(EXPR)
----------------------
-
- 1.00000
-
---- 1 row(s) selected.
->>select cast (1 as numeric(9) unsigned) /
-+> cast (1 as numeric(9) unsigned) from t022t1;
-
-(EXPR)
----------------------
-
- 1.000000000
-
---- 1 row(s) selected.
->>
->>select cast (1 as double precision) / cast (1 as double precision) from t022t1;
-
-(EXPR)
--------------------------
-
- 1.00000000000000000E+000
-
---- 1 row(s) selected.
->>
->>-- Negative tests.
->>
->>select cast (cast (-10 as smallint) as numeric(1)) from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** 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 numeric(2)) as numeric(1)) from t022t1;
-
-*** 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 smallint unsigned) from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:-10 Target Type:LARGEINT(IBIN64S) Min Target Value:-9. Instruction:RANGE_LOW_S32S64 Operation:RANGE_LOW.
-
---- 0 row(s) selected.
->>select cast (cast (10 as int) as numeric(1)) from t022t1;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_S32S64 Operation:RANGE_HIGH.
-
---- 0 row(s) selected.
->>select cast (cast (-1 as int) as smallint unsigned) from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER SIGNED(MBIN32S) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_S32S64 Operation:RANGE_HIGH.
-
---- 0 row(s) selected.
->>select cast (cast (-100000 as int) as numeric(5)) from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH.
-
---- 0 row(s) selected.
->>select cast (cast (65536 as int unsigned) as smallint unsigned) from t022t1;
-
-*** 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;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:INTEGER UNSIGNED(MBIN32U) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_U32S64 Operation:RANGE_HIGH.
-
---- 0 row(s) selected.
->>select cast (cast (2147483648 as int unsigned) as int) from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:-10 Target Type:LARGEINT(IBIN64S) Min Target Value:-9. Instruction:RANGE_LOW_S64S64 Operation:RANGE_LOW.
-
---- 0 row(s) selected.
->>select cast (cast (10 as largeint) as numeric(1)) from t022t1;
-
-*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Source Type:LARGEINT(MBIN64S) Source Value:10 Target Type:LARGEINT(IBIN64S) Max Target Value:9. Instruction:RANGE_HIGH_S64S64 Operation:RANGE_HIGH.
-
---- 0 row(s) selected.
->>select cast (cast (-1 as largeint) as smallint unsigned) from t022t1;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** 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;
-
-*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
-
---- 0 row(s) selected.
->>select cast (cast (65536 as double precision) as smallint unsigned) from t022t1;
-
-*** 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:6.55360000000000000E+004 to Target Type:SMALLINT UNSIGNED(REC_BIN16_UNSIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (10 as double precision) as numeric(1) unsigned) from t022t1;
-
-*** 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 UNSIGNED(REC_BIN16_UNSIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (-2147483649 as double precision) as int) from t022t1;
-
-*** 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:-2.14748364900000032E+009 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (2147483648 as double precision) as int) from t022t1;
-
-*** 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:2.14748364800000000E+009 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (-100000 as double precision) as numeric(5)) from t022t1;
-
-*** 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:INTEGER SIGNED(REC_BIN32_SIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (100000 as double precision) as numeric(5)) from t022t1;
-
-*** 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.94065645841246528E-319 to Target Type:INTEGER SIGNED(REC_BIN32_SIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (-1 as double precision) as int unsigned) from t022t1;
-
-*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
-
---- 0 row(s) selected.
->>select cast (cast (4294967296 as double precision) as int unsigned) from t022t1;
-
-*** 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.29496729600000000E+009 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (100000 as double precision) as numeric(5) unsigned) from t022t1;
-
-*** 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.94065645841246528E-319 to Target Type:INTEGER UNSIGNED(REC_BIN32_UNSIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (10 as double precision) as decimal(1)) from t022t1;
-
-*** 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:1.00000000000000000E+001 to Target Type:DECIMAL SIGNED(REC_DECIMAL_LSE).
-
---- 0 row(s) selected.
->>select cast (cast (-1 as double precision) as decimal(1) unsigned) from t022t1;
-
-*** 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:-1.00000000000000000E+000 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED).
-
---- 0 row(s) selected.
->>select cast (cast (10 as double precision) as decimal(1) unsigned) from t022t1;
-
-*** 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:1.00000000000000000E+001 to Target Type:DECIMAL UNSIGNED(REC_DECIMAL_UNSIGNED).
-
---- 0 row(s) selected.
->>
->>-- tests for DATE, TIME, TIMESTAMP
->>select cast ('12.07.1961 03.04.55.123456' as timestamp) from t022t2;
-
-(EXPR)
---------------------------
-
-1961-07-12 03:04:55.123456
-1961-07-12 03:04:55.123456
-
---- 2 row(s) selected.
->>select cast ('12.07.1961 03.04.55.123456' as timestamp(3)) from t022t2;
-
-(EXPR)
------------------------
-
-1961-07-12 03:04:55.123
-1961-07-12 03:04:55.123
-
---- 2 row(s) selected.
->>select cast (cast ('12.07.1961 03.04.55.123456' as timestamp) as DATE) from t022t2;
-
-(EXPR)
-----------
-
-1961-07-12
-1961-07-12
-
---- 2 row(s) selected.
->>select cast (cast ('12.07.1961 03.04.55.123456' as timestamp) as char(21)) from t022t2;
-
-(EXPR)
----------------------
-
-1961-07-12 03:04:55.1
-1961-07-12 03:04:55.1
-
---- 2 row(s) selected.
->>select cast ('12/13/1987' as date) from t022t2;
-
-(EXPR)
-----------
-
-1987-12-13
-1987-12-13
-
---- 2 row(s) selected.
->>
->>-- some negative DATE, TIME, TIMESTAMP
->>-- illegal european format
->>select cast ('12.13.1987' as date) from t022t2;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>
->>-- illegal US format
->>select cast ('13/12/1987' as date) from t022t2;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>
->>-- string overflow
->>select cast (cast ('12.07.1961 03:04:55.123456' as timestamp) as char(18)) from t022t2;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>
->>-- Feb. 30th doesn't exist
->>select cast('1997-30-02' as DATE) from t022t2;
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
---- 0 row(s) selected.
->>
->>select interval'0.1'second + timestamp'12/31/9999 11:59:59.9 pm' from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select timestamp'12/31/9999 11:59:59.9 pm' + interval'0.1'second from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select timestamp'01/01/0001 00:00:00.0' + interval-'0.1'second from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select timestamp'01/01/0001 00:00:00.0' - interval'0.1'second from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>
->>select interval'1'month + date'12/31/9999' from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select date'12/31/9999' + interval'1'month from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select date'01/01/0001' + interval-'1'month from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select date'01/01/0001' - interval'1'month from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>
->>select interval'1'month + date'01/31/9999' from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select date'01/31/9999' + interval'1'month from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select date'03/30/9999' + interval-'1'month from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>select date'03/30/9999' - interval'1'month from t022t1;
-
-*** ERROR[8416] A datetime expression evaluated to an invalid datetime value.
-
---- 0 row(s) selected.
->>
->>-- Negative cases to test division by zero.
->>
->>select cast (1 as numeric(1)) / cast (0 as numeric(1)) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(5)) / cast (0 as numeric(1)) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(1)) / cast (0 as numeric(5)) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(5)) / cast (0 as numeric(5)) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero. Operand1 Type:LARGEINT(MBIN64S) Operand1 Value:100000 Operand2 Type:LARGEINT(MBIN64S) Operand2 Value:0. Instruction:DIV_MBIN64S_MBIN64S_MBIN64S Operation:DIV.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(10)) / cast (0 as numeric(10)) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>
->>select cast (1 as numeric(1) unsigned) /
-+> cast (0 as numeric(1) unsigned) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(5) unsigned) /
-+> cast (0 as numeric(1) unsigned) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(1) unsigned) /
-+> cast (0 as numeric(5) unsigned) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(5) unsigned) /
-+> cast (0 as numeric(5) unsigned) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero. Operand1 Type:LARGEINT(MBIN64S) Operand1 Value:100000 Operand2 Type:LARGEINT(MBIN64S) Operand2 Value:0. Instruction:DIV_MBIN64S_MBIN64S_MBIN64S Operation:DIV.
-
---- 0 row(s) selected.
->>select cast (1 as numeric(9) unsigned) /
-+> cast (0 as numeric(9) unsigned) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero. Operand1 Type:LARGEINT(MBIN64S) Operand1 Value:1000000000 Operand2 Type:LARGEINT(MBIN64S) Operand2 Value:0. Instruction:DIV_MBIN64S_MBIN64S_MBIN64S Operation:DIV.
-
---- 0 row(s) selected.
->>
->>select cast (1 as double precision) / cast (0 as double precision) from t022t1;
-
-*** ERROR[8419] An arithmetic expression attempted a division by zero. Operand1 Type:IEEE DOUBLE PRECISION(MFLT64) Operand1 Value:1.00000000000000000E+000 Operand2 Type:IEEE DOUBLE PRECISION(MFLT64) Operand2 Value:0.00000000000000000E+000. Instruction:DIV_MFLT64_MFLT64_MFLT64 Operation:DIV.
-
---- 0 row(s) selected.
->>
->>-- Floating point results are different depending on whether you are
->>-- running on NSK (Tandem floating point) or NT (IEEE floating point)
->>?ifNSK
->>-- results: 0 rows selected
->>select cast('66.2' as float) from t022t1 where cast('66.2' as float) = 66.2;
->>?ifNSK
->>?ifNT
->>-- results: 1 row selected
->>select cast('66.2' as float) from t022t1 where cast('66.2' as float) = 66.2;
-
-(EXPR)
--------------------------
-
- 6.62000000000000128E+001
-
---- 1 row(s) selected.
->>?ifNT
->>
->>-- to test comparisons between signed and unsigned numbers.
->>
->>select * from t022t3 where 2147483647 < a;
-
-A
-----------
-
-4294967295
-3000000000
-
---- 2 row(s) selected.
->>select * from t022t3 where 2147483647 <= a;
-
-A
-----------
-
-4294967295
-3000000000
-
---- 2 row(s) selected.
->>select * from t022t3 where a < 2147483647;
-
---- 0 row(s) selected.
->>select * from t022t3 where a <= 2147483647;
-
---- 0 row(s) selected.
->>select * from t022t3 where a < 0;
-
---- 0 row(s) selected.
->>select * from t022t3 where a <= 0;
-
---- 0 row(s) selected.
->>select * from t022t3 where -1 > a;
-
---- 0 row(s) selected.
->>select * from t022t3 where a > 0;
-
-A
-----------
-
-4294967295
-3000000000
-
---- 2 row(s) selected.
->>select * from t022t3 where a >= 2147483647;
-
-A
-----------
-
-4294967295
-3000000000
-
---- 2 row(s) selected.
->>select * from t022t3 where 2147483647 >= a;
-
---- 0 row(s) selected.
->>select * from t022t3 where a >= 32767;
-
-A
-----------
-
-4294967295
-3000000000
-
---- 2 row(s) selected.
->>
->>select * from t022t4 where b < 3000000000;
-
-A B
------ ------
-
-65535 32767
-
---- 1 row(s) selected.
->>select * from t022t4 where b <= 3000000000;
-
-A B
------ ------
-
-65535 32767
-
---- 1 row(s) selected.
->>select * from t022t4 where b > 3000000000;
-
---- 0 row(s) selected.
->>select * from t022t4 where b >= 3000000000;
-
---- 0 row(s) selected.
->>
->>
->>-- negative test cases
->>-- The next three tests get different results depending on whether they
->>-- are run using SQL/MX or SQL/MP tables. Run them separately
->>?ifMP
->>create table t022t5 (t022t5_c1 numeric( 9) unsigned,
-+> t022t5_c2 numeric(10) unsigned);
->>create table t022t6 (t022t6_c1 decimal( 9) unsigned,
-+> t022t6_c2 decimal(10) unsigned);
->>create table t022t7 (t022t7_c1 dec ( 9) unsigned,
-+> t022t7_c2 dec (10) unsigned);
->>?ifMP
->>
->>?ifMX
->>create table t022t5 (t022t5_c1 numeric( 9) unsigned,
-+> t022t5_c2 numeric(10) unsigned);
-
---- SQL operation complete.
->>create table t022t6 (t022t6_c1 decimal( 9) unsigned,
-+> t022t6_c2 decimal(10) unsigned);
-
-*** ERROR[3008] Precision of DECIMAL UNSIGNED data type, 10, cannot exceed 9.
-
-*** ERROR[8822] The statement was not prepared.
-
->>create table t022t7 (t022t7_c1 dec ( 9) unsigned,
-+> t022t7_c2 dec (10) unsigned);
-
-*** ERROR[3008] Precision of DECIMAL UNSIGNED data type, 10, cannot exceed 9.
-
-*** ERROR[8822] The statement was not prepared.
-
->>?ifMX
->>
->>select cast(1 as numeric(10) unsigned) from (values(0))x;
-
-(EXPR)
------------
-
- 1
-
---- 1 row(s) selected.
->>select cast(1 as decimal(10) unsigned) from (values(0))x;
-
-*** ERROR[3008] Precision of DECIMAL UNSIGNED data type, 10, cannot exceed 9.
-
-*** ERROR[8822] The statement was not prepared.
-
->>select cast(1 as dec (10) unsigned) from (values(0))x;
-
-*** ERROR[3008] Precision of DECIMAL UNSIGNED data type, 10, cannot exceed 9.
-
-*** ERROR[8822] The statement was not prepared.
-
->>
->>
->>-- time/timestamp AM/PM tests (test convDoIt with timestamps)
->>create table t022t8 (c1 timestamp, c2 time);
-
---- SQL operation complete.
->>
->>set param ?p '12/05/1998 03:15:08.123456 pm';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '2015-05-31T14:15:16Z';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '2015-05-31T14:15:16';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '2100-01-01:00:00:47.250000';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '12/05/1998 10:15:08.889 pm';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '06/28/1998 03:15:08 pm';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '02/10/1998 12:15:08.123456 am';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '12/05/1998 03:15:08.123456 am';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '12/05/1998 03:15:08.123456';
->>insert into t022t8 (c1) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>-- expect error since 15 hours and am don't match
->>set param ?p '11/20/1997 15:15:08.123456 am';
->>insert into t022t8 (c1) values ( ?p );
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 11/20/1997 15:15:08.123456 am) cannot be converted to type TIMESTAMP(3).
-
---- 0 row(s) inserted.
->>
->>-- expect an error
->>set param ?p '2100-01-01:ab:00:47.250000';
->>insert into t022t8 (c1) values ( ?p );
-
-*** ERROR[8413] The string argument contains characters that cannot be converted.
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 2100-01-01:ab:00:47.250000) cannot be converted to type TIMESTAMP(3).
-
---- 0 row(s) inserted.
->>
->>-- expect error since the date is not in US format
->>set param ?p '1998-03-12 03:15:08.123456 pm';
->>insert into t022t8 (c1) values ( ?p );
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 1998-03-12 03:15:08.123456 pm) cannot be converted to type TIMESTAMP(3).
-
---- 0 row(s) inserted.
->>
->>-- expect error since the date is not in US format
->>set param ?p '1996-05-23 16:15:08.123 am';
->>insert into t022t8 (c1) values ( ?p );
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 1996-05-23 16:15:08.123 am) cannot be converted to type TIMESTAMP(3).
-
---- 0 row(s) inserted.
->>
->>select c1 from t022t8;
-
-C1
---------------------------
-
-1998-12-05 15:15:08.123456
-2015-05-31 14:15:16.000000
-2015-05-31 14:15:16.000000
-2100-01-01 00:00:47.250000
-1998-12-05 22:15:08.889000
-1998-06-28 15:15:08.000000
-1998-02-10 00:15:08.123456
-1998-12-05 03:15:08.123456
-1998-12-05 03:15:08.123456
-
---- 9 row(s) selected.
->>
->>-- test convDoIt with time
->>set param ?p '03:15:08 pm';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '11:15:08 pm';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '10:15:08 am';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '12:59:59 am';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '10:05:59 am';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '09:00:00 am';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '11:00:00 am';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '08:00:00';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>set param ?p '00:01:00';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>-- expect error
->>set param ?p '00:a1:00';
->>insert into t022t8 (c2) values ( ?p );
-
-*** ERROR[8413] The string argument contains characters that cannot be converted.
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 00:a1:00) cannot be converted to type TIMESTAMP(2).
-
---- 0 row(s) inserted.
->>
->>-- expect error since 14 and am don't match
->>set param ?p '14:59:59 am';
->>insert into t022t8 (c2) values ( ?p );
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 14:59:59 am) cannot be converted to type TIMESTAMP(2).
-
---- 0 row(s) inserted.
->>
->>-- expect error
->>set param ?p '11:60:59 am';
->>insert into t022t8 (c2) values ( ?p );
-
-*** ERROR[8415] The provided DATE, TIME, or TIMESTAMP is not valid and cannot be converted.
-
-*** ERROR[15015] PARAM ?p (value 11:60:59 am) cannot be converted to type TIMESTAMP(2).
-
---- 0 row(s) inserted.
->>
->>-- expect error
->>set param ?p '11:03:33';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>-- expect an error
->>set param ?p '00:01:00.03';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>-- expect an error
->>set param ?p '10:36:52.0781 pm';
->>insert into t022t8 (c2) values ( ?p );
-
---- 1 row(s) inserted.
->>
->>select c2 from t022t8;
-
-C2
---------
-
-?
-?
-?
-?
-?
-?
-?
-?
-?
-15:15:08
-23:15:08
-10:15:08
-00:59:59
-10:05:59
-09:00:00
-11:00:00
-08:00:00
-00:01:00
-11:03:33
-00:01:00
-22:36:52
-
---- 21 row(s) selected.
->>
->>-- test type casting involving the ordering of digits and other symbols
->>-- like - . +
->>
->>-- positive cases
->>select cast('-.3' as int), cast ('+1.4' as int) , cast('-32.3' as int)
-+> from t022t8;
-
-(EXPR) (EXPR) (EXPR)
------------ ----------- -----------
-
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
- 0 1 -32
-
---- 21 row(s) selected.
->>select c1 from t022t8 where cast('-.3' as int) < 1 and cast('+1.5' as int) <2;
-
-C1
---------------------------
-
-1998-12-05 15:15:08.123456
-2015-05-31 14:15:16.000000
-2015-05-31 14:15:16.000000
-2100-01-01 00:00:47.250000
-1998-12-05 22:15:08.889000
-1998-06-28 15:15:08.000000
-1998-02-10 00:15:08.123456
-1998-12-05 03:15:08.123456
-1998-12-05 03:15:08.123456
-?
-?
-?
-?
-?
-?
-?
-?
-?
-?
-?
-?
-
---- 21 row(s) selected.
->>
->>select cast ('123.' as real) ,
-+> cast ('123.12' as real),
-+> cast ('123.E2' as real),
-+> cast ('123.12E2' as real)from (values(1)) as T;
-
-(EXPR) (EXPR) (EXPR) (EXPR)
---------------- --------------- --------------- ---------------
-
- 1.2300000E+002 1.2312000E+002 1.2300000E+004 1.2312000E+004
-
---- 1 row(s) selected.
->>?ifNT
->>obey t022xxx;
->>begin work;
-
---- SQL operation complete.
->>execute insertIntoT022A7 using 0 , 1. ;
-
---- 1 row(s) inserted.
->>execute insertIntoT022A7 using 1 , 2.E3 ;
-
---- 1 row(s) inserted.
->>execute insertIntoT022A7 using 3 , 123.456E2 ;
-
---- 1 row(s) inserted.
->>commit work;
-
---- SQL operation complete.
->>select * from $$TEST_SCHEMA$$.t022a7;
-
-C1 C2
-------------------------- -------------------------
-
- 0.00000000000000000E+000 1.00000000000000000E+000
- 1.00000000000000000E+000 2.00000000000000000E+003
- 3.000000000000
<TRUNCATED>