implicitconversions.out

derby database source code.good for you.

ij> select si from all1 where cast(null as char) < X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where cast(null as char) <= X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where cast(null as char) <> X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where X'0020' = ' ';
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' > ' ';
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' >= ' ';
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' < ' ';
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' <= ' ';
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' <> ' ';
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'0020' = cast(null as char);
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' > cast(null as char);
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' >= cast(null as char);
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' < cast(null as char);
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' <= cast(null as char);
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select si from all1 where X'001F' <> cast(null as char);
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> create table all_c1(c_ti char(3), c_si char(10), c_i char(30), c_li char(30), 
					c_r char(50), c_dp char(50), c_dc char(10), 
					c_num char(50), c_bool char(5), c_b char(8), 
					vc_bv varchar(16), vc_lbv varchar(16), c_dt char(10),
					c_tm char(16), c_tms char(21), c_c char(30),
					vc_vc char(30), c_lvc char(30));
0 rows inserted/updated/deleted
ij> insert into all_c1 values ('1', '2', '3', '4', '5.5', '6.6', '7.7', '8.8',
						   'true', ' ', ' ', ' ', '1996-09-09', '12:12:12',
						   'xxxxxxFILTERED-TIMESTAMPxxxxx', '1', '2', '33333333');
1 row inserted/updated/deleted
ij> -- test qualifiers with conversion from (var)char
select 1 from all_c1, all1 where si = c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si > c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si >= c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si < c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si <= c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si <> c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i = c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i > c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i >= c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i < c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i <= c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i <> c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where li = c_li;
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where li > c_li;
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where li >= c_li;
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where li < c_li;
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where li <= c_li;
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where li <> c_li;
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where r = c_r;
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where r > c_r;
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where r >= c_r;
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where r < c_r;
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where r <= c_r;
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where r <> c_r;
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dp = c_dp;
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dp > c_dp;
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dp >= c_dp;
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dp < c_dp;
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dp <= c_dp;
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dp <> c_dp;
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dc = c_dc;
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dc > c_dc;
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dc >= c_dc;
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dc < c_dc;
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dc <= c_dc;
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where dc <> c_dc;
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where b = c_b;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where b > c_b;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where b >= c_b;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where b < c_b;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where b <= c_b;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where b <> c_b;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where bv = vc_bv;
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where bv > vc_bv;
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where bv >= vc_bv;
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where bv < vc_bv;
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where bv <= vc_bv;
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where bv <> vc_bv;
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where lbv = vc_bv;
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where lbv > vc_bv;
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where lbv >= vc_bv;
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where lbv < vc_bv;
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where lbv <= vc_bv;
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where lbv <> vc_bv;
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
ij> select 1 from all_c1, all1 where dt = c_dt;
1          
-----------
1          
ij> select 1 from all_c1, all1 where dt > c_dt;
1          
-----------
ij> select 1 from all_c1, all1 where dt >= c_dt;
1          
-----------
1          
ij> select 1 from all_c1, all1 where dt < c_dt;
1          
-----------
ij> select 1 from all_c1, all1 where dt <= c_dt;
1          
-----------
1          
ij> select 1 from all_c1, all1 where dt <> c_dt;
1          
-----------
ij> select 1 from all_c1, all1 where tm = c_tm;
1          
-----------
1          
ij> select 1 from all_c1, all1 where tm > c_tm;
1          
-----------
ij> select 1 from all_c1, all1 where tm >= c_tm;
1          
-----------
1          
ij> select 1 from all_c1, all1 where tm < c_tm;
1          
-----------
ij> select 1 from all_c1, all1 where tm <= c_tm;
1          
-----------
1          
ij> select 1 from all_c1, all1 where tm <> c_tm;
1          
-----------
ij> select 1 from all_c1, all1 where tms = c_tms;
1          
-----------
1          
ij> select 1 from all_c1, all1 where tms > c_tms;
1          
-----------
ij> select 1 from all_c1, all1 where tms >= c_tms;
1          
-----------
1          
ij> select 1 from all_c1, all1 where tms < c_tms;
1          
-----------
ij> select 1 from all_c1, all1 where tms <= c_tms;
1          
-----------
1          
ij> select 1 from all_c1, all1 where tms <> c_tms;
1          
-----------
ij> select 1 from all_c1, all1 where lvc = c_lvc;
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where lvc > c_lvc;
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where lvc >= c_lvc;
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where lvc < c_lvc;
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where lvc <= c_lvc;
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where lvc <> c_lvc;
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
ij> autocommit off;
ij> delete from all_c1;
1 row inserted/updated/deleted
ij> insert into all_c1 (c_ti) values (null);
1 row inserted/updated/deleted
ij> select 1 from all_c1, all1 where si = c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si > c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si >= c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si < c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si <= c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where si <> c_si;
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i = c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i > c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i >= c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i < c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i <= c_i;
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select 1 from all_c1, all1 where i <> c_i;