implicitconversions.sql

derby database source code.good for you.

select 1 from all_c1, all1 where tms > c_tms;
select 1 from all_c1, all1 where tms >= c_tms;
select 1 from all_c1, all1 where tms < c_tms;
select 1 from all_c1, all1 where tms <= c_tms;
select 1 from all_c1, all1 where lvc = c_lvc;
select 1 from all_c1, all1 where lvc > c_lvc;
select 1 from all_c1, all1 where lvc >= c_lvc;
select 1 from all_c1, all1 where lvc < c_lvc;
select 1 from all_c1, all1 where lvc <= c_lvc;

delete from all_c1;
insert into all_c1 (c_ti) values (null);

select 1 from all_c1, all1 where si = c_si;
select 1 from all_c1, all1 where si > c_si;
select 1 from all_c1, all1 where si >= c_si;
select 1 from all_c1, all1 where si < c_si;
select 1 from all_c1, all1 where si <= c_si;
select 1 from all_c1, all1 where i = c_i;
select 1 from all_c1, all1 where i > c_i;
select 1 from all_c1, all1 where i >= c_i;
select 1 from all_c1, all1 where i < c_i;
select 1 from all_c1, all1 where i <= c_i;
select 1 from all_c1, all1 where li = c_li;
select 1 from all_c1, all1 where li > c_li;
select 1 from all_c1, all1 where li >= c_li;
select 1 from all_c1, all1 where li < c_li;
select 1 from all_c1, all1 where li <= c_li;
select 1 from all_c1, all1 where r = c_r;
select 1 from all_c1, all1 where r > c_r;
select 1 from all_c1, all1 where r >= c_r;
select 1 from all_c1, all1 where r < c_r;
select 1 from all_c1, all1 where r <= c_r;
select 1 from all_c1, all1 where dp = c_dp;
select 1 from all_c1, all1 where dp > c_dp;
select 1 from all_c1, all1 where dp >= c_dp;
select 1 from all_c1, all1 where dp < c_dp;
select 1 from all_c1, all1 where dp <= c_dp;
select 1 from all_c1, all1 where dc = c_dc;
select 1 from all_c1, all1 where dc > c_dc;
select 1 from all_c1, all1 where dc >= c_dc;
select 1 from all_c1, all1 where dc < c_dc;
select 1 from all_c1, all1 where dc <= c_dc;
select 1 from all_c1, all1 where b = c_b;
select 1 from all_c1, all1 where b > c_b;
select 1 from all_c1, all1 where b >= c_b;
select 1 from all_c1, all1 where b < c_b;
select 1 from all_c1, all1 where b <= c_b;
select 1 from all_c1, all1 where bv = vc_bv;
select 1 from all_c1, all1 where bv > vc_bv;
select 1 from all_c1, all1 where bv >= vc_bv;
select 1 from all_c1, all1 where bv < vc_bv;
select 1 from all_c1, all1 where bv <= vc_bv;
select 1 from all_c1, all1 where lbv = vc_bv;
select 1 from all_c1, all1 where lbv > vc_bv;
select 1 from all_c1, all1 where lbv >= vc_bv;
select 1 from all_c1, all1 where lbv < vc_bv;
select 1 from all_c1, all1 where lbv <= vc_bv;
select 1 from all_c1, all1 where dt = c_dt;
select 1 from all_c1, all1 where dt > c_dt;
select 1 from all_c1, all1 where dt >= c_dt;
select 1 from all_c1, all1 where dt < c_dt;
select 1 from all_c1, all1 where dt <= c_dt;
select 1 from all_c1, all1 where tm = c_tm;
select 1 from all_c1, all1 where tm > c_tm;
select 1 from all_c1, all1 where tm >= c_tm;
select 1 from all_c1, all1 where tm < c_tm;
select 1 from all_c1, all1 where tm <= c_tm;
select 1 from all_c1, all1 where tms = c_tms;
select 1 from all_c1, all1 where tms > c_tms;
select 1 from all_c1, all1 where tms >= c_tms;
select 1 from all_c1, all1 where tms < c_tms;
select 1 from all_c1, all1 where tms <= c_tms;
select 1 from all_c1, all1 where lvc = c_lvc;
select 1 from all_c1, all1 where lvc > c_lvc;
select 1 from all_c1, all1 where lvc >= c_lvc;
select 1 from all_c1, all1 where lvc < c_lvc;
select 1 from all_c1, all1 where lvc <= c_lvc;

