implicitconversions.out

derby database source code.good for you.

ij> select si from all1 where cast(null as char) < cast(1 as smallint);
ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
ij> select si from all1 where cast(null as char) <= cast(1 as smallint);
ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
ij> select si from all1 where cast(null as char) <> cast(1 as smallint);
ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
ij> select si from all1 where cast(1 as int) = '1';
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) > '2';
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) >= '2';
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) < '2';
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) <= '2';
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) <> '2';
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) = cast(null as char);
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) > cast(null as char);
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) >= cast(null as char);
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) < cast(null as char);
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) <= cast(null as char);
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as int) <> cast(null as char);
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
ij> select si from all1 where '1' = cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where '2' > cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where '2' >= cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where '2' < cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where '2' <> cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where '2' <= cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(null as char) = cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(null as char) > cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(null as char) >= cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(null as char) < cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(null as char) <> cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(null as char) <= cast(1 as int);
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
ij> select si from all1 where cast(1 as bigint) = '1';
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) > '2';
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) >= '2';
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) < '2';
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) <= '2';
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) <> '2';
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) = cast(null as char);
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) > cast(null as char);
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) >= cast(null as char);
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) < cast(null as char);
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) <= cast(null as char);
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as bigint) <> cast(null as char);
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
ij> select si from all1 where '1' = cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where '2' > cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where '2' >= cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where '2' < cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where '2' <= cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where '2' <> cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(null as char) = cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(null as char) > cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(null as char) >= cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(null as char) < cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(null as char) <= cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(null as char) <> cast(1 as bigint);
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
ij> select si from all1 where cast(1 as real) = '1';
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) > '2';
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) >= '2';
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) < '2';
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) <> '2';
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) <= '2';
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) = cast(null as char);
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) > cast(null as char);
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) >= cast(null as char);
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) < cast(null as char);
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) <> cast(null as char);
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as real) <= cast(null as char);
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
ij> select si from all1 where '1' = cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where '2' > cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where '2' >= cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where '2' < cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where '2' <= cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where '2' <> cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(null as char) = cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(null as char) > cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(null as char) >= cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(null as char) < cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(null as char) <= cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(null as char) <> cast(1 as real);
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
ij> select si from all1 where cast(1 as double precision) = '1';
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) > '2';
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) >= '2';
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) < '2';
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) <= '2';
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) <> '2';
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) = cast(null as char);
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) > cast(null as char);
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) >= cast(null as char);
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) < cast(null as char);
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) <= cast(null as char);
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as double precision) <> cast(null as char);
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
ij> select si from all1 where '1' = cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where '2' > cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where '2' >= cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where '2' < cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where '2' <= cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where '2' <> cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(null as char) = cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(null as char) > cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(null as char) >= cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(null as char) < cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(null as char) <= cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(null as char) <> cast(1 as double precision);
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
ij> select si from all1 where cast(1 as numeric) = '1';
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) > '2';
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) >= '2';
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) < '2';
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) <= '2';
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) <> '2';
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) = cast(null as char);
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) > cast(null as char);
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) >= cast(null as char);
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) < cast(null as char);
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) <= cast(null as char);
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where cast(1 as numeric) <> cast(null as char);
ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
ij> select si from all1 where '1' = cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where '2' > cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where '2' >= cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where '2' < cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where '2' <= cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where '2' <> cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where cast(null as char) = cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where cast(null as char) > cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where cast(null as char) >= cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where cast(null as char) < cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where cast(null as char) <= cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> select si from all1 where cast(null as char) <> cast(1 as numeric);
ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
ij> -- the following queries return 1 if the search condition is satisfied
-- and returns nothing if the search condition is not satisfied
select 1 from all1 where '1996-09-09' = date('1996-09-09');
1          
-----------
1          
ij> select 1 from all1 where '1996-9-10' > date('1996-09-09');