**createTables starting create table SMALLINT_TAB (c SMALLINT ) create table INTEGER_TAB (c INTEGER ) create table BIGINT_TAB (c BIGINT ) create table DECIMAL_TAB (c DECIMAL(10,5) ) create table REAL_TAB (c REAL ) create table DOUBLE_TAB (c DOUBLE ) create table CHAR_TAB (c CHAR(60) ) create table VARCHAR_TAB (c VARCHAR(60) ) create table LONG_VARCHAR_TAB (c LONG VARCHAR ) create table CHAR_FOR_BIT_DATA_TAB (c CHAR(60) FOR BIT DATA ) create table VARCHAR_FOR_BIT_DATA_TAB (c VARCHAR(60) FOR BIT DATA ) create table LONG_VARCHAR_FOR_BIT_DATA_TAB (c LONG VARCHAR FOR BIT DATA ) create table CLOB_TAB (c CLOB(1k) ) create table DATE_TAB (c DATE ) create table TIME_TAB (c TIME ) create table TIMESTAMP_TAB (c TIMESTAMP ) create table BLOB_TAB (c BLOB(1k) ) **testAssignments starting * testing literal inserts insert into SMALLINT_TAB values( NULL) insert into INTEGER_TAB values( NULL) insert into BIGINT_TAB values( NULL) insert into DECIMAL_TAB values( NULL) insert into REAL_TAB values( NULL) insert into DOUBLE_TAB values( NULL) insert into CHAR_TAB values( NULL) insert into VARCHAR_TAB values( NULL) insert into LONG_VARCHAR_TAB values( NULL) insert into CHAR_FOR_BIT_DATA_TAB values( NULL) insert into VARCHAR_FOR_BIT_DATA_TAB values( NULL) insert into LONG_VARCHAR_FOR_BIT_DATA_TAB values( NULL) insert into CLOB_TAB values( NULL) insert into DATE_TAB values( NULL) insert into TIME_TAB values( NULL) insert into TIMESTAMP_TAB values( NULL) insert into BLOB_TAB values( NULL) insert into SMALLINT_TAB values( 0) insert into INTEGER_TAB values( 11) insert into BIGINT_TAB values( 22) insert into DECIMAL_TAB values( 3.3) insert into REAL_TAB values( 4.4) insert into DOUBLE_TAB values( 5.5) insert into CHAR_TAB values( '7') insert into VARCHAR_TAB values( '8') insert into LONG_VARCHAR_TAB values( '9') insert into CHAR_FOR_BIT_DATA_TAB values( X'10aa') insert into VARCHAR_FOR_BIT_DATA_TAB values( X'10bb') insert into LONG_VARCHAR_FOR_BIT_DATA_TAB values( X'10cc') insert into CLOB_TAB values( '13') insert into DATE_TAB values( '2000-01-01') insert into TIME_TAB values( '15:30:20') insert into TIMESTAMP_TAB values( 'xxxxxxFILTERED-TIMESTAMPxxxxx) insert into BLOB_TAB values( X'01dd') EXPECTED EXCEPTION inserting literal into BLOB . Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS SMALLINT) INSERT INTO INTEGER_TAB VALUES CAST(NULL AS SMALLINT) INSERT INTO BIGINT_TAB VALUES CAST(NULL AS SMALLINT) INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS SMALLINT) INSERT INTO REAL_TAB VALUES CAST(NULL AS SMALLINT) INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS SMALLINT) INSERT INTO CHAR_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'SMALLINT'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'SMALLINT'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'SMALLINT'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'SMALLINT'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'SMALLINT'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'SMALLINT'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'SMALLINT'. INSERT INTO DATE_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'SMALLINT'. INSERT INTO TIME_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'SMALLINT'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'SMALLINT'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'SMALLINT'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS INTEGER) INSERT INTO INTEGER_TAB VALUES CAST(NULL AS INTEGER) INSERT INTO BIGINT_TAB VALUES CAST(NULL AS INTEGER) INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS INTEGER) INSERT INTO REAL_TAB VALUES CAST(NULL AS INTEGER) INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS INTEGER) INSERT INTO CHAR_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'INTEGER'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'INTEGER'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'INTEGER'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'INTEGER'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'INTEGER'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'INTEGER'. INSERT INTO DATE_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'INTEGER'. INSERT INTO TIME_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'INTEGER'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'INTEGER'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'INTEGER'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS BIGINT) INSERT INTO INTEGER_TAB VALUES CAST(NULL AS BIGINT) INSERT INTO BIGINT_TAB VALUES CAST(NULL AS BIGINT) INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS BIGINT) INSERT INTO REAL_TAB VALUES CAST(NULL AS BIGINT) INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS BIGINT) INSERT INTO CHAR_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'BIGINT'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'BIGINT'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'BIGINT'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'BIGINT'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'BIGINT'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'BIGINT'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'BIGINT'. INSERT INTO DATE_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'BIGINT'. INSERT INTO TIME_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'BIGINT'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'BIGINT'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'BIGINT'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS DECIMAL(10,5)) INSERT INTO INTEGER_TAB VALUES CAST(NULL AS DECIMAL(10,5)) INSERT INTO BIGINT_TAB VALUES CAST(NULL AS DECIMAL(10,5)) INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS DECIMAL(10,5)) INSERT INTO REAL_TAB VALUES CAST(NULL AS DECIMAL(10,5)) INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS DECIMAL(10,5)) INSERT INTO CHAR_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'DECIMAL'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'DECIMAL'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'DECIMAL'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'DECIMAL'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'DECIMAL'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'DECIMAL'. INSERT INTO DATE_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'DECIMAL'. INSERT INTO TIME_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'DECIMAL'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'DECIMAL'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'DECIMAL'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS REAL) INSERT INTO INTEGER_TAB VALUES CAST(NULL AS REAL) INSERT INTO BIGINT_TAB VALUES CAST(NULL AS REAL) INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS REAL) INSERT INTO REAL_TAB VALUES CAST(NULL AS REAL) INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS REAL) INSERT INTO CHAR_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'REAL'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'REAL'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'REAL'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'REAL'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'REAL'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'REAL'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'REAL'. INSERT INTO DATE_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'REAL'. INSERT INTO TIME_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'REAL'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'REAL'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'REAL'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS DOUBLE) INSERT INTO INTEGER_TAB VALUES CAST(NULL AS DOUBLE) INSERT INTO BIGINT_TAB VALUES CAST(NULL AS DOUBLE) INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS DOUBLE) INSERT INTO REAL_TAB VALUES CAST(NULL AS DOUBLE) INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS DOUBLE) INSERT INTO CHAR_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'DOUBLE'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'DOUBLE'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'DOUBLE'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'DOUBLE'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'DOUBLE'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'DOUBLE'. INSERT INTO DATE_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'DOUBLE'. INSERT INTO TIME_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'DOUBLE'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'DOUBLE'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'DOUBLE'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'CHAR'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'CHAR'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. INSERT INTO REAL_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'CHAR'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'CHAR'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'CHAR'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'CHAR'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'CHAR'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO DATE_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO TIME_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS CHAR(60)) INSERT INTO BLOB_TAB VALUES CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'CHAR'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'VARCHAR'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'VARCHAR'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'VARCHAR'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'VARCHAR'. INSERT INTO REAL_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'VARCHAR'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'VARCHAR'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'VARCHAR'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'VARCHAR'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'VARCHAR'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO DATE_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO TIME_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS VARCHAR(60)) INSERT INTO BLOB_TAB VALUES CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'VARCHAR'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'LONG VARCHAR'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'LONG VARCHAR'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'LONG VARCHAR'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'LONG VARCHAR'. INSERT INTO REAL_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'LONG VARCHAR'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'LONG VARCHAR'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS LONG VARCHAR) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS LONG VARCHAR) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS LONG VARCHAR) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'LONG VARCHAR'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'LONG VARCHAR'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'LONG VARCHAR'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS LONG VARCHAR) INSERT INTO DATE_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'LONG VARCHAR'. INSERT INTO TIME_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'LONG VARCHAR'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'LONG VARCHAR'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'LONG VARCHAR'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO REAL_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) INSERT INTO CLOB_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO DATE_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO TIME_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO REAL_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) INSERT INTO CLOB_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO DATE_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO TIME_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO REAL_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) INSERT INTO CLOB_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO DATE_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO TIME_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'CLOB'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'CLOB'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'CLOB'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'CLOB'. INSERT INTO REAL_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'CLOB'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'CLOB'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS CLOB(1k)) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS CLOB(1k)) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS CLOB(1k)) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'CLOB'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'CLOB'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'CLOB'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS CLOB(1k)) INSERT INTO DATE_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'CLOB'. INSERT INTO TIME_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'CLOB'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'CLOB'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'CLOB'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'DATE'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'DATE'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'DATE'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'DATE'. INSERT INTO REAL_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'DATE'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'DATE'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS DATE) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS DATE) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'DATE'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'DATE'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'DATE'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'DATE'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'DATE'. INSERT INTO DATE_TAB VALUES CAST(NULL AS DATE) INSERT INTO TIME_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'DATE'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'DATE'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'DATE'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'TIME'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'TIME'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'TIME'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'TIME'. INSERT INTO REAL_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'TIME'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'TIME'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS TIME) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS TIME) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'TIME'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'TIME'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'TIME'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'TIME'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'TIME'. INSERT INTO DATE_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'TIME'. INSERT INTO TIME_TAB VALUES CAST(NULL AS TIME) INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'TIME'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'TIME'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'TIMESTAMP'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'TIMESTAMP'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'TIMESTAMP'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'TIMESTAMP'. INSERT INTO REAL_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'TIMESTAMP'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'TIMESTAMP'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS TIMESTAMP) INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS TIMESTAMP) INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'TIMESTAMP'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'TIMESTAMP'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'TIMESTAMP'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'TIMESTAMP'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'TIMESTAMP'. INSERT INTO DATE_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'TIMESTAMP'. INSERT INTO TIME_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'TIMESTAMP'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS TIMESTAMP) INSERT INTO BLOB_TAB VALUES CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'TIMESTAMP'. INSERT INTO SMALLINT_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'BLOB'. INSERT INTO INTEGER_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'BLOB'. INSERT INTO BIGINT_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'BLOB'. INSERT INTO DECIMAL_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'BLOB'. INSERT INTO REAL_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'BLOB'. INSERT INTO DOUBLE_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'BLOB'. INSERT INTO CHAR_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'BLOB'. INSERT INTO VARCHAR_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'BLOB'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'BLOB'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'BLOB'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'BLOB'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'BLOB'. INSERT INTO CLOB_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'BLOB'. INSERT INTO DATE_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'BLOB'. INSERT INTO TIME_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'BLOB'. INSERT INTO TIMESTAMP_TAB VALUES CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'BLOB'. INSERT INTO BLOB_TAB VALUES CAST(NULL AS BLOB(1k)) INSERT INTO SMALLINT_TAB VALUES CAST(0 AS SMALLINT) INSERT INTO INTEGER_TAB VALUES CAST(0 AS SMALLINT) INSERT INTO BIGINT_TAB VALUES CAST(0 AS SMALLINT) INSERT INTO DECIMAL_TAB VALUES CAST(0 AS SMALLINT) INSERT INTO REAL_TAB VALUES CAST(0 AS SMALLINT) INSERT INTO DOUBLE_TAB VALUES CAST(0 AS SMALLINT) INSERT INTO CHAR_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'SMALLINT'. INSERT INTO VARCHAR_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'SMALLINT'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'SMALLINT'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'SMALLINT'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'SMALLINT'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'SMALLINT'. INSERT INTO CLOB_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'SMALLINT'. INSERT INTO DATE_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'SMALLINT'. INSERT INTO TIME_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'SMALLINT'. INSERT INTO TIMESTAMP_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'SMALLINT'. INSERT INTO BLOB_TAB VALUES CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'SMALLINT'. INSERT INTO SMALLINT_TAB VALUES CAST(11 AS INTEGER) INSERT INTO INTEGER_TAB VALUES CAST(11 AS INTEGER) INSERT INTO BIGINT_TAB VALUES CAST(11 AS INTEGER) INSERT INTO DECIMAL_TAB VALUES CAST(11 AS INTEGER) INSERT INTO REAL_TAB VALUES CAST(11 AS INTEGER) INSERT INTO DOUBLE_TAB VALUES CAST(11 AS INTEGER) INSERT INTO CHAR_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'INTEGER'. INSERT INTO VARCHAR_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'INTEGER'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'INTEGER'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'INTEGER'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'INTEGER'. INSERT INTO CLOB_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'INTEGER'. INSERT INTO DATE_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'INTEGER'. INSERT INTO TIME_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'INTEGER'. INSERT INTO TIMESTAMP_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'INTEGER'. INSERT INTO BLOB_TAB VALUES CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'INTEGER'. INSERT INTO SMALLINT_TAB VALUES CAST(22 AS BIGINT) INSERT INTO INTEGER_TAB VALUES CAST(22 AS BIGINT) INSERT INTO BIGINT_TAB VALUES CAST(22 AS BIGINT) INSERT INTO DECIMAL_TAB VALUES CAST(22 AS BIGINT) INSERT INTO REAL_TAB VALUES CAST(22 AS BIGINT) INSERT INTO DOUBLE_TAB VALUES CAST(22 AS BIGINT) INSERT INTO CHAR_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'BIGINT'. INSERT INTO VARCHAR_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'BIGINT'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'BIGINT'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'BIGINT'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'BIGINT'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'BIGINT'. INSERT INTO CLOB_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'BIGINT'. INSERT INTO DATE_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'BIGINT'. INSERT INTO TIME_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'BIGINT'. INSERT INTO TIMESTAMP_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'BIGINT'. INSERT INTO BLOB_TAB VALUES CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'BIGINT'. INSERT INTO SMALLINT_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) INSERT INTO INTEGER_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) INSERT INTO BIGINT_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) INSERT INTO DECIMAL_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) INSERT INTO REAL_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) INSERT INTO DOUBLE_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) INSERT INTO CHAR_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'DECIMAL'. INSERT INTO VARCHAR_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'DECIMAL'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'DECIMAL'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'DECIMAL'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'DECIMAL'. INSERT INTO CLOB_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'DECIMAL'. INSERT INTO DATE_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'DECIMAL'. INSERT INTO TIME_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'DECIMAL'. INSERT INTO TIMESTAMP_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'DECIMAL'. INSERT INTO BLOB_TAB VALUES CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'DECIMAL'. INSERT INTO SMALLINT_TAB VALUES CAST(4.4 AS REAL) INSERT INTO INTEGER_TAB VALUES CAST(4.4 AS REAL) INSERT INTO BIGINT_TAB VALUES CAST(4.4 AS REAL) INSERT INTO DECIMAL_TAB VALUES CAST(4.4 AS REAL) INSERT INTO REAL_TAB VALUES CAST(4.4 AS REAL) INSERT INTO DOUBLE_TAB VALUES CAST(4.4 AS REAL) INSERT INTO CHAR_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'REAL'. INSERT INTO VARCHAR_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'REAL'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'REAL'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'REAL'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'REAL'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'REAL'. INSERT INTO CLOB_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'REAL'. INSERT INTO DATE_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'REAL'. INSERT INTO TIME_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'REAL'. INSERT INTO TIMESTAMP_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'REAL'. INSERT INTO BLOB_TAB VALUES CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'REAL'. INSERT INTO SMALLINT_TAB VALUES CAST(5.5 AS DOUBLE) INSERT INTO INTEGER_TAB VALUES CAST(5.5 AS DOUBLE) INSERT INTO BIGINT_TAB VALUES CAST(5.5 AS DOUBLE) INSERT INTO DECIMAL_TAB VALUES CAST(5.5 AS DOUBLE) INSERT INTO REAL_TAB VALUES CAST(5.5 AS DOUBLE) INSERT INTO DOUBLE_TAB VALUES CAST(5.5 AS DOUBLE) INSERT INTO CHAR_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'DOUBLE'. INSERT INTO VARCHAR_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'DOUBLE'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'DOUBLE'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'DOUBLE'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'DOUBLE'. INSERT INTO CLOB_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'DOUBLE'. INSERT INTO DATE_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'DOUBLE'. INSERT INTO TIME_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'DOUBLE'. INSERT INTO TIMESTAMP_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'DOUBLE'. INSERT INTO BLOB_TAB VALUES CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'DOUBLE'. INSERT INTO SMALLINT_TAB VALUES CAST('0' AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. INSERT INTO INTEGER_TAB VALUES CAST('11' AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'CHAR'. INSERT INTO BIGINT_TAB VALUES CAST('22' AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'CHAR'. INSERT INTO DECIMAL_TAB VALUES CAST('3.3' AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. INSERT INTO REAL_TAB VALUES CAST('4.4' AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'CHAR'. INSERT INTO DOUBLE_TAB VALUES CAST('5.5' AS CHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'CHAR'. INSERT INTO CHAR_TAB VALUES CAST('7' AS CHAR(60)) INSERT INTO VARCHAR_TAB VALUES CAST('8' AS CHAR(60)) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('9' AS CHAR(60)) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10aa' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10bb' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10cc' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. INSERT INTO CLOB_TAB VALUES CAST('13' AS CHAR(60)) INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS CHAR(60)) INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS CHAR(60)) INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS CHAR(60)) INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. INSERT INTO SMALLINT_TAB VALUES CAST('0' AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'VARCHAR'. INSERT INTO INTEGER_TAB VALUES CAST('11' AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'VARCHAR'. INSERT INTO BIGINT_TAB VALUES CAST('22' AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'VARCHAR'. INSERT INTO DECIMAL_TAB VALUES CAST('3.3' AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'VARCHAR'. INSERT INTO REAL_TAB VALUES CAST('4.4' AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'VARCHAR'. INSERT INTO DOUBLE_TAB VALUES CAST('5.5' AS VARCHAR(60)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'VARCHAR'. INSERT INTO CHAR_TAB VALUES CAST('7' AS VARCHAR(60)) INSERT INTO VARCHAR_TAB VALUES CAST('8' AS VARCHAR(60)) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('9' AS VARCHAR(60)) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10aa' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10bb' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10cc' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. INSERT INTO CLOB_TAB VALUES CAST('13' AS VARCHAR(60)) INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS VARCHAR(60)) INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS VARCHAR(60)) INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS VARCHAR(60)) INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. INSERT INTO SMALLINT_TAB VALUES CAST('0' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'LONG VARCHAR'. INSERT INTO INTEGER_TAB VALUES CAST('11' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'LONG VARCHAR'. INSERT INTO BIGINT_TAB VALUES CAST('22' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'LONG VARCHAR'. INSERT INTO DECIMAL_TAB VALUES CAST('3.3' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'LONG VARCHAR'. INSERT INTO REAL_TAB VALUES CAST('4.4' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'LONG VARCHAR'. INSERT INTO DOUBLE_TAB VALUES CAST('5.5' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'LONG VARCHAR'. INSERT INTO CHAR_TAB VALUES CAST('7' AS LONG VARCHAR) INSERT INTO VARCHAR_TAB VALUES CAST('8' AS LONG VARCHAR) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('9' AS LONG VARCHAR) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10aa' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10bb' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10cc' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. INSERT INTO CLOB_TAB VALUES CAST('13' AS LONG VARCHAR) INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'LONG VARCHAR'. INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'LONG VARCHAR'. INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS LONG VARCHAR) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'LONG VARCHAR'. INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. INSERT INTO SMALLINT_TAB VALUES CAST('0' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO INTEGER_TAB VALUES CAST('11' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO BIGINT_TAB VALUES CAST('22' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO DECIMAL_TAB VALUES CAST('3.3' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO REAL_TAB VALUES CAST('4.4' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO DOUBLE_TAB VALUES CAST('5.5' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO CHAR_TAB VALUES CAST('7' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO VARCHAR_TAB VALUES CAST('8' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST('9' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10aa' AS CHAR(60) FOR BIT DATA) INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10bb' AS CHAR(60) FOR BIT DATA) INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10cc' AS CHAR(60) FOR BIT DATA) INSERT INTO CLOB_TAB VALUES CAST('13' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST('0' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO INTEGER_TAB VALUES CAST('11' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO BIGINT_TAB VALUES CAST('22' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO DECIMAL_TAB VALUES CAST('3.3' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO REAL_TAB VALUES CAST('4.4' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO DOUBLE_TAB VALUES CAST('5.5' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO CHAR_TAB VALUES CAST('7' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO VARCHAR_TAB VALUES CAST('8' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST('9' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10aa' AS VARCHAR(60) FOR BIT DATA) INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10bb' AS VARCHAR(60) FOR BIT DATA) INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10cc' AS VARCHAR(60) FOR BIT DATA) INSERT INTO CLOB_TAB VALUES CAST('13' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'VARCHAR () FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST('0' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO INTEGER_TAB VALUES CAST('11' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO BIGINT_TAB VALUES CAST('22' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO DECIMAL_TAB VALUES CAST('3.3' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO REAL_TAB VALUES CAST('4.4' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO DOUBLE_TAB VALUES CAST('5.5' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO CHAR_TAB VALUES CAST('7' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO VARCHAR_TAB VALUES CAST('8' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST('9' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10aa' AS LONG VARCHAR FOR BIT DATA) INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10bb' AS LONG VARCHAR FOR BIT DATA) INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'10cc' AS LONG VARCHAR FOR BIT DATA) INSERT INTO CLOB_TAB VALUES CAST('13' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'LONG VARCHAR FOR BIT DATA'. INSERT INTO SMALLINT_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'CLOB'. INSERT INTO INTEGER_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'CLOB'. INSERT INTO BIGINT_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'CLOB'. INSERT INTO DECIMAL_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'CLOB'. INSERT INTO REAL_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'CLOB'. INSERT INTO DOUBLE_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'CLOB'. INSERT INTO CHAR_TAB VALUES CAST('13' AS CLOB(1k)) INSERT INTO VARCHAR_TAB VALUES CAST('13' AS CLOB(1k)) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('13' AS CLOB(1k)) INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'CLOB'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'CLOB'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'CLOB'. INSERT INTO CLOB_TAB VALUES CAST('13' AS CLOB(1k)) INSERT INTO DATE_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'CLOB'. INSERT INTO TIME_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'CLOB'. INSERT INTO TIMESTAMP_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'CLOB'. INSERT INTO BLOB_TAB VALUES CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'CLOB'. INSERT INTO SMALLINT_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'DATE'. INSERT INTO INTEGER_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'DATE'. INSERT INTO BIGINT_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'DATE'. INSERT INTO DECIMAL_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'DATE'. INSERT INTO REAL_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'DATE'. INSERT INTO DOUBLE_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'DATE'. INSERT INTO CHAR_TAB VALUES CAST('2000-01-01' AS DATE) INSERT INTO VARCHAR_TAB VALUES CAST('2000-01-01' AS DATE) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'DATE'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'DATE'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'DATE'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'DATE'. INSERT INTO CLOB_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'DATE'. INSERT INTO DATE_TAB VALUES CAST('2000-01-01' AS DATE) INSERT INTO TIME_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'DATE'. INSERT INTO TIMESTAMP_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'DATE'. INSERT INTO BLOB_TAB VALUES CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'DATE'. INSERT INTO SMALLINT_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'TIME'. INSERT INTO INTEGER_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'TIME'. INSERT INTO BIGINT_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'TIME'. INSERT INTO DECIMAL_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'TIME'. INSERT INTO REAL_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'TIME'. INSERT INTO DOUBLE_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'TIME'. INSERT INTO CHAR_TAB VALUES CAST('15:30:20' AS TIME) INSERT INTO VARCHAR_TAB VALUES CAST('15:30:20' AS TIME) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'TIME'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'TIME'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'TIME'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'TIME'. INSERT INTO CLOB_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'TIME'. INSERT INTO DATE_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'TIME'. INSERT INTO TIME_TAB VALUES CAST('15:30:20' AS TIME) INSERT INTO TIMESTAMP_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'TIME'. INSERT INTO BLOB_TAB VALUES CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'TIME'. INSERT INTO SMALLINT_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'TIMESTAMP'. INSERT INTO INTEGER_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'TIMESTAMP'. INSERT INTO BIGINT_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'TIMESTAMP'. INSERT INTO DECIMAL_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'TIMESTAMP'. INSERT INTO REAL_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'TIMESTAMP'. INSERT INTO DOUBLE_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'TIMESTAMP'. INSERT INTO CHAR_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) INSERT INTO VARCHAR_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) INSERT INTO LONG_VARCHAR_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'TIMESTAMP'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'TIMESTAMP'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'TIMESTAMP'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'TIMESTAMP'. INSERT INTO CLOB_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'TIMESTAMP'. INSERT INTO DATE_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'TIMESTAMP'. INSERT INTO TIME_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'TIMESTAMP'. INSERT INTO TIMESTAMP_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) INSERT INTO BLOB_TAB VALUES CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42821:Columns of type 'BLOB' cannot hold values of type 'TIMESTAMP'. INSERT INTO SMALLINT_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'SMALLINT' cannot hold values of type 'BLOB'. INSERT INTO INTEGER_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'INTEGER' cannot hold values of type 'BLOB'. INSERT INTO BIGINT_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'BIGINT' cannot hold values of type 'BLOB'. INSERT INTO DECIMAL_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DECIMAL' cannot hold values of type 'BLOB'. INSERT INTO REAL_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'REAL' cannot hold values of type 'BLOB'. INSERT INTO DOUBLE_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DOUBLE' cannot hold values of type 'BLOB'. INSERT INTO CHAR_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR' cannot hold values of type 'BLOB'. INSERT INTO VARCHAR_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR' cannot hold values of type 'BLOB'. INSERT INTO LONG_VARCHAR_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR' cannot hold values of type 'BLOB'. INSERT INTO CHAR_FOR_BIT_DATA_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CHAR () FOR BIT DATA' cannot hold values of type 'BLOB'. INSERT INTO VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'VARCHAR () FOR BIT DATA' cannot hold values of type 'BLOB'. INSERT INTO LONG_VARCHAR_FOR_BIT_DATA_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'LONG VARCHAR FOR BIT DATA' cannot hold values of type 'BLOB'. INSERT INTO CLOB_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'CLOB' cannot hold values of type 'BLOB'. INSERT INTO DATE_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'DATE' cannot hold values of type 'BLOB'. INSERT INTO TIME_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIME' cannot hold values of type 'BLOB'. INSERT INTO TIMESTAMP_TAB VALUES CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42821:Columns of type 'TIMESTAMP' cannot hold values of type 'BLOB'. INSERT INTO BLOB_TAB VALUES CAST(X'01dd' AS BLOB(1k)) **testExplicitCasts starting Test #1 VALUES CAST (CAST (NULL AS SMALLINT) AS SMALLINT ) 1 ------ NULL Test #2 VALUES CAST (CAST (NULL AS SMALLINT) AS INTEGER ) 1 ----------- NULL Test #3 VALUES CAST (CAST (NULL AS SMALLINT) AS BIGINT ) 1 -------------------- NULL Test #4 VALUES CAST (CAST (NULL AS SMALLINT) AS DECIMAL(10,5) ) 1 ------------ NULL Test #5 VALUES CAST (CAST (NULL AS SMALLINT) AS REAL ) 1 ------------- NULL Test #6 VALUES CAST (CAST (NULL AS SMALLINT) AS DOUBLE ) 1 ---------------------- NULL Test #7 VALUES CAST (CAST (NULL AS SMALLINT) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #8 VALUES CAST (CAST (NULL AS SMALLINT) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'VARCHAR'. Test #9 VALUES CAST (CAST (NULL AS SMALLINT) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'LONG VARCHAR'. Test #10 VALUES CAST (CAST (NULL AS SMALLINT) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'CHAR () FOR BIT DATA'. Test #11 VALUES CAST (CAST (NULL AS SMALLINT) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'VARCHAR () FOR BIT DATA'. Test #12 VALUES CAST (CAST (NULL AS SMALLINT) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'LONG VARCHAR FOR BIT DATA'. Test #13 VALUES CAST (CAST (NULL AS SMALLINT) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'CLOB'. Test #14 VALUES CAST (CAST (NULL AS SMALLINT) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'DATE'. Test #15 VALUES CAST (CAST (NULL AS SMALLINT) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'TIME'. Test #16 VALUES CAST (CAST (NULL AS SMALLINT) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'TIMESTAMP'. Test #17 VALUES CAST (CAST (NULL AS SMALLINT) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'BLOB'. Test #18 VALUES CAST (CAST (0 AS SMALLINT) AS SMALLINT ) 1 ------ 0 Test #19 VALUES CAST (CAST (0 AS SMALLINT) AS INTEGER ) 1 ----------- 0 Test #20 VALUES CAST (CAST (0 AS SMALLINT) AS BIGINT ) 1 -------------------- 0 Test #21 VALUES CAST (CAST (0 AS SMALLINT) AS DECIMAL(10,5) ) 1 ------------ 0.00000 Test #22 VALUES CAST (CAST (0 AS SMALLINT) AS REAL ) 1 ------------- 0.0 Test #23 VALUES CAST (CAST (0 AS SMALLINT) AS DOUBLE ) 1 ---------------------- 0.0 Test #24 VALUES CAST (CAST (0 AS SMALLINT) AS CHAR(60) ) 1 ------------------------------------------------------------ 0 Test #25 VALUES CAST (CAST (0 AS SMALLINT) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'VARCHAR'. Test #26 VALUES CAST (CAST (0 AS SMALLINT) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'LONG VARCHAR'. Test #27 VALUES CAST (CAST (0 AS SMALLINT) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'CHAR () FOR BIT DATA'. Test #28 VALUES CAST (CAST (0 AS SMALLINT) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'VARCHAR () FOR BIT DATA'. Test #29 VALUES CAST (CAST (0 AS SMALLINT) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'LONG VARCHAR FOR BIT DATA'. Test #30 VALUES CAST (CAST (0 AS SMALLINT) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'CLOB'. Test #31 VALUES CAST (CAST (0 AS SMALLINT) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'DATE'. Test #32 VALUES CAST (CAST (0 AS SMALLINT) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'TIME'. Test #33 VALUES CAST (CAST (0 AS SMALLINT) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'TIMESTAMP'. Test #34 VALUES CAST (CAST (0 AS SMALLINT) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'SMALLINT' to 'BLOB'. Test #35 VALUES CAST (CAST (NULL AS INTEGER) AS SMALLINT ) 1 ------ NULL Test #36 VALUES CAST (CAST (NULL AS INTEGER) AS INTEGER ) 1 ----------- NULL Test #37 VALUES CAST (CAST (NULL AS INTEGER) AS BIGINT ) 1 -------------------- NULL Test #38 VALUES CAST (CAST (NULL AS INTEGER) AS DECIMAL(10,5) ) 1 ------------ NULL Test #39 VALUES CAST (CAST (NULL AS INTEGER) AS REAL ) 1 ------------- NULL Test #40 VALUES CAST (CAST (NULL AS INTEGER) AS DOUBLE ) 1 ---------------------- NULL Test #41 VALUES CAST (CAST (NULL AS INTEGER) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #42 VALUES CAST (CAST (NULL AS INTEGER) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'VARCHAR'. Test #43 VALUES CAST (CAST (NULL AS INTEGER) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'LONG VARCHAR'. Test #44 VALUES CAST (CAST (NULL AS INTEGER) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. Test #45 VALUES CAST (CAST (NULL AS INTEGER) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'VARCHAR () FOR BIT DATA'. Test #46 VALUES CAST (CAST (NULL AS INTEGER) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'LONG VARCHAR FOR BIT DATA'. Test #47 VALUES CAST (CAST (NULL AS INTEGER) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'CLOB'. Test #48 VALUES CAST (CAST (NULL AS INTEGER) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'DATE'. Test #49 VALUES CAST (CAST (NULL AS INTEGER) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'TIME'. Test #50 VALUES CAST (CAST (NULL AS INTEGER) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'TIMESTAMP'. Test #51 VALUES CAST (CAST (NULL AS INTEGER) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'BLOB'. Test #52 VALUES CAST (CAST (11 AS INTEGER) AS SMALLINT ) 1 ------ 11 Test #53 VALUES CAST (CAST (11 AS INTEGER) AS INTEGER ) 1 ----------- 11 Test #54 VALUES CAST (CAST (11 AS INTEGER) AS BIGINT ) 1 -------------------- 11 Test #55 VALUES CAST (CAST (11 AS INTEGER) AS DECIMAL(10,5) ) 1 ------------ 11.00000 Test #56 VALUES CAST (CAST (11 AS INTEGER) AS REAL ) 1 ------------- 11.0 Test #57 VALUES CAST (CAST (11 AS INTEGER) AS DOUBLE ) 1 ---------------------- 11.0 Test #58 VALUES CAST (CAST (11 AS INTEGER) AS CHAR(60) ) 1 ------------------------------------------------------------ 11 Test #59 VALUES CAST (CAST (11 AS INTEGER) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'VARCHAR'. Test #60 VALUES CAST (CAST (11 AS INTEGER) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'LONG VARCHAR'. Test #61 VALUES CAST (CAST (11 AS INTEGER) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. Test #62 VALUES CAST (CAST (11 AS INTEGER) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'VARCHAR () FOR BIT DATA'. Test #63 VALUES CAST (CAST (11 AS INTEGER) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'LONG VARCHAR FOR BIT DATA'. Test #64 VALUES CAST (CAST (11 AS INTEGER) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'CLOB'. Test #65 VALUES CAST (CAST (11 AS INTEGER) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'DATE'. Test #66 VALUES CAST (CAST (11 AS INTEGER) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'TIME'. Test #67 VALUES CAST (CAST (11 AS INTEGER) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'TIMESTAMP'. Test #68 VALUES CAST (CAST (11 AS INTEGER) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'INTEGER' to 'BLOB'. Test #69 VALUES CAST (CAST (NULL AS BIGINT) AS SMALLINT ) 1 ------ NULL Test #70 VALUES CAST (CAST (NULL AS BIGINT) AS INTEGER ) 1 ----------- NULL Test #71 VALUES CAST (CAST (NULL AS BIGINT) AS BIGINT ) 1 -------------------- NULL Test #72 VALUES CAST (CAST (NULL AS BIGINT) AS DECIMAL(10,5) ) 1 ------------ NULL Test #73 VALUES CAST (CAST (NULL AS BIGINT) AS REAL ) 1 ------------- NULL Test #74 VALUES CAST (CAST (NULL AS BIGINT) AS DOUBLE ) 1 ---------------------- NULL Test #75 VALUES CAST (CAST (NULL AS BIGINT) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #76 VALUES CAST (CAST (NULL AS BIGINT) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'VARCHAR'. Test #77 VALUES CAST (CAST (NULL AS BIGINT) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'LONG VARCHAR'. Test #78 VALUES CAST (CAST (NULL AS BIGINT) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'CHAR () FOR BIT DATA'. Test #79 VALUES CAST (CAST (NULL AS BIGINT) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'VARCHAR () FOR BIT DATA'. Test #80 VALUES CAST (CAST (NULL AS BIGINT) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'LONG VARCHAR FOR BIT DATA'. Test #81 VALUES CAST (CAST (NULL AS BIGINT) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'CLOB'. Test #82 VALUES CAST (CAST (NULL AS BIGINT) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'DATE'. Test #83 VALUES CAST (CAST (NULL AS BIGINT) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'TIME'. Test #84 VALUES CAST (CAST (NULL AS BIGINT) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'TIMESTAMP'. Test #85 VALUES CAST (CAST (NULL AS BIGINT) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'BLOB'. Test #86 VALUES CAST (CAST (22 AS BIGINT) AS SMALLINT ) 1 ------ 22 Test #87 VALUES CAST (CAST (22 AS BIGINT) AS INTEGER ) 1 ----------- 22 Test #88 VALUES CAST (CAST (22 AS BIGINT) AS BIGINT ) 1 -------------------- 22 Test #89 VALUES CAST (CAST (22 AS BIGINT) AS DECIMAL(10,5) ) 1 ------------ 22.00000 Test #90 VALUES CAST (CAST (22 AS BIGINT) AS REAL ) 1 ------------- 22.0 Test #91 VALUES CAST (CAST (22 AS BIGINT) AS DOUBLE ) 1 ---------------------- 22.0 Test #92 VALUES CAST (CAST (22 AS BIGINT) AS CHAR(60) ) 1 ------------------------------------------------------------ 22 Test #93 VALUES CAST (CAST (22 AS BIGINT) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'VARCHAR'. Test #94 VALUES CAST (CAST (22 AS BIGINT) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'LONG VARCHAR'. Test #95 VALUES CAST (CAST (22 AS BIGINT) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'CHAR () FOR BIT DATA'. Test #96 VALUES CAST (CAST (22 AS BIGINT) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'VARCHAR () FOR BIT DATA'. Test #97 VALUES CAST (CAST (22 AS BIGINT) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'LONG VARCHAR FOR BIT DATA'. Test #98 VALUES CAST (CAST (22 AS BIGINT) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'CLOB'. Test #99 VALUES CAST (CAST (22 AS BIGINT) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'DATE'. Test #100 VALUES CAST (CAST (22 AS BIGINT) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'TIME'. Test #101 VALUES CAST (CAST (22 AS BIGINT) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'TIMESTAMP'. Test #102 VALUES CAST (CAST (22 AS BIGINT) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BIGINT' to 'BLOB'. Test #103 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS SMALLINT ) 1 ------ NULL Test #104 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS INTEGER ) 1 ----------- NULL Test #105 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS BIGINT ) 1 -------------------- NULL Test #106 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS DECIMAL(10,5) ) 1 ------------ NULL Test #107 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS REAL ) 1 ------------- NULL Test #108 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS DOUBLE ) 1 ---------------------- NULL Test #109 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #110 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'VARCHAR'. Test #111 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'LONG VARCHAR'. Test #112 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'CHAR () FOR BIT DATA'. Test #113 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'VARCHAR () FOR BIT DATA'. Test #114 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'LONG VARCHAR FOR BIT DATA'. Test #115 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'CLOB'. Test #116 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'DATE'. Test #117 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'TIME'. Test #118 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'TIMESTAMP'. Test #119 VALUES CAST (CAST (NULL AS DECIMAL(10,5)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'BLOB'. Test #120 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS SMALLINT ) 1 ------ 3 Test #121 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS INTEGER ) 1 ----------- 3 Test #122 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS BIGINT ) 1 -------------------- 3 Test #123 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS DECIMAL(10,5) ) 1 ------------ 3.30000 Test #124 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS REAL ) 1 ------------- 3.3 Test #125 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS DOUBLE ) 1 ---------------------- 3.3 Test #126 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS CHAR(60) ) 1 ------------------------------------------------------------ 3.30000 Test #127 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'VARCHAR'. Test #128 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'LONG VARCHAR'. Test #129 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'CHAR () FOR BIT DATA'. Test #130 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'VARCHAR () FOR BIT DATA'. Test #131 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'LONG VARCHAR FOR BIT DATA'. Test #132 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'CLOB'. Test #133 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'DATE'. Test #134 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'TIME'. Test #135 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'TIMESTAMP'. Test #136 VALUES CAST (CAST (3.3 AS DECIMAL(10,5)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DECIMAL' to 'BLOB'. Test #137 VALUES CAST (CAST (NULL AS REAL) AS SMALLINT ) 1 ------ NULL Test #138 VALUES CAST (CAST (NULL AS REAL) AS INTEGER ) 1 ----------- NULL Test #139 VALUES CAST (CAST (NULL AS REAL) AS BIGINT ) 1 -------------------- NULL Test #140 VALUES CAST (CAST (NULL AS REAL) AS DECIMAL(10,5) ) 1 ------------ NULL Test #141 VALUES CAST (CAST (NULL AS REAL) AS REAL ) 1 ------------- NULL Test #142 VALUES CAST (CAST (NULL AS REAL) AS DOUBLE ) 1 ---------------------- NULL Test #143 VALUES CAST (CAST (NULL AS REAL) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'CHAR'. Test #144 VALUES CAST (CAST (NULL AS REAL) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'VARCHAR'. Test #145 VALUES CAST (CAST (NULL AS REAL) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'LONG VARCHAR'. Test #146 VALUES CAST (CAST (NULL AS REAL) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'CHAR () FOR BIT DATA'. Test #147 VALUES CAST (CAST (NULL AS REAL) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'VARCHAR () FOR BIT DATA'. Test #148 VALUES CAST (CAST (NULL AS REAL) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'LONG VARCHAR FOR BIT DATA'. Test #149 VALUES CAST (CAST (NULL AS REAL) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'CLOB'. Test #150 VALUES CAST (CAST (NULL AS REAL) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'DATE'. Test #151 VALUES CAST (CAST (NULL AS REAL) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'TIME'. Test #152 VALUES CAST (CAST (NULL AS REAL) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'TIMESTAMP'. Test #153 VALUES CAST (CAST (NULL AS REAL) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'BLOB'. Test #154 VALUES CAST (CAST (4.4 AS REAL) AS SMALLINT ) 1 ------ 4 Test #155 VALUES CAST (CAST (4.4 AS REAL) AS INTEGER ) 1 ----------- 4 Test #156 VALUES CAST (CAST (4.4 AS REAL) AS BIGINT ) 1 -------------------- 4 Test #157 VALUES CAST (CAST (4.4 AS REAL) AS DECIMAL(10,5) ) 1 ------------ 4.40000 Test #158 VALUES CAST (CAST (4.4 AS REAL) AS REAL ) 1 ------------- 4.4 Test #159 VALUES CAST (CAST (4.4 AS REAL) AS DOUBLE ) 1 ---------------------- 4.400000095367432 Test #160 VALUES CAST (CAST (4.4 AS REAL) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'CHAR'. Test #161 VALUES CAST (CAST (4.4 AS REAL) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'VARCHAR'. Test #162 VALUES CAST (CAST (4.4 AS REAL) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'LONG VARCHAR'. Test #163 VALUES CAST (CAST (4.4 AS REAL) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'CHAR () FOR BIT DATA'. Test #164 VALUES CAST (CAST (4.4 AS REAL) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'VARCHAR () FOR BIT DATA'. Test #165 VALUES CAST (CAST (4.4 AS REAL) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'LONG VARCHAR FOR BIT DATA'. Test #166 VALUES CAST (CAST (4.4 AS REAL) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'CLOB'. Test #167 VALUES CAST (CAST (4.4 AS REAL) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'DATE'. Test #168 VALUES CAST (CAST (4.4 AS REAL) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'TIME'. Test #169 VALUES CAST (CAST (4.4 AS REAL) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'TIMESTAMP'. Test #170 VALUES CAST (CAST (4.4 AS REAL) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'REAL' to 'BLOB'. Test #171 VALUES CAST (CAST (NULL AS DOUBLE) AS SMALLINT ) 1 ------ NULL Test #172 VALUES CAST (CAST (NULL AS DOUBLE) AS INTEGER ) 1 ----------- NULL Test #173 VALUES CAST (CAST (NULL AS DOUBLE) AS BIGINT ) 1 -------------------- NULL Test #174 VALUES CAST (CAST (NULL AS DOUBLE) AS DECIMAL(10,5) ) 1 ------------ NULL Test #175 VALUES CAST (CAST (NULL AS DOUBLE) AS REAL ) 1 ------------- NULL Test #176 VALUES CAST (CAST (NULL AS DOUBLE) AS DOUBLE ) 1 ---------------------- NULL Test #177 VALUES CAST (CAST (NULL AS DOUBLE) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'CHAR'. Test #178 VALUES CAST (CAST (NULL AS DOUBLE) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'VARCHAR'. Test #179 VALUES CAST (CAST (NULL AS DOUBLE) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'LONG VARCHAR'. Test #180 VALUES CAST (CAST (NULL AS DOUBLE) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'CHAR () FOR BIT DATA'. Test #181 VALUES CAST (CAST (NULL AS DOUBLE) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'VARCHAR () FOR BIT DATA'. Test #182 VALUES CAST (CAST (NULL AS DOUBLE) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'LONG VARCHAR FOR BIT DATA'. Test #183 VALUES CAST (CAST (NULL AS DOUBLE) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'CLOB'. Test #184 VALUES CAST (CAST (NULL AS DOUBLE) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'DATE'. Test #185 VALUES CAST (CAST (NULL AS DOUBLE) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'TIME'. Test #186 VALUES CAST (CAST (NULL AS DOUBLE) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'TIMESTAMP'. Test #187 VALUES CAST (CAST (NULL AS DOUBLE) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'BLOB'. Test #188 VALUES CAST (CAST (5.5 AS DOUBLE) AS SMALLINT ) 1 ------ 5 Test #189 VALUES CAST (CAST (5.5 AS DOUBLE) AS INTEGER ) 1 ----------- 5 Test #190 VALUES CAST (CAST (5.5 AS DOUBLE) AS BIGINT ) 1 -------------------- 5 Test #191 VALUES CAST (CAST (5.5 AS DOUBLE) AS DECIMAL(10,5) ) 1 ------------ 5.50000 Test #192 VALUES CAST (CAST (5.5 AS DOUBLE) AS REAL ) 1 ------------- 5.5 Test #193 VALUES CAST (CAST (5.5 AS DOUBLE) AS DOUBLE ) 1 ---------------------- 5.5 Test #194 VALUES CAST (CAST (5.5 AS DOUBLE) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'CHAR'. Test #195 VALUES CAST (CAST (5.5 AS DOUBLE) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'VARCHAR'. Test #196 VALUES CAST (CAST (5.5 AS DOUBLE) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'LONG VARCHAR'. Test #197 VALUES CAST (CAST (5.5 AS DOUBLE) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'CHAR () FOR BIT DATA'. Test #198 VALUES CAST (CAST (5.5 AS DOUBLE) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'VARCHAR () FOR BIT DATA'. Test #199 VALUES CAST (CAST (5.5 AS DOUBLE) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'LONG VARCHAR FOR BIT DATA'. Test #200 VALUES CAST (CAST (5.5 AS DOUBLE) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'CLOB'. Test #201 VALUES CAST (CAST (5.5 AS DOUBLE) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'DATE'. Test #202 VALUES CAST (CAST (5.5 AS DOUBLE) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'TIME'. Test #203 VALUES CAST (CAST (5.5 AS DOUBLE) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'TIMESTAMP'. Test #204 VALUES CAST (CAST (5.5 AS DOUBLE) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DOUBLE' to 'BLOB'. Test #205 VALUES CAST (CAST (NULL AS CHAR(60)) AS SMALLINT ) 1 ------ NULL Test #206 VALUES CAST (CAST (NULL AS CHAR(60)) AS INTEGER ) 1 ----------- NULL Test #207 VALUES CAST (CAST (NULL AS CHAR(60)) AS BIGINT ) 1 -------------------- NULL Test #208 VALUES CAST (CAST (NULL AS CHAR(60)) AS DECIMAL(10,5) ) 1 ------------ NULL Test #209 VALUES CAST (CAST (NULL AS CHAR(60)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'REAL'. Test #210 VALUES CAST (CAST (NULL AS CHAR(60)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'DOUBLE'. Test #211 VALUES CAST (CAST (NULL AS CHAR(60)) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #212 VALUES CAST (CAST (NULL AS CHAR(60)) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #213 VALUES CAST (CAST (NULL AS CHAR(60)) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #214 VALUES CAST (CAST (NULL AS CHAR(60)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #215 VALUES CAST (CAST (NULL AS CHAR(60)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #216 VALUES CAST (CAST (NULL AS CHAR(60)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #217 VALUES CAST (CAST (NULL AS CHAR(60)) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #218 VALUES CAST (CAST (NULL AS CHAR(60)) AS DATE ) 1 ---------- NULL Test #219 VALUES CAST (CAST (NULL AS CHAR(60)) AS TIME ) 1 -------- NULL Test #220 VALUES CAST (CAST (NULL AS CHAR(60)) AS TIMESTAMP ) 1 -------------------------- NULL Test #221 VALUES CAST (CAST (NULL AS CHAR(60)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'BLOB'. Test #222 VALUES CAST (CAST ('0' AS CHAR(60)) AS SMALLINT ) 1 ------ 0 Test #223 VALUES CAST (CAST ('11' AS CHAR(60)) AS INTEGER ) 1 ----------- 11 Test #224 VALUES CAST (CAST ('22' AS CHAR(60)) AS BIGINT ) 1 -------------------- 22 Test #225 VALUES CAST (CAST ('3.3' AS CHAR(60)) AS DECIMAL(10,5) ) 1 ------------ 3.30000 Test #226 VALUES CAST (CAST ('4.4' AS CHAR(60)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'REAL'. Test #227 VALUES CAST (CAST ('5.5' AS CHAR(60)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'DOUBLE'. Test #228 VALUES CAST (CAST ('7' AS CHAR(60)) AS CHAR(60) ) 1 ------------------------------------------------------------ 7 Test #229 VALUES CAST (CAST ('8' AS CHAR(60)) AS VARCHAR(60) ) 1 ------------------------------------------------------------ 8 Test #230 VALUES CAST (CAST ('9' AS CHAR(60)) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- 9 Test #231 VALUES CAST (CAST (X'10aa' AS CHAR(60)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. Test #232 VALUES CAST (CAST (X'10bb' AS CHAR(60)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. Test #233 VALUES CAST (CAST (X'10cc' AS CHAR(60)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. Test #234 VALUES CAST (CAST ('13' AS CHAR(60)) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 13 Test #235 VALUES CAST (CAST ('2000-01-01' AS CHAR(60)) AS DATE ) 1 ---------- 2000-01-01 Test #236 VALUES CAST (CAST ('15:30:20' AS CHAR(60)) AS TIME ) 1 -------- 15:30:20 Test #237 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS CHAR(60)) AS TIMESTAMP ) 1 -------------------------- xxxxxxFILTERED-TIMESTAMPxxxxx Test #238 VALUES CAST (CAST (X'01dd' AS CHAR(60)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. Test #239 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS SMALLINT ) 1 ------ NULL Test #240 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS INTEGER ) 1 ----------- NULL Test #241 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS BIGINT ) 1 -------------------- NULL Test #242 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS DECIMAL(10,5) ) 1 ------------ NULL Test #243 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'REAL'. Test #244 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'DOUBLE'. Test #245 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #246 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #247 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #248 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. Test #249 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'VARCHAR () FOR BIT DATA'. Test #250 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #251 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #252 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS DATE ) 1 ---------- NULL Test #253 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS TIME ) 1 -------- NULL Test #254 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS TIMESTAMP ) 1 -------------------------- NULL Test #255 VALUES CAST (CAST (NULL AS VARCHAR(60)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'BLOB'. Test #256 VALUES CAST (CAST ('0' AS VARCHAR(60)) AS SMALLINT ) 1 ------ 0 Test #257 VALUES CAST (CAST ('11' AS VARCHAR(60)) AS INTEGER ) 1 ----------- 11 Test #258 VALUES CAST (CAST ('22' AS VARCHAR(60)) AS BIGINT ) 1 -------------------- 22 Test #259 VALUES CAST (CAST ('3.3' AS VARCHAR(60)) AS DECIMAL(10,5) ) 1 ------------ 3.30000 Test #260 VALUES CAST (CAST ('4.4' AS VARCHAR(60)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'REAL'. Test #261 VALUES CAST (CAST ('5.5' AS VARCHAR(60)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR' to 'DOUBLE'. Test #262 VALUES CAST (CAST ('7' AS VARCHAR(60)) AS CHAR(60) ) 1 ------------------------------------------------------------ 7 Test #263 VALUES CAST (CAST ('8' AS VARCHAR(60)) AS VARCHAR(60) ) 1 ------------------------------------------------------------ 8 Test #264 VALUES CAST (CAST ('9' AS VARCHAR(60)) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- 9 Test #265 VALUES CAST (CAST (X'10aa' AS VARCHAR(60)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. Test #266 VALUES CAST (CAST (X'10bb' AS VARCHAR(60)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. Test #267 VALUES CAST (CAST (X'10cc' AS VARCHAR(60)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. Test #268 VALUES CAST (CAST ('13' AS VARCHAR(60)) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 13 Test #269 VALUES CAST (CAST ('2000-01-01' AS VARCHAR(60)) AS DATE ) 1 ---------- 2000-01-01 Test #270 VALUES CAST (CAST ('15:30:20' AS VARCHAR(60)) AS TIME ) 1 -------- 15:30:20 Test #271 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS VARCHAR(60)) AS TIMESTAMP ) 1 -------------------------- xxxxxxFILTERED-TIMESTAMPxxxxx Test #272 VALUES CAST (CAST (X'01dd' AS VARCHAR(60)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. Test #273 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'SMALLINT'. Test #274 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'INTEGER'. Test #275 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'BIGINT'. Test #276 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'DECIMAL'. Test #277 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'REAL'. Test #278 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'DOUBLE'. Test #279 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #280 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #281 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #282 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'. Test #283 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'VARCHAR () FOR BIT DATA'. Test #284 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #285 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #286 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'DATE'. Test #287 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'TIME'. Test #288 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'TIMESTAMP'. Test #289 VALUES CAST (CAST (NULL AS LONG VARCHAR) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'BLOB'. Test #290 VALUES CAST (CAST ('0' AS LONG VARCHAR) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'SMALLINT'. Test #291 VALUES CAST (CAST ('11' AS LONG VARCHAR) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'INTEGER'. Test #292 VALUES CAST (CAST ('22' AS LONG VARCHAR) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'BIGINT'. Test #293 VALUES CAST (CAST ('3.3' AS LONG VARCHAR) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'DECIMAL'. Test #294 VALUES CAST (CAST ('4.4' AS LONG VARCHAR) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'REAL'. Test #295 VALUES CAST (CAST ('5.5' AS LONG VARCHAR) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'DOUBLE'. Test #296 VALUES CAST (CAST ('7' AS LONG VARCHAR) AS CHAR(60) ) 1 ------------------------------------------------------------ 7 Test #297 VALUES CAST (CAST ('8' AS LONG VARCHAR) AS VARCHAR(60) ) 1 ------------------------------------------------------------ 8 Test #298 VALUES CAST (CAST ('9' AS LONG VARCHAR) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- 9 Test #299 VALUES CAST (CAST (X'10aa' AS LONG VARCHAR) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. Test #300 VALUES CAST (CAST (X'10bb' AS LONG VARCHAR) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. Test #301 VALUES CAST (CAST (X'10cc' AS LONG VARCHAR) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. Test #302 VALUES CAST (CAST ('13' AS LONG VARCHAR) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 13 Test #303 VALUES CAST (CAST ('2000-01-01' AS LONG VARCHAR) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'DATE'. Test #304 VALUES CAST (CAST ('15:30:20' AS LONG VARCHAR) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'TIME'. Test #305 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS LONG VARCHAR) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR' to 'TIMESTAMP'. Test #306 VALUES CAST (CAST (X'01dd' AS LONG VARCHAR) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. Test #307 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'SMALLINT'. Test #308 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. Test #309 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'BIGINT'. Test #310 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'DECIMAL'. Test #311 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'REAL'. Test #312 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'DOUBLE'. Test #313 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. Test #314 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. Test #315 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. Test #316 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS CHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ NULL Test #317 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS VARCHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ NULL Test #318 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS LONG VARCHAR FOR BIT DATA ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #319 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. Test #320 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'DATE'. Test #321 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'TIME'. Test #322 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR () FOR BIT DATA' to 'TIMESTAMP'. Test #323 VALUES CAST (CAST (NULL AS CHAR(60) FOR BIT DATA) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #324 VALUES CAST (CAST ('0' AS CHAR(60) FOR BIT DATA) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #325 VALUES CAST (CAST ('11' AS CHAR(60) FOR BIT DATA) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #326 VALUES CAST (CAST ('22' AS CHAR(60) FOR BIT DATA) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #327 VALUES CAST (CAST ('3.3' AS CHAR(60) FOR BIT DATA) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #328 VALUES CAST (CAST ('4.4' AS CHAR(60) FOR BIT DATA) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #329 VALUES CAST (CAST ('5.5' AS CHAR(60) FOR BIT DATA) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #330 VALUES CAST (CAST ('7' AS CHAR(60) FOR BIT DATA) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #331 VALUES CAST (CAST ('8' AS CHAR(60) FOR BIT DATA) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #332 VALUES CAST (CAST ('9' AS CHAR(60) FOR BIT DATA) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #333 VALUES CAST (CAST (X'10aa' AS CHAR(60) FOR BIT DATA) AS CHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ 10aa20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 Test #334 VALUES CAST (CAST (X'10bb' AS CHAR(60) FOR BIT DATA) AS VARCHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ 10bb20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 Test #335 VALUES CAST (CAST (X'10cc' AS CHAR(60) FOR BIT DATA) AS LONG VARCHAR FOR BIT DATA ) 1 -------------------------------------------------------------------------------------------------------------------------------- 10cc20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 Test #336 VALUES CAST (CAST ('13' AS CHAR(60) FOR BIT DATA) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #337 VALUES CAST (CAST ('2000-01-01' AS CHAR(60) FOR BIT DATA) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #338 VALUES CAST (CAST ('15:30:20' AS CHAR(60) FOR BIT DATA) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #339 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS CHAR(60) FOR BIT DATA) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. Test #340 VALUES CAST (CAST (X'01dd' AS CHAR(60) FOR BIT DATA) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 01dd20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 Test #341 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'SMALLINT'. Test #342 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'INTEGER'. Test #343 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'BIGINT'. Test #344 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'DECIMAL'. Test #345 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'REAL'. Test #346 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'DOUBLE'. Test #347 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'CHAR'. Test #348 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'VARCHAR'. Test #349 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'LONG VARCHAR'. Test #350 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS CHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ NULL Test #351 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS VARCHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ NULL Test #352 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS LONG VARCHAR FOR BIT DATA ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #353 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'CLOB'. Test #354 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'DATE'. Test #355 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'TIME'. Test #356 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'VARCHAR () FOR BIT DATA' to 'TIMESTAMP'. Test #357 VALUES CAST (CAST (NULL AS VARCHAR(60) FOR BIT DATA) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #358 VALUES CAST (CAST ('0' AS VARCHAR(60) FOR BIT DATA) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #359 VALUES CAST (CAST ('11' AS VARCHAR(60) FOR BIT DATA) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #360 VALUES CAST (CAST ('22' AS VARCHAR(60) FOR BIT DATA) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #361 VALUES CAST (CAST ('3.3' AS VARCHAR(60) FOR BIT DATA) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #362 VALUES CAST (CAST ('4.4' AS VARCHAR(60) FOR BIT DATA) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #363 VALUES CAST (CAST ('5.5' AS VARCHAR(60) FOR BIT DATA) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #364 VALUES CAST (CAST ('7' AS VARCHAR(60) FOR BIT DATA) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #365 VALUES CAST (CAST ('8' AS VARCHAR(60) FOR BIT DATA) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #366 VALUES CAST (CAST ('9' AS VARCHAR(60) FOR BIT DATA) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #367 VALUES CAST (CAST (X'10aa' AS VARCHAR(60) FOR BIT DATA) AS CHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ 10aa20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 Test #368 VALUES CAST (CAST (X'10bb' AS VARCHAR(60) FOR BIT DATA) AS VARCHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ 10bb Test #369 VALUES CAST (CAST (X'10cc' AS VARCHAR(60) FOR BIT DATA) AS LONG VARCHAR FOR BIT DATA ) 1 -------------------------------------------------------------------------------------------------------------------------------- 10cc Test #370 VALUES CAST (CAST ('13' AS VARCHAR(60) FOR BIT DATA) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #371 VALUES CAST (CAST ('2000-01-01' AS VARCHAR(60) FOR BIT DATA) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #372 VALUES CAST (CAST ('15:30:20' AS VARCHAR(60) FOR BIT DATA) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #373 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS VARCHAR(60) FOR BIT DATA) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. Test #374 VALUES CAST (CAST (X'01dd' AS VARCHAR(60) FOR BIT DATA) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 01dd Test #375 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'SMALLINT'. Test #376 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'INTEGER'. Test #377 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'BIGINT'. Test #378 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'DECIMAL'. Test #379 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'REAL'. Test #380 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'DOUBLE'. Test #381 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CHAR'. Test #382 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'VARCHAR'. Test #383 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'LONG VARCHAR'. Test #384 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS CHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ NULL Test #385 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS VARCHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ NULL Test #386 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS LONG VARCHAR FOR BIT DATA ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #387 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. Test #388 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'DATE'. Test #389 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'TIME'. Test #390 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'TIMESTAMP'. Test #391 VALUES CAST (CAST (NULL AS LONG VARCHAR FOR BIT DATA) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #392 VALUES CAST (CAST ('0' AS LONG VARCHAR FOR BIT DATA) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #393 VALUES CAST (CAST ('11' AS LONG VARCHAR FOR BIT DATA) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #394 VALUES CAST (CAST ('22' AS LONG VARCHAR FOR BIT DATA) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #395 VALUES CAST (CAST ('3.3' AS LONG VARCHAR FOR BIT DATA) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #396 VALUES CAST (CAST ('4.4' AS LONG VARCHAR FOR BIT DATA) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #397 VALUES CAST (CAST ('5.5' AS LONG VARCHAR FOR BIT DATA) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #398 VALUES CAST (CAST ('7' AS LONG VARCHAR FOR BIT DATA) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #399 VALUES CAST (CAST ('8' AS LONG VARCHAR FOR BIT DATA) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #400 VALUES CAST (CAST ('9' AS LONG VARCHAR FOR BIT DATA) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #401 VALUES CAST (CAST (X'10aa' AS LONG VARCHAR FOR BIT DATA) AS CHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ 10aa20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 Test #402 VALUES CAST (CAST (X'10bb' AS LONG VARCHAR FOR BIT DATA) AS VARCHAR(60) FOR BIT DATA ) 1 ------------------------------------------------------------------------------------------------------------------------ 10bb Test #403 VALUES CAST (CAST (X'10cc' AS LONG VARCHAR FOR BIT DATA) AS LONG VARCHAR FOR BIT DATA ) 1 -------------------------------------------------------------------------------------------------------------------------------- 10cc Test #404 VALUES CAST (CAST ('13' AS LONG VARCHAR FOR BIT DATA) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #405 VALUES CAST (CAST ('2000-01-01' AS LONG VARCHAR FOR BIT DATA) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #406 VALUES CAST (CAST ('15:30:20' AS LONG VARCHAR FOR BIT DATA) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #407 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS LONG VARCHAR FOR BIT DATA) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. Test #408 VALUES CAST (CAST (X'01dd' AS LONG VARCHAR FOR BIT DATA) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 01dd Test #409 VALUES CAST (CAST (NULL AS CLOB(1k)) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'SMALLINT'. Test #410 VALUES CAST (CAST (NULL AS CLOB(1k)) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'INTEGER'. Test #411 VALUES CAST (CAST (NULL AS CLOB(1k)) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'BIGINT'. Test #412 VALUES CAST (CAST (NULL AS CLOB(1k)) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'DECIMAL'. Test #413 VALUES CAST (CAST (NULL AS CLOB(1k)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'REAL'. Test #414 VALUES CAST (CAST (NULL AS CLOB(1k)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'DOUBLE'. Test #415 VALUES CAST (CAST (NULL AS CLOB(1k)) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #416 VALUES CAST (CAST (NULL AS CLOB(1k)) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #417 VALUES CAST (CAST (NULL AS CLOB(1k)) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #418 VALUES CAST (CAST (NULL AS CLOB(1k)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. Test #419 VALUES CAST (CAST (NULL AS CLOB(1k)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'VARCHAR () FOR BIT DATA'. Test #420 VALUES CAST (CAST (NULL AS CLOB(1k)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. Test #421 VALUES CAST (CAST (NULL AS CLOB(1k)) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #422 VALUES CAST (CAST (NULL AS CLOB(1k)) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'DATE'. Test #423 VALUES CAST (CAST (NULL AS CLOB(1k)) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'TIME'. Test #424 VALUES CAST (CAST (NULL AS CLOB(1k)) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'TIMESTAMP'. Test #425 VALUES CAST (CAST (NULL AS CLOB(1k)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'BLOB'. Test #426 VALUES CAST (CAST ('13' AS CLOB(1k)) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'SMALLINT'. Test #427 VALUES CAST (CAST ('13' AS CLOB(1k)) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'INTEGER'. Test #428 VALUES CAST (CAST ('13' AS CLOB(1k)) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'BIGINT'. Test #429 VALUES CAST (CAST ('13' AS CLOB(1k)) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'DECIMAL'. Test #430 VALUES CAST (CAST ('13' AS CLOB(1k)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'REAL'. Test #431 VALUES CAST (CAST ('13' AS CLOB(1k)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'DOUBLE'. Test #432 VALUES CAST (CAST ('13' AS CLOB(1k)) AS CHAR(60) ) 1 ------------------------------------------------------------ 13 Test #433 VALUES CAST (CAST ('13' AS CLOB(1k)) AS VARCHAR(60) ) 1 ------------------------------------------------------------ 13 Test #434 VALUES CAST (CAST ('13' AS CLOB(1k)) AS LONG VARCHAR ) 1 -------------------------------------------------------------------------------------------------------------------------------- 13 Test #435 VALUES CAST (CAST ('13' AS CLOB(1k)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. Test #436 VALUES CAST (CAST ('13' AS CLOB(1k)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'VARCHAR () FOR BIT DATA'. Test #437 VALUES CAST (CAST ('13' AS CLOB(1k)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. Test #438 VALUES CAST (CAST ('13' AS CLOB(1k)) AS CLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 13 Test #439 VALUES CAST (CAST ('13' AS CLOB(1k)) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'DATE'. Test #440 VALUES CAST (CAST ('13' AS CLOB(1k)) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'TIME'. Test #441 VALUES CAST (CAST ('13' AS CLOB(1k)) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'TIMESTAMP'. Test #442 VALUES CAST (CAST ('13' AS CLOB(1k)) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'CLOB' to 'BLOB'. Test #443 VALUES CAST (CAST (NULL AS DATE) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'SMALLINT'. Test #444 VALUES CAST (CAST (NULL AS DATE) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'INTEGER'. Test #445 VALUES CAST (CAST (NULL AS DATE) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'BIGINT'. Test #446 VALUES CAST (CAST (NULL AS DATE) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'DECIMAL'. Test #447 VALUES CAST (CAST (NULL AS DATE) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'REAL'. Test #448 VALUES CAST (CAST (NULL AS DATE) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'DOUBLE'. Test #449 VALUES CAST (CAST (NULL AS DATE) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #450 VALUES CAST (CAST (NULL AS DATE) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #451 VALUES CAST (CAST (NULL AS DATE) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'LONG VARCHAR'. Test #452 VALUES CAST (CAST (NULL AS DATE) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'CHAR () FOR BIT DATA'. Test #453 VALUES CAST (CAST (NULL AS DATE) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'VARCHAR () FOR BIT DATA'. Test #454 VALUES CAST (CAST (NULL AS DATE) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'LONG VARCHAR FOR BIT DATA'. Test #455 VALUES CAST (CAST (NULL AS DATE) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'CLOB'. Test #456 VALUES CAST (CAST (NULL AS DATE) AS DATE ) 1 ---------- NULL Test #457 VALUES CAST (CAST (NULL AS DATE) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'TIME'. Test #458 VALUES CAST (CAST (NULL AS DATE) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'TIMESTAMP'. Test #459 VALUES CAST (CAST (NULL AS DATE) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'BLOB'. Test #460 VALUES CAST (CAST ('2000-01-01' AS DATE) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'SMALLINT'. Test #461 VALUES CAST (CAST ('2000-01-01' AS DATE) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'INTEGER'. Test #462 VALUES CAST (CAST ('2000-01-01' AS DATE) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'BIGINT'. Test #463 VALUES CAST (CAST ('2000-01-01' AS DATE) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'DECIMAL'. Test #464 VALUES CAST (CAST ('2000-01-01' AS DATE) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'REAL'. Test #465 VALUES CAST (CAST ('2000-01-01' AS DATE) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'DOUBLE'. Test #466 VALUES CAST (CAST ('2000-01-01' AS DATE) AS CHAR(60) ) 1 ------------------------------------------------------------ 2000-01-01 Test #467 VALUES CAST (CAST ('2000-01-01' AS DATE) AS VARCHAR(60) ) 1 ------------------------------------------------------------ 2000-01-01 Test #468 VALUES CAST (CAST ('2000-01-01' AS DATE) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'LONG VARCHAR'. Test #469 VALUES CAST (CAST ('2000-01-01' AS DATE) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'CHAR () FOR BIT DATA'. Test #470 VALUES CAST (CAST ('2000-01-01' AS DATE) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'VARCHAR () FOR BIT DATA'. Test #471 VALUES CAST (CAST ('2000-01-01' AS DATE) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'LONG VARCHAR FOR BIT DATA'. Test #472 VALUES CAST (CAST ('2000-01-01' AS DATE) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'CLOB'. Test #473 VALUES CAST (CAST ('2000-01-01' AS DATE) AS DATE ) 1 ---------- 2000-01-01 Test #474 VALUES CAST (CAST ('2000-01-01' AS DATE) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'TIME'. Test #475 VALUES CAST (CAST ('2000-01-01' AS DATE) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'TIMESTAMP'. Test #476 VALUES CAST (CAST ('2000-01-01' AS DATE) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'DATE' to 'BLOB'. Test #477 VALUES CAST (CAST (NULL AS TIME) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'SMALLINT'. Test #478 VALUES CAST (CAST (NULL AS TIME) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'INTEGER'. Test #479 VALUES CAST (CAST (NULL AS TIME) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'BIGINT'. Test #480 VALUES CAST (CAST (NULL AS TIME) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'DECIMAL'. Test #481 VALUES CAST (CAST (NULL AS TIME) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'REAL'. Test #482 VALUES CAST (CAST (NULL AS TIME) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'DOUBLE'. Test #483 VALUES CAST (CAST (NULL AS TIME) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #484 VALUES CAST (CAST (NULL AS TIME) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #485 VALUES CAST (CAST (NULL AS TIME) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'LONG VARCHAR'. Test #486 VALUES CAST (CAST (NULL AS TIME) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'CHAR () FOR BIT DATA'. Test #487 VALUES CAST (CAST (NULL AS TIME) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'VARCHAR () FOR BIT DATA'. Test #488 VALUES CAST (CAST (NULL AS TIME) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'LONG VARCHAR FOR BIT DATA'. Test #489 VALUES CAST (CAST (NULL AS TIME) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'CLOB'. Test #490 VALUES CAST (CAST (NULL AS TIME) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'DATE'. Test #491 VALUES CAST (CAST (NULL AS TIME) AS TIME ) 1 -------- NULL Test #492 VALUES CAST (CAST (NULL AS TIME) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'TIMESTAMP'. Test #493 VALUES CAST (CAST (NULL AS TIME) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'BLOB'. Test #494 VALUES CAST (CAST ('15:30:20' AS TIME) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'SMALLINT'. Test #495 VALUES CAST (CAST ('15:30:20' AS TIME) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'INTEGER'. Test #496 VALUES CAST (CAST ('15:30:20' AS TIME) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'BIGINT'. Test #497 VALUES CAST (CAST ('15:30:20' AS TIME) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'DECIMAL'. Test #498 VALUES CAST (CAST ('15:30:20' AS TIME) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'REAL'. Test #499 VALUES CAST (CAST ('15:30:20' AS TIME) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'DOUBLE'. Test #500 VALUES CAST (CAST ('15:30:20' AS TIME) AS CHAR(60) ) 1 ------------------------------------------------------------ 15:30:20 Test #501 VALUES CAST (CAST ('15:30:20' AS TIME) AS VARCHAR(60) ) 1 ------------------------------------------------------------ 15:30:20 Test #502 VALUES CAST (CAST ('15:30:20' AS TIME) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'LONG VARCHAR'. Test #503 VALUES CAST (CAST ('15:30:20' AS TIME) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'CHAR () FOR BIT DATA'. Test #504 VALUES CAST (CAST ('15:30:20' AS TIME) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'VARCHAR () FOR BIT DATA'. Test #505 VALUES CAST (CAST ('15:30:20' AS TIME) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'LONG VARCHAR FOR BIT DATA'. Test #506 VALUES CAST (CAST ('15:30:20' AS TIME) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'CLOB'. Test #507 VALUES CAST (CAST ('15:30:20' AS TIME) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'DATE'. Test #508 VALUES CAST (CAST ('15:30:20' AS TIME) AS TIME ) 1 -------- 15:30:20 Test #509 VALUES CAST (CAST ('15:30:20' AS TIME) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'TIMESTAMP'. Test #510 VALUES CAST (CAST ('15:30:20' AS TIME) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIME' to 'BLOB'. Test #511 VALUES CAST (CAST (NULL AS TIMESTAMP) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'SMALLINT'. Test #512 VALUES CAST (CAST (NULL AS TIMESTAMP) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'INTEGER'. Test #513 VALUES CAST (CAST (NULL AS TIMESTAMP) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'BIGINT'. Test #514 VALUES CAST (CAST (NULL AS TIMESTAMP) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'DECIMAL'. Test #515 VALUES CAST (CAST (NULL AS TIMESTAMP) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'REAL'. Test #516 VALUES CAST (CAST (NULL AS TIMESTAMP) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'DOUBLE'. Test #517 VALUES CAST (CAST (NULL AS TIMESTAMP) AS CHAR(60) ) 1 ------------------------------------------------------------ NULL Test #518 VALUES CAST (CAST (NULL AS TIMESTAMP) AS VARCHAR(60) ) 1 ------------------------------------------------------------ NULL Test #519 VALUES CAST (CAST (NULL AS TIMESTAMP) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'LONG VARCHAR'. Test #520 VALUES CAST (CAST (NULL AS TIMESTAMP) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'CHAR () FOR BIT DATA'. Test #521 VALUES CAST (CAST (NULL AS TIMESTAMP) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'VARCHAR () FOR BIT DATA'. Test #522 VALUES CAST (CAST (NULL AS TIMESTAMP) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'LONG VARCHAR FOR BIT DATA'. Test #523 VALUES CAST (CAST (NULL AS TIMESTAMP) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'CLOB'. Test #524 VALUES CAST (CAST (NULL AS TIMESTAMP) AS DATE ) 1 ---------- NULL Test #525 VALUES CAST (CAST (NULL AS TIMESTAMP) AS TIME ) 1 -------- NULL Test #526 VALUES CAST (CAST (NULL AS TIMESTAMP) AS TIMESTAMP ) 1 -------------------------- NULL Test #527 VALUES CAST (CAST (NULL AS TIMESTAMP) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'BLOB'. Test #528 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'SMALLINT'. Test #529 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'INTEGER'. Test #530 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'BIGINT'. Test #531 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'DECIMAL'. Test #532 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'REAL'. Test #533 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'DOUBLE'. Test #534 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS CHAR(60) ) 1 ------------------------------------------------------------ xxxxxxFILTERED-TIMESTAMPxxxxx Test #535 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS VARCHAR(60) ) 1 ------------------------------------------------------------ xxxxxxFILTERED-TIMESTAMPxxxxx Test #536 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'LONG VARCHAR'. Test #537 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'CHAR () FOR BIT DATA'. Test #538 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'VARCHAR () FOR BIT DATA'. Test #539 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'LONG VARCHAR FOR BIT DATA'. Test #540 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'CLOB'. Test #541 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS DATE ) 1 ---------- 2000-01-01 Test #542 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS TIME ) 1 -------- 15:30:20 Test #543 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS TIMESTAMP ) 1 -------------------------- xxxxxxFILTERED-TIMESTAMPxxxxx Test #544 VALUES CAST (CAST ('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) AS BLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'TIMESTAMP' to 'BLOB'. Test #545 VALUES CAST (CAST (NULL AS BLOB(1k)) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'SMALLINT'. Test #546 VALUES CAST (CAST (NULL AS BLOB(1k)) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'INTEGER'. Test #547 VALUES CAST (CAST (NULL AS BLOB(1k)) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'BIGINT'. Test #548 VALUES CAST (CAST (NULL AS BLOB(1k)) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'DECIMAL'. Test #549 VALUES CAST (CAST (NULL AS BLOB(1k)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'REAL'. Test #550 VALUES CAST (CAST (NULL AS BLOB(1k)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'DOUBLE'. Test #551 VALUES CAST (CAST (NULL AS BLOB(1k)) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'CHAR'. Test #552 VALUES CAST (CAST (NULL AS BLOB(1k)) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'VARCHAR'. Test #553 VALUES CAST (CAST (NULL AS BLOB(1k)) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'LONG VARCHAR'. Test #554 VALUES CAST (CAST (NULL AS BLOB(1k)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. Test #555 VALUES CAST (CAST (NULL AS BLOB(1k)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'VARCHAR () FOR BIT DATA'. Test #556 VALUES CAST (CAST (NULL AS BLOB(1k)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. Test #557 VALUES CAST (CAST (NULL AS BLOB(1k)) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'CLOB'. Test #558 VALUES CAST (CAST (NULL AS BLOB(1k)) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'DATE'. Test #559 VALUES CAST (CAST (NULL AS BLOB(1k)) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'TIME'. Test #560 VALUES CAST (CAST (NULL AS BLOB(1k)) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'TIMESTAMP'. Test #561 VALUES CAST (CAST (NULL AS BLOB(1k)) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- NULL Test #562 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS SMALLINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'SMALLINT'. Test #563 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS INTEGER ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'INTEGER'. Test #564 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS BIGINT ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'BIGINT'. Test #565 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS DECIMAL(10,5) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'DECIMAL'. Test #566 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS REAL ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'REAL'. Test #567 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS DOUBLE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'DOUBLE'. Test #568 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS CHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'CHAR'. Test #569 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS VARCHAR(60) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'VARCHAR'. Test #570 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS LONG VARCHAR ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'LONG VARCHAR'. Test #571 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS CHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. Test #572 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS VARCHAR(60) FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'VARCHAR () FOR BIT DATA'. Test #573 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS LONG VARCHAR FOR BIT DATA ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. Test #574 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS CLOB(1k) ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'CLOB'. Test #575 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS DATE ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'DATE'. Test #576 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS TIME ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'TIME'. Test #577 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS TIMESTAMP ) EXPECTED CASTING EXCEPTION: Cannot convert types 'BLOB' to 'TIMESTAMP'. Test #578 VALUES CAST (CAST (X'01dd' AS BLOB(1k)) AS BLOB(1k) ) 1 -------------------------------------------------------------------------------------------------------------------------------- 01dd **testComparisons starting * testing literal comparisons SELECT distinct c FROM SMALLINT_TAB WHERE c = 0 C ------ 0 SELECT distinct c FROM INTEGER_TAB WHERE c = 11 C ----------- 11 SELECT distinct c FROM BIGINT_TAB WHERE c = 22 C -------------------- 22 SELECT distinct c FROM DECIMAL_TAB WHERE c = 3.3 C ------------ 3.30000 SELECT distinct c FROM REAL_TAB WHERE c = 4.4 C ------------- 4.4 SELECT distinct c FROM DOUBLE_TAB WHERE c = 5.5 C ---------------------- 5.5 SELECT distinct c FROM CHAR_TAB WHERE c = '7' C ------------------------------------------------------------ 7 SELECT distinct c FROM VARCHAR_TAB WHERE c = '8' C ------------------------------------------------------------ 8 SELECT distinct c FROM LONG_VARCHAR_TAB WHERE c = '9' EXPECTED EXCEPTION comparing long type. Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported. SELECT distinct c FROM CHAR_FOR_BIT_DATA_TAB WHERE c = X'10aa' C ------------------------------------------------------------------------------------------------------------------------ 10aa20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020 SELECT distinct c FROM VARCHAR_FOR_BIT_DATA_TAB WHERE c = X'10bb' C ------------------------------------------------------------------------------------------------------------------------ 10bb SELECT distinct c FROM LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = X'10cc' EXPECTED EXCEPTION comparing long type. Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CHAR () FOR BIT DATA' are not supported. SELECT distinct c FROM CLOB_TAB WHERE c = '13' EXPECTED EXCEPTION comparing long type. Comparisons between 'CLOB' and 'CHAR' are not supported. SELECT distinct c FROM DATE_TAB WHERE c = '2000-01-01' C ---------- 2000-01-01 SELECT distinct c FROM TIME_TAB WHERE c = '15:30:20' C -------- 15:30:20 SELECT distinct c FROM TIMESTAMP_TAB WHERE c = 'xxxxxxFILTERED-TIMESTAMPxxxxx C -------------------------- xxxxxxFILTERED-TIMESTAMPxxxxx SELECT distinct c FROM BLOB_TAB WHERE c = X'01dd' EXPECTED EXCEPTION comparing long type. Comparisons between 'BLOB' and 'CHAR () FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS SMALLINT) C ------ select c from INTEGER_TAB WHERE c = CAST(NULL AS SMALLINT) C ----------- select c from BIGINT_TAB WHERE c = CAST(NULL AS SMALLINT) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(NULL AS SMALLINT) C ------------ select c from REAL_TAB WHERE c = CAST(NULL AS SMALLINT) C ------------- select c from DOUBLE_TAB WHERE c = CAST(NULL AS SMALLINT) C ---------------------- select c from CHAR_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'SMALLINT' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'SMALLINT' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'SMALLINT' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'SMALLINT' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'SMALLINT' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'SMALLINT' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'SMALLINT' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'SMALLINT' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'SMALLINT' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'SMALLINT' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'SMALLINT' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS INTEGER) C ------ select c from INTEGER_TAB WHERE c = CAST(NULL AS INTEGER) C ----------- select c from BIGINT_TAB WHERE c = CAST(NULL AS INTEGER) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(NULL AS INTEGER) C ------------ select c from REAL_TAB WHERE c = CAST(NULL AS INTEGER) C ------------- select c from DOUBLE_TAB WHERE c = CAST(NULL AS INTEGER) C ---------------------- select c from CHAR_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'INTEGER' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'INTEGER' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'INTEGER' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'INTEGER' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'INTEGER' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'INTEGER' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'INTEGER' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'INTEGER' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'INTEGER' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'INTEGER' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'INTEGER' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS BIGINT) C ------ select c from INTEGER_TAB WHERE c = CAST(NULL AS BIGINT) C ----------- select c from BIGINT_TAB WHERE c = CAST(NULL AS BIGINT) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(NULL AS BIGINT) C ------------ select c from REAL_TAB WHERE c = CAST(NULL AS BIGINT) C ------------- select c from DOUBLE_TAB WHERE c = CAST(NULL AS BIGINT) C ---------------------- select c from CHAR_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'BIGINT' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'BIGINT' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'BIGINT' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'BIGINT' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'BIGINT' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'BIGINT' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'BIGINT' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'BIGINT' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'BIGINT' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'BIGINT' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'BIGINT' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) C ------ select c from INTEGER_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) C ----------- select c from BIGINT_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) C ------------ select c from REAL_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) C ------------- select c from DOUBLE_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) C ---------------------- select c from CHAR_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'DECIMAL' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'DECIMAL' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'DECIMAL' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'DECIMAL' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'DECIMAL' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DECIMAL' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'DECIMAL' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'DECIMAL' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'DECIMAL' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'DECIMAL' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'DECIMAL' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS REAL) C ------ select c from INTEGER_TAB WHERE c = CAST(NULL AS REAL) C ----------- select c from BIGINT_TAB WHERE c = CAST(NULL AS REAL) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(NULL AS REAL) C ------------ select c from REAL_TAB WHERE c = CAST(NULL AS REAL) C ------------- select c from DOUBLE_TAB WHERE c = CAST(NULL AS REAL) C ---------------------- select c from CHAR_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'REAL' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'REAL' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'REAL' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'REAL' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'REAL' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'REAL' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'REAL' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'REAL' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'REAL' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'REAL' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'REAL' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS DOUBLE) C ------ select c from INTEGER_TAB WHERE c = CAST(NULL AS DOUBLE) C ----------- select c from BIGINT_TAB WHERE c = CAST(NULL AS DOUBLE) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(NULL AS DOUBLE) C ------------ select c from REAL_TAB WHERE c = CAST(NULL AS DOUBLE) C ------------- select c from DOUBLE_TAB WHERE c = CAST(NULL AS DOUBLE) C ---------------------- select c from CHAR_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'DOUBLE' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'DOUBLE' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'DOUBLE' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'DOUBLE' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'DOUBLE' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DOUBLE' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'DOUBLE' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'DOUBLE' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'DOUBLE' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'DOUBLE' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'DOUBLE' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'CHAR' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'CHAR' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'CHAR' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'CHAR' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'CHAR' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'CHAR' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS CHAR(60)) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST(NULL AS CHAR(60)) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'CHAR' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CHAR' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'CHAR' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS CHAR(60)) C ---------- select c from TIME_TAB WHERE c = CAST(NULL AS CHAR(60)) C -------- select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS CHAR(60)) C -------------------------- select c from BLOB_TAB WHERE c = CAST(NULL AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'CHAR' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'VARCHAR' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'VARCHAR' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'VARCHAR' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'VARCHAR' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'VARCHAR' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'VARCHAR' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS VARCHAR(60)) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST(NULL AS VARCHAR(60)) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'VARCHAR' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'VARCHAR' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'VARCHAR' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS VARCHAR(60)) C ---------- select c from TIME_TAB WHERE c = CAST(NULL AS VARCHAR(60)) C -------- select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS VARCHAR(60)) C -------------------------- select c from BLOB_TAB WHERE c = CAST(NULL AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'VARCHAR' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'LONG VARCHAR' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'LONG VARCHAR' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'LONG VARCHAR' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'LONG VARCHAR' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'LONG VARCHAR' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'LONG VARCHAR' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'LONG VARCHAR' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'LONG VARCHAR' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'LONG VARCHAR' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'LONG VARCHAR' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'LONG VARCHAR' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'LONG VARCHAR' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'LONG VARCHAR' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'LONG VARCHAR' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'LONG VARCHAR' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'LONG VARCHAR' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'CHAR () FOR BIT DATA' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'CHAR () FOR BIT DATA' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'CHAR () FOR BIT DATA' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'CHAR () FOR BIT DATA' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'CHAR () FOR BIT DATA' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'CHAR () FOR BIT DATA' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'CHAR () FOR BIT DATA' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'CHAR () FOR BIT DATA' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CHAR () FOR BIT DATA' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'CHAR () FOR BIT DATA' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'CHAR () FOR BIT DATA' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'CHAR () FOR BIT DATA' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'CHAR () FOR BIT DATA' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'CHAR () FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'VARCHAR () FOR BIT DATA' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'VARCHAR () FOR BIT DATA' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'VARCHAR () FOR BIT DATA' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'VARCHAR () FOR BIT DATA' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'VARCHAR () FOR BIT DATA' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'VARCHAR () FOR BIT DATA' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'VARCHAR () FOR BIT DATA' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'VARCHAR () FOR BIT DATA' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'VARCHAR () FOR BIT DATA' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR () FOR BIT DATA' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'VARCHAR () FOR BIT DATA' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'VARCHAR () FOR BIT DATA' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'VARCHAR () FOR BIT DATA' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'VARCHAR () FOR BIT DATA' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'VARCHAR () FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'CLOB' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'CLOB' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'CLOB' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'CLOB' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'CLOB' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'CLOB' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'CLOB' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'CLOB' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'CLOB' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'CLOB' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'CLOB' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CLOB' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'CLOB' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'CLOB' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'CLOB' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'CLOB' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'CLOB' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'DATE' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'DATE' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'DATE' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'DATE' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'DATE' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'DATE' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS DATE) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST(NULL AS DATE) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'DATE' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'DATE' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'DATE' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DATE' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'DATE' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS DATE) C ---------- select c from TIME_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'DATE' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'DATE' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'DATE' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'TIME' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'TIME' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'TIME' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'TIME' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'TIME' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'TIME' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS TIME) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST(NULL AS TIME) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'TIME' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'TIME' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'TIME' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'TIME' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'TIME' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'TIME' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS TIME) C -------- select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'TIME' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'TIME' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'TIMESTAMP' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'TIMESTAMP' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'TIMESTAMP' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'TIMESTAMP' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'TIMESTAMP' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'TIMESTAMP' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS TIMESTAMP) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST(NULL AS TIMESTAMP) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'TIMESTAMP' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'TIMESTAMP' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'TIMESTAMP' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'TIMESTAMP' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'TIMESTAMP' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'TIMESTAMP' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'TIMESTAMP' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS TIMESTAMP) C -------------------------- select c from BLOB_TAB WHERE c = CAST(NULL AS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'TIMESTAMP' are not supported. select c from SMALLINT_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'BLOB' are not supported. select c from INTEGER_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'BLOB' are not supported. select c from BIGINT_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'BLOB' are not supported. select c from DECIMAL_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'BLOB' are not supported. select c from REAL_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'BLOB' are not supported. select c from DOUBLE_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'BLOB' are not supported. select c from CHAR_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'BLOB' are not supported. select c from VARCHAR_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'BLOB' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'BLOB' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'BLOB' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'BLOB' are not supported. select c from CLOB_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'BLOB' are not supported. select c from DATE_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'BLOB' are not supported. select c from TIME_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'BLOB' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'BLOB' are not supported. select c from BLOB_TAB WHERE c = CAST(NULL AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'BLOB' are not supported. select c from SMALLINT_TAB WHERE c = CAST(0 AS SMALLINT) C ------ select c from INTEGER_TAB WHERE c = CAST(0 AS SMALLINT) C ----------- select c from BIGINT_TAB WHERE c = CAST(0 AS SMALLINT) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(0 AS SMALLINT) C ------------ select c from REAL_TAB WHERE c = CAST(0 AS SMALLINT) C ------------- select c from DOUBLE_TAB WHERE c = CAST(0 AS SMALLINT) C ---------------------- select c from CHAR_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'SMALLINT' are not supported. select c from VARCHAR_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'SMALLINT' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'SMALLINT' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'SMALLINT' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'SMALLINT' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'SMALLINT' are not supported. select c from CLOB_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'SMALLINT' are not supported. select c from DATE_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'SMALLINT' are not supported. select c from TIME_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'SMALLINT' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'SMALLINT' are not supported. select c from BLOB_TAB WHERE c = CAST(0 AS SMALLINT) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'SMALLINT' are not supported. select c from SMALLINT_TAB WHERE c = CAST(11 AS INTEGER) C ------ select c from INTEGER_TAB WHERE c = CAST(11 AS INTEGER) C ----------- select c from BIGINT_TAB WHERE c = CAST(11 AS INTEGER) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(11 AS INTEGER) C ------------ select c from REAL_TAB WHERE c = CAST(11 AS INTEGER) C ------------- select c from DOUBLE_TAB WHERE c = CAST(11 AS INTEGER) C ---------------------- select c from CHAR_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'INTEGER' are not supported. select c from VARCHAR_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'INTEGER' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'INTEGER' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'INTEGER' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'INTEGER' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'INTEGER' are not supported. select c from CLOB_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'INTEGER' are not supported. select c from DATE_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'INTEGER' are not supported. select c from TIME_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'INTEGER' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'INTEGER' are not supported. select c from BLOB_TAB WHERE c = CAST(11 AS INTEGER) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'INTEGER' are not supported. select c from SMALLINT_TAB WHERE c = CAST(22 AS BIGINT) C ------ select c from INTEGER_TAB WHERE c = CAST(22 AS BIGINT) C ----------- select c from BIGINT_TAB WHERE c = CAST(22 AS BIGINT) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(22 AS BIGINT) C ------------ select c from REAL_TAB WHERE c = CAST(22 AS BIGINT) C ------------- select c from DOUBLE_TAB WHERE c = CAST(22 AS BIGINT) C ---------------------- select c from CHAR_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'BIGINT' are not supported. select c from VARCHAR_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'BIGINT' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'BIGINT' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'BIGINT' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'BIGINT' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'BIGINT' are not supported. select c from CLOB_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'BIGINT' are not supported. select c from DATE_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'BIGINT' are not supported. select c from TIME_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'BIGINT' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'BIGINT' are not supported. select c from BLOB_TAB WHERE c = CAST(22 AS BIGINT) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'BIGINT' are not supported. select c from SMALLINT_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) C ------ select c from INTEGER_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) C ----------- select c from BIGINT_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) C ------------ select c from REAL_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) C ------------- select c from DOUBLE_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) C ---------------------- select c from CHAR_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'DECIMAL' are not supported. select c from VARCHAR_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'DECIMAL' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'DECIMAL' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'DECIMAL' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'DECIMAL' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DECIMAL' are not supported. select c from CLOB_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'DECIMAL' are not supported. select c from DATE_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'DECIMAL' are not supported. select c from TIME_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'DECIMAL' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'DECIMAL' are not supported. select c from BLOB_TAB WHERE c = CAST(3.3 AS DECIMAL(10,5)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'DECIMAL' are not supported. select c from SMALLINT_TAB WHERE c = CAST(4.4 AS REAL) C ------ select c from INTEGER_TAB WHERE c = CAST(4.4 AS REAL) C ----------- select c from BIGINT_TAB WHERE c = CAST(4.4 AS REAL) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(4.4 AS REAL) C ------------ select c from REAL_TAB WHERE c = CAST(4.4 AS REAL) C ------------- select c from DOUBLE_TAB WHERE c = CAST(4.4 AS REAL) C ---------------------- select c from CHAR_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'REAL' are not supported. select c from VARCHAR_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'REAL' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'REAL' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'REAL' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'REAL' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'REAL' are not supported. select c from CLOB_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'REAL' are not supported. select c from DATE_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'REAL' are not supported. select c from TIME_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'REAL' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'REAL' are not supported. select c from BLOB_TAB WHERE c = CAST(4.4 AS REAL) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'REAL' are not supported. select c from SMALLINT_TAB WHERE c = CAST(5.5 AS DOUBLE) C ------ select c from INTEGER_TAB WHERE c = CAST(5.5 AS DOUBLE) C ----------- select c from BIGINT_TAB WHERE c = CAST(5.5 AS DOUBLE) C -------------------- select c from DECIMAL_TAB WHERE c = CAST(5.5 AS DOUBLE) C ------------ select c from REAL_TAB WHERE c = CAST(5.5 AS DOUBLE) C ------------- select c from DOUBLE_TAB WHERE c = CAST(5.5 AS DOUBLE) C ---------------------- select c from CHAR_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'DOUBLE' are not supported. select c from VARCHAR_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'DOUBLE' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'DOUBLE' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'DOUBLE' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'DOUBLE' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DOUBLE' are not supported. select c from CLOB_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'DOUBLE' are not supported. select c from DATE_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'DOUBLE' are not supported. select c from TIME_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'DOUBLE' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'DOUBLE' are not supported. select c from BLOB_TAB WHERE c = CAST(5.5 AS DOUBLE) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'DOUBLE' are not supported. select c from SMALLINT_TAB WHERE c = CAST('0' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'CHAR' are not supported. select c from INTEGER_TAB WHERE c = CAST('11' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'CHAR' are not supported. select c from BIGINT_TAB WHERE c = CAST('22' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'CHAR' are not supported. select c from DECIMAL_TAB WHERE c = CAST('3.3' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'CHAR' are not supported. select c from REAL_TAB WHERE c = CAST('4.4' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'CHAR' are not supported. select c from DOUBLE_TAB WHERE c = CAST('5.5' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'CHAR' are not supported. select c from CHAR_TAB WHERE c = CAST('7' AS CHAR(60)) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST('8' AS CHAR(60)) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST('9' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10aa' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10bb' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10cc' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select c from CLOB_TAB WHERE c = CAST('13' AS CHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'CHAR' are not supported. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS CHAR(60)) C ---------- select c from TIME_TAB WHERE c = CAST('15:30:20' AS CHAR(60)) C -------- select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS CHAR(60)) C -------------------------- select c from BLOB_TAB WHERE c = CAST(X'01dd' AS CHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select c from SMALLINT_TAB WHERE c = CAST('0' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'VARCHAR' are not supported. select c from INTEGER_TAB WHERE c = CAST('11' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'VARCHAR' are not supported. select c from BIGINT_TAB WHERE c = CAST('22' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'VARCHAR' are not supported. select c from DECIMAL_TAB WHERE c = CAST('3.3' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'VARCHAR' are not supported. select c from REAL_TAB WHERE c = CAST('4.4' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'VARCHAR' are not supported. select c from DOUBLE_TAB WHERE c = CAST('5.5' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'VARCHAR' are not supported. select c from CHAR_TAB WHERE c = CAST('7' AS VARCHAR(60)) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST('8' AS VARCHAR(60)) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST('9' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'VARCHAR' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10aa' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10bb' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10cc' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select c from CLOB_TAB WHERE c = CAST('13' AS VARCHAR(60)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'VARCHAR' are not supported. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS VARCHAR(60)) C ---------- select c from TIME_TAB WHERE c = CAST('15:30:20' AS VARCHAR(60)) C -------- select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS VARCHAR(60)) C -------------------------- select c from BLOB_TAB WHERE c = CAST(X'01dd' AS VARCHAR(60)) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select c from SMALLINT_TAB WHERE c = CAST('0' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'LONG VARCHAR' are not supported. select c from INTEGER_TAB WHERE c = CAST('11' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'LONG VARCHAR' are not supported. select c from BIGINT_TAB WHERE c = CAST('22' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'LONG VARCHAR' are not supported. select c from DECIMAL_TAB WHERE c = CAST('3.3' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'LONG VARCHAR' are not supported. select c from REAL_TAB WHERE c = CAST('4.4' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'LONG VARCHAR' are not supported. select c from DOUBLE_TAB WHERE c = CAST('5.5' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'LONG VARCHAR' are not supported. select c from CHAR_TAB WHERE c = CAST('7' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'LONG VARCHAR' are not supported. select c from VARCHAR_TAB WHERE c = CAST('8' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'LONG VARCHAR' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST('9' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10aa' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10bb' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10cc' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. select c from CLOB_TAB WHERE c = CAST('13' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'LONG VARCHAR' are not supported. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'LONG VARCHAR' are not supported. select c from TIME_TAB WHERE c = CAST('15:30:20' AS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'LONG VARCHAR' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS LONG VARCHAR) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'LONG VARCHAR' are not supported. select c from BLOB_TAB WHERE c = CAST(X'01dd' AS LONG VARCHAR) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'. select c from SMALLINT_TAB WHERE c = CAST('0' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from INTEGER_TAB WHERE c = CAST('11' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from BIGINT_TAB WHERE c = CAST('22' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from DECIMAL_TAB WHERE c = CAST('3.3' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from REAL_TAB WHERE c = CAST('4.4' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from DOUBLE_TAB WHERE c = CAST('5.5' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from CHAR_TAB WHERE c = CAST('7' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from VARCHAR_TAB WHERE c = CAST('8' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from LONG_VARCHAR_TAB WHERE c = CAST('9' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10aa' AS CHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10bb' AS CHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10cc' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CHAR () FOR BIT DATA' are not supported. select c from CLOB_TAB WHERE c = CAST('13' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from TIME_TAB WHERE c = CAST('15:30:20' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select c from BLOB_TAB WHERE c = CAST(X'01dd' AS CHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'CHAR () FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST('0' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from INTEGER_TAB WHERE c = CAST('11' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from BIGINT_TAB WHERE c = CAST('22' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from DECIMAL_TAB WHERE c = CAST('3.3' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from REAL_TAB WHERE c = CAST('4.4' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from DOUBLE_TAB WHERE c = CAST('5.5' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from CHAR_TAB WHERE c = CAST('7' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from VARCHAR_TAB WHERE c = CAST('8' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from LONG_VARCHAR_TAB WHERE c = CAST('9' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10aa' AS VARCHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10bb' AS VARCHAR(60) FOR BIT DATA) C ------------------------------------------------------------------------------------------------------------------------ select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10cc' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR () FOR BIT DATA' are not supported. select c from CLOB_TAB WHERE c = CAST('13' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from TIME_TAB WHERE c = CAST('15:30:20' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'VARCHAR () FOR BIT DATA'. select c from BLOB_TAB WHERE c = CAST(X'01dd' AS VARCHAR(60) FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'VARCHAR () FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST('0' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from INTEGER_TAB WHERE c = CAST('11' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from BIGINT_TAB WHERE c = CAST('22' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from DECIMAL_TAB WHERE c = CAST('3.3' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from REAL_TAB WHERE c = CAST('4.4' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from DOUBLE_TAB WHERE c = CAST('5.5' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from CHAR_TAB WHERE c = CAST('7' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from VARCHAR_TAB WHERE c = CAST('8' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from LONG_VARCHAR_TAB WHERE c = CAST('9' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10aa' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10bb' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'10cc' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from CLOB_TAB WHERE c = CAST('13' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from TIME_TAB WHERE c = CAST('15:30:20' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42846:Cannot convert types 'CHAR' to 'LONG VARCHAR FOR BIT DATA'. select c from BLOB_TAB WHERE c = CAST(X'01dd' AS LONG VARCHAR FOR BIT DATA) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'LONG VARCHAR FOR BIT DATA' are not supported. select c from SMALLINT_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'CLOB' are not supported. select c from INTEGER_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'CLOB' are not supported. select c from BIGINT_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'CLOB' are not supported. select c from DECIMAL_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'CLOB' are not supported. select c from REAL_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'CLOB' are not supported. select c from DOUBLE_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'CLOB' are not supported. select c from CHAR_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'CLOB' are not supported. select c from VARCHAR_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'CLOB' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'CLOB' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'CLOB' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'CLOB' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CLOB' are not supported. select c from CLOB_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'CLOB' are not supported. select c from DATE_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'CLOB' are not supported. select c from TIME_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'CLOB' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'CLOB' are not supported. select c from BLOB_TAB WHERE c = CAST('13' AS CLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'CLOB' are not supported. select c from SMALLINT_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'DATE' are not supported. select c from INTEGER_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'DATE' are not supported. select c from BIGINT_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'DATE' are not supported. select c from DECIMAL_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'DATE' are not supported. select c from REAL_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'DATE' are not supported. select c from DOUBLE_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'DATE' are not supported. select c from CHAR_TAB WHERE c = CAST('2000-01-01' AS DATE) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST('2000-01-01' AS DATE) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'DATE' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'DATE' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'DATE' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DATE' are not supported. select c from CLOB_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'DATE' are not supported. select c from DATE_TAB WHERE c = CAST('2000-01-01' AS DATE) C ---------- select c from TIME_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'DATE' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'DATE' are not supported. select c from BLOB_TAB WHERE c = CAST('2000-01-01' AS DATE) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'DATE' are not supported. select c from SMALLINT_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'TIME' are not supported. select c from INTEGER_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'TIME' are not supported. select c from BIGINT_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'TIME' are not supported. select c from DECIMAL_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'TIME' are not supported. select c from REAL_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'TIME' are not supported. select c from DOUBLE_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'TIME' are not supported. select c from CHAR_TAB WHERE c = CAST('15:30:20' AS TIME) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST('15:30:20' AS TIME) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'TIME' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'TIME' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'TIME' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'TIME' are not supported. select c from CLOB_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'TIME' are not supported. select c from DATE_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'TIME' are not supported. select c from TIME_TAB WHERE c = CAST('15:30:20' AS TIME) C -------- select c from TIMESTAMP_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'TIME' are not supported. select c from BLOB_TAB WHERE c = CAST('15:30:20' AS TIME) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'TIME' are not supported. select c from SMALLINT_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'TIMESTAMP' are not supported. select c from INTEGER_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'TIMESTAMP' are not supported. select c from BIGINT_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'TIMESTAMP' are not supported. select c from DECIMAL_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'TIMESTAMP' are not supported. select c from REAL_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'TIMESTAMP' are not supported. select c from DOUBLE_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'TIMESTAMP' are not supported. select c from CHAR_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) C ------------------------------------------------------------ select c from VARCHAR_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) C ------------------------------------------------------------ select c from LONG_VARCHAR_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'TIMESTAMP' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'TIMESTAMP' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'TIMESTAMP' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'TIMESTAMP' are not supported. select c from CLOB_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'TIMESTAMP' are not supported. select c from DATE_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'TIMESTAMP' are not supported. select c from TIME_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'TIMESTAMP' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) C -------------------------- select c from BLOB_TAB WHERE c = CAST('xxxxxxFILTERED-TIMESTAMPxxxxxAS TIMESTAMP) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'TIMESTAMP' are not supported. select c from SMALLINT_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'SMALLINT' and 'BLOB' are not supported. select c from INTEGER_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'INTEGER' and 'BLOB' are not supported. select c from BIGINT_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BIGINT' and 'BLOB' are not supported. select c from DECIMAL_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DECIMAL' and 'BLOB' are not supported. select c from REAL_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'REAL' and 'BLOB' are not supported. select c from DOUBLE_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DOUBLE' and 'BLOB' are not supported. select c from CHAR_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR' and 'BLOB' are not supported. select c from VARCHAR_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR' and 'BLOB' are not supported. select c from LONG_VARCHAR_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR' and 'BLOB' are not supported. select c from CHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported. select c from VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'VARCHAR () FOR BIT DATA' and 'BLOB' are not supported. select c from LONG_VARCHAR_FOR_BIT_DATA_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'BLOB' are not supported. select c from CLOB_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'CLOB' and 'BLOB' are not supported. select c from DATE_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'DATE' and 'BLOB' are not supported. select c from TIME_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIME' and 'BLOB' are not supported. select c from TIMESTAMP_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'TIMESTAMP' and 'BLOB' are not supported. select c from BLOB_TAB WHERE c = CAST(X'01dd' AS BLOB(1k)) EXPECTED EXCEPTION: 42818:Comparisons between 'BLOB' and 'BLOB' are not supported.