implicitconversions.out

derby database source code.good for you.

1          
-----------
1          
ij> select 1 from all1 where '1996-9-10' >= date('1996-09-09');
1          
-----------
1          
ij> select 1 from all1 where '1996-9-10' < date('1996-09-09');
1          
-----------
ij> select 1 from all1 where '1996-9-10' <= date('1996-09-09');
1          
-----------
ij> select 1 from all1 where '1996-9-10' <> date('1996-09-09');
1          
-----------
1          
ij> select 1 from all1 where cast(null as char) = date('1996-09-09');
1          
-----------
ij> select 1 from all1 where cast(null as char)> date('1996-09-09');
1          
-----------
ij> select 1 from all1 where cast(null as char)>= date('1996-09-09');
1          
-----------
ij> select 1 from all1 where cast(null as char)< date('1996-09-09');
1          
-----------
ij> select 1 from all1 where cast(null as char)<= date('1996-09-09');
1          
-----------
ij> select 1 from all1 where cast(null as char)<> date('1996-09-09');
1          
-----------
ij> select 1 from all1 where date('1996-09-09') = '1996-09-09';
1          
-----------
1          
ij> select 1 from all1 where date('1996-9-10') > '1996-09-09';
1          
-----------
1          
ij> select 1 from all1 where date('1996-9-10') >= '1996-09-09';
1          
-----------
1          
ij> select 1 from all1 where date('1996-9-10') < '1996-09-09';
1          
-----------
ij> select 1 from all1 where date('1996-9-10') <= '1996-09-09';
1          
-----------
ij> select 1 from all1 where date('1996-9-10') <> '1996-09-09';
1          
-----------
1          
ij> select 1 from all1 where date('1996-09-09') = cast(null as char);
1          
-----------
ij> select 1 from all1 where date('1996-9-10') > cast(null as char);
1          
-----------
ij> select 1 from all1 where date('1996-9-10') >= cast(null as char);
1          
-----------
ij> select 1 from all1 where date('1996-9-10') < cast(null as char);
1          
-----------
ij> select 1 from all1 where date('1996-9-10') <= cast(null as char);
1          
-----------
ij> select 1 from all1 where date('1996-9-10') <> cast(null as char);
1          
-----------
ij> select 1 from all1 where '12:12:12' = time('12:12:12');
1          
-----------
1          
ij> select 1 from all1 where '12:13:12' > time('12:12:12');
1          
-----------
1          
ij> select 1 from all1 where '12:13:12' >= time('12:12:12');
1          
-----------
1          
ij> select 1 from all1 where '12:13:12' < time('12:12:12');
1          
-----------
ij> select 1 from all1 where '12:13:12' <= time('12:12:12');
1          
-----------
ij> select 1 from all1 where '12:13:12' <> time('12:12:12');
1          
-----------
1          
ij> select 1 from all1 where cast(null as char) = time('12:12:12');
1          
-----------
ij> select 1 from all1 where cast(null as char) > time('12:12:12');
1          
-----------
ij> select 1 from all1 where cast(null as char) >= time('12:12:12');
1          
-----------
ij> select 1 from all1 where cast(null as char) < time('12:12:12');
1          
-----------
ij> select 1 from all1 where cast(null as char) <= time('12:12:12');
1          
-----------
ij> select 1 from all1 where cast(null as char) <> time('12:12:12');
1          
-----------
ij> select 1 from all1 where time('12:12:12') = '12:12:12';
1          
-----------
1          
ij> select 1 from all1 where time('12:13:12') > '12:12:12';
1          
-----------
1          
ij> select 1 from all1 where time('12:13:12') >= '12:12:12';
1          
-----------
1          
ij> select 1 from all1 where time('12:13:12') < '12:12:12';
1          
-----------
ij> select 1 from all1 where time('12:13:12') <= '12:12:12';
1          
-----------
ij> select 1 from all1 where time('12:13:12') <> '12:12:12';
1          
-----------
1          
ij> select 1 from all1 where time('12:12:12') = cast(null as char);
1          
-----------
ij> select 1 from all1 where time('12:13:12') > cast(null as char);
1          
-----------
ij> select 1 from all1 where time('12:13:12') >= cast(null as char);
1          
-----------
ij> select 1 from all1 where time('12:13:12') < cast(null as char);
1          
-----------
ij> select 1 from all1 where time('12:13:12') <= cast(null as char);
1          
-----------
ij> select 1 from all1 where time('12:13:12') <> cast(null as char);
1          
-----------
ij> select 1 from all1 where 'xxxxxxFILTERED-TIMESTAMPxxxxx' = timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
1          
ij> select 1 from all1 where 'xxxxxxFILTERED-TIMESTAMPxxxxx' > timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
1          
ij> select 1 from all1 where 'xxxxxxFILTERED-TIMESTAMPxxxxx' >= timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
1          
ij> select 1 from all1 where 'xxxxxxFILTERED-TIMESTAMPxxxxx' < timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where 'xxxxxxFILTERED-TIMESTAMPxxxxx' <= timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where 'xxxxxxFILTERED-TIMESTAMPxxxxx' <> timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
1          
ij> select 1 from all1 where cast(null as char) = timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where cast(null as char) > timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where cast(null as char) >= timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where cast(null as char) < timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where cast(null as char) <= timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where cast(null as char) <> timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx');
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )= 'xxxxxxFILTERED-TIMESTAMPxxxxx';
1          
-----------
1          
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )> 'xxxxxxFILTERED-TIMESTAMPxxxxx';
1          
-----------
1          
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )>= 'xxxxxxFILTERED-TIMESTAMPxxxxx';
1          
-----------
1          
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )< 'xxxxxxFILTERED-TIMESTAMPxxxxx';
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )<= 'xxxxxxFILTERED-TIMESTAMPxxxxx';
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )<> 'xxxxxxFILTERED-TIMESTAMPxxxxx';
1          
-----------
1          
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )= cast(null as char);
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )> cast(null as char);
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )>= cast(null as char);
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )< cast(null as char);
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )<= cast(null as char);
1          
-----------
ij> select 1 from all1 where timestamp('xxxxxxFILTERED-TIMESTAMPxxxxx' )<> cast(null as char);
1          
-----------
ij> select si from all1 where ' ' = X'0020';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where ' ' > X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where ' ' >= X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where ' ' < X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where ' ' <= X'001F';
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
ij> select si from all1 where ' ' <> 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'0020';
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.