casting.out

derby database source code.good for you.

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'