casting.out

derby database source code.good for you.

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'.