casting.out

derby database source code.good for you.

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)