casting.out

derby database source code.good for you.

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))