casting.out

derby database source code.good for you.

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