-- drop the indexes;
rollback;


-- test qualifiers with conversion to (var)char
select 1 from all1, all_c1 where si = c_si;
select 1 from all1, all_c1 where si > c_si;
select 1 from all1, all_c1 where si >= c_si;
select 1 from all1, all_c1 where si < c_si;
select 1 from all1, all_c1 where si <= c_si;
select 1 from all1, all_c1 where si <> c_si;
select 1 from all1, all_c1 where i = c_i;
select 1 from all1, all_c1 where i > c_i;
select 1 from all1, all_c1 where i >= c_i;
select 1 from all1, all_c1 where i < c_i;
select 1 from all1, all_c1 where i <= c_i;
select 1 from all1, all_c1 where i <> c_i;
select 1 from all1, all_c1 where li = c_li;
select 1 from all1, all_c1 where li > c_li;
select 1 from all1, all_c1 where li >= c_li;
select 1 from all1, all_c1 where li < c_li;
select 1 from all1, all_c1 where li <= c_li;
select 1 from all1, all_c1 where li <> c_li;
select 1 from all1, all_c1 where r = c_r;
select 1 from all1, all_c1 where r > c_r;
select 1 from all1, all_c1 where r >= c_r;
select 1 from all1, all_c1 where r < c_r;
select 1 from all1, all_c1 where r <= c_r;
select 1 from all1, all_c1 where r <> c_r;
select 1 from all1, all_c1 where dp = c_dp;
select 1 from all1, all_c1 where dp > c_dp;
select 1 from all1, all_c1 where dp >= c_dp;
select 1 from all1, all_c1 where dp < c_dp;
select 1 from all1, all_c1 where dp <= c_dp;
select 1 from all1, all_c1 where dp <> c_dp;
select 1 from all1, all_c1 where dc = c_dc;
select 1 from all1, all_c1 where dc > c_dc;
select 1 from all1, all_c1 where dc >= c_dc;
select 1 from all1, all_c1 where dc < c_dc;
select 1 from all1, all_c1 where dc <= c_dc;
select 1 from all1, all_c1 where dc <> c_dc;
select 1 from all1, all_c1 where b = c_b;
select 1 from all1, all_c1 where b > c_b;
select 1 from all1, all_c1 where b >= c_b;
select 1 from all1, all_c1 where b < c_b;
select 1 from all1, all_c1 where b <= c_b;
select 1 from all1, all_c1 where b <> c_b;
select 1 from all1, all_c1 where bv = vc_bv;
select 1 from all1, all_c1 where bv > vc_bv;
select 1 from all1, all_c1 where bv >= vc_bv;
select 1 from all1, all_c1 where bv < vc_bv;
select 1 from all1, all_c1 where bv <= vc_bv;
select 1 from all1, all_c1 where bv <> vc_bv;
select 1 from all1, all_c1 where lbv = vc_bv;
select 1 from all1, all_c1 where lbv > vc_bv;
select 1 from all1, all_c1 where lbv >= vc_bv;
select 1 from all1, all_c1 where lbv < vc_bv;
select 1 from all1, all_c1 where lbv <= vc_bv;
select 1 from all1, all_c1 where lbv <> vc_bv;
select 1 from all1, all_c1 where dt = c_dt;
select 1 from all1, all_c1 where dt > c_dt;
select 1 from all1, all_c1 where dt >= c_dt;
select 1 from all1, all_c1 where dt < c_dt;
select 1 from all1, all_c1 where dt <= c_dt;
select 1 from all1, all_c1 where dt <> c_dt;
select 1 from all1, all_c1 where tm = c_tm;
select 1 from all1, all_c1 where tm > c_tm;
select 1 from all1, all_c1 where tm >= c_tm;
select 1 from all1, all_c1 where tm < c_tm;
select 1 from all1, all_c1 where tm <= c_tm;
select 1 from all1, all_c1 where tm <> c_tm;
select 1 from all1, all_c1 where tms = c_tms;
select 1 from all1, all_c1 where tms > c_tms;
select 1 from all1, all_c1 where tms >= c_tms;
select 1 from all1, all_c1 where tms < c_tms;
select 1 from all1, all_c1 where tms <= c_tms;
select 1 from all1, all_c1 where tms <> c_tms;
select 1 from all1, all_c1 where lvc = c_lvc;
select 1 from all1, all_c1 where lvc > c_lvc;
select 1 from all1, all_c1 where lvc >= c_lvc;
select 1 from all1, all_c1 where lvc < c_lvc;
select 1 from all1, all_c1 where lvc <= c_lvc;
select 1 from all1, all_c1 where lvc <> c_lvc;

