implicitconversions.out

derby database source code.good for you.

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          
-----------
ij> select 1 from all_c1, all1 where dt > c_dt;
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          
-----------
ij> select 1 from all_c1, all1 where dt <= c_dt;
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          
-----------
ij> select 1 from all_c1, all1 where tm > c_tm;
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          
-----------
ij> select 1 from all_c1, all1 where tm <= c_tm;
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          
-----------
ij> select 1 from all_c1, all1 where tms > c_tms;
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          
-----------
ij> select 1 from all_c1, all1 where tms <= c_tms;
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> rollback;
ij> -- test start and stop positions for conversions to (var)char
create index all_c1_ti on all_c1(c_ti);
0 rows inserted/updated/deleted
ij> create index all_c1_si on all_c1(c_si);
0 rows inserted/updated/deleted
ij> create index all_c1_i on all_c1(c_i);
0 rows inserted/updated/deleted
ij> create index all_c1_li on all_c1(c_li);
0 rows inserted/updated/deleted
ij> create index all_c1_r on all_c1(c_r);
0 rows inserted/updated/deleted
ij> create index all_c1_dp on all_c1(c_dp);
0 rows inserted/updated/deleted
ij> create index all_c1_dc on all_c1(c_dc);
0 rows inserted/updated/deleted
ij> create index all_c1_num on all_c1(c_num);
0 rows inserted/updated/deleted
ij> create index all_c1_bool on all_c1(c_bool);
0 rows inserted/updated/deleted
ij> create index all_c1_b on all_c1(c_b);
0 rows inserted/updated/deleted
ij> create index all_c1_bv on all_c1(vc_bv);
0 rows inserted/updated/deleted
ij> create index all_c1_dt on all_c1(c_dt);
0 rows inserted/updated/deleted
ij> create index all_c1_tm on all_c1(c_tm);
0 rows inserted/updated/deleted
ij> create index all_c1_tms on all_c1(c_tms);
0 rows inserted/updated/deleted
ij> create index all_c1_lvc on all_c1(c_lvc);
0 rows 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 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 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 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 (