delete from all1;
insert into all1 (si) values (null);

select 1 from all1, all_c1 where si = c_si;
select 1 from all1, all_c1 where si > c_si;
select 1 from all1, all_c1 where si >= c_si;
select 1 from all1, all_c1 where si < c_si;
select 1 from all1, all_c1 where si <= c_si;
select 1 from all1, all_c1 where si <> c_si;
select 1 from all1, all_c1 where i = c_i;
select 1 from all1, all_c1 where i > c_i;
select 1 from all1, all_c1 where i >= c_i;
select 1 from all1, all_c1 where i < c_i;
select 1 from all1, all_c1 where i <= c_i;
select 1 from all1, all_c1 where i <> c_i;
select 1 from all1, all_c1 where li = c_li;
select 1 from all1, all_c1 where li > c_li;
select 1 from all1, all_c1 where li >= c_li;
select 1 from all1, all_c1 where li < c_li;
select 1 from all1, all_c1 where li <= c_li;
select 1 from all1, all_c1 where li <> c_li;
select 1 from all1, all_c1 where r = c_r;
select 1 from all1, all_c1 where r > c_r;
select 1 from all1, all_c1 where r >= c_r;
select 1 from all1, all_c1 where r < c_r;
select 1 from all1, all_c1 where r <= c_r;
select 1 from all1, all_c1 where r <> c_r;
select 1 from all1, all_c1 where dp = c_dp;
select 1 from all1, all_c1 where dp > c_dp;
select 1 from all1, all_c1 where dp >= c_dp;
select 1 from all1, all_c1 where dp < c_dp;
select 1 from all1, all_c1 where dp <= c_dp;
select 1 from all1, all_c1 where dp <> c_dp;
select 1 from all1, all_c1 where dc = c_dc;
select 1 from all1, all_c1 where dc > c_dc;
select 1 from all1, all_c1 where dc >= c_dc;
select 1 from all1, all_c1 where dc < c_dc;
select 1 from all1, all_c1 where dc <= c_dc;
select 1 from all1, all_c1 where dc <> c_dc;
select 1 from all1, all_c1 where b = c_b;
select 1 from all1, all_c1 where b > c_b;
select 1 from all1, all_c1 where b >= c_b;
select 1 from all1, all_c1 where b < c_b;
select 1 from all1, all_c1 where b <= c_b;
select 1 from all1, all_c1 where b <> c_b;
select 1 from all1, all_c1 where bv = vc_bv;
select 1 from all1, all_c1 where bv > vc_bv;
select 1 from all1, all_c1 where bv >= vc_bv;
select 1 from all1, all_c1 where bv < vc_bv;
select 1 from all1, all_c1 where bv <= vc_bv;
select 1 from all1, all_c1 where bv <> vc_bv;
select 1 from all1, all_c1 where lbv = vc_bv;
select 1 from all1, all_c1 where lbv > vc_bv;
select 1 from all1, all_c1 where lbv >= vc_bv;
select 1 from all1, all_c1 where lbv < vc_bv;
select 1 from all1, all_c1 where lbv <= vc_bv;
select 1 from all1, all_c1 where lbv <> vc_bv;
select 1 from all1, all_c1 where dt = c_dt;
select 1 from all1, all_c1 where dt > c_dt;
select 1 from all1, all_c1 where dt >= c_dt;
select 1 from all1, all_c1 where dt < c_dt;
select 1 from all1, all_c1 where dt <= c_dt;
select 1 from all1, all_c1 where dt <> c_dt;
select 1 from all1, all_c1 where tm = c_tm;
select 1 from all1, all_c1 where tm > c_tm;
select 1 from all1, all_c1 where tm >= c_tm;
select 1 from all1, all_c1 where tm < c_tm;
select 1 from all1, all_c1 where tm <= c_tm;
select 1 from all1, all_c1 where tm <> c_tm;
select 1 from all1, all_c1 where tms = c_tms;
select 1 from all1, all_c1 where tms > c_tms;
select 1 from all1, all_c1 where tms >= c_tms;
select 1 from all1, all_c1 where tms < c_tms;
select 1 from all1, all_c1 where tms <= c_tms;
select 1 from all1, all_c1 where tms <> c_tms;
select 1 from all1, all_c1 where lvc = c_lvc;
select 1 from all1, all_c1 where lvc > c_lvc;
select 1 from all1, all_c1 where lvc >= c_lvc;
select 1 from all1, all_c1 where lvc < c_lvc;
select 1 from all1, all_c1 where lvc <= c_lvc;
select 1 from all1, all_c1 where lvc <> c_lvc;

rollback;

-- test start and stop positions for conversions to (var)char
create index all1_si on all1(si);
create index all1_i on all1(i);
create index all1_li on all1(li);
create index all1_r on all1(r);
create index all1_dp on all1(dp);
create index all1_dc on all1(dc);
create index all1_num on all1(num);
create index all1_b on all1(b);
create index all1_bv on all1(bv);
create index all1_lbv on all1(lbv);
create index all1_dt on all1(dt);
create index all1_tm on all1(tm);
create index all1_tms on all1(tms);

select 1 from all1, all_c1 where si = c_si;
select 1 from all1, all_c1 where si > c_si;
select 1 from all1, all_c1 where si >= c_si;
select 1 from all1, all_c1 where si < c_si;
select 1 from all1, all_c1 where si <= c_si;
select 1 from all1, all_c1 where i = c_i;
select 1 from all1, all_c1 where i > c_i;
select 1 from all1, all_c1 where i >= c_i;
select 1 from all1, all_c1 where i < c_i;
select 1 from all1, all_c1 where i <= c_i;
select 1 from all1, all_c1 where li = c_li;
select 1 from all1, all_c1 where li > c_li;
select 1 from all1, all_c1 where li >= c_li;
select 1 from all1, all_c1 where li < c_li;
select 1 from all1, all_c1 where li <= c_li;
select 1 from all1, all_c1 where r = c_r;
select 1 from all1, all_c1 where r > c_r;
select 1 from all1, all_c1 where r >= c_r;
select 1 from all1, all_c1 where r < c_r;
select 1 from all1, all_c1 where r <= c_r;
select 1 from all1, all_c1 where dp = c_dp;
select 1 from all1, all_c1 where dp > c_dp;
select 1 from all1, all_c1 where dp >= c_dp;
select 1 from all1, all_c1 where dp < c_dp;
select 1 from all1, all_c1 where dp <= c_dp;
select 1 from all1, all_c1 where dc = c_dc;
select 1 from all1, all_c1 where dc > c_dc;
select 1 from all1, all_c1 where dc >= c_dc;
select 1 from all1, all_c1 where dc < c_dc;
select 1 from all1, all_c1 where dc <= c_dc;