resultset.out

derby database source code.good for you.

ERROR 42818: Comparisons between 'DOUBLE' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(DOUBLECOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(DOUBLECOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(DOUBLECOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(DOUBLECOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'CLOB' are not supported.
SELECT NULLIF(DOUBLECOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'DATE' are not supported.
SELECT NULLIF(DOUBLECOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'TIME' are not supported.
SELECT NULLIF(DOUBLECOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'TIMESTAMP' are not supported.
SELECT NULLIF(DOUBLECOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DOUBLE' and 'BLOB' are not supported.
SELECT NULLIF(CHARCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
SELECT NULLIF(CHARCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
SELECT NULLIF(CHARCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
SELECT NULLIF(CHARCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'DECIMAL' are not supported.
SELECT NULLIF(CHARCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
SELECT NULLIF(CHARCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
SELECT NULLIF(CHARCOL,CHARCOL) from AllDataTypesTable
	 COL1(datatype : CHAR, precision : 60, scale : 0)
	 ------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(CHARCOL,VARCHARCOL) from AllDataTypesTable
	 COL1(datatype : CHAR, precision : 60, scale : 0)
	 ------------------------------------------------
	{null}
	{null}
	{null}
	{2.0                                                         }
SELECT NULLIF(CHARCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(CHARCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(CHARCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(CHARCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(CHARCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'CLOB' are not supported.
SELECT NULLIF(CHARCOL,DATECOL) from AllDataTypesTable
	 COL1(datatype : CHAR, precision : 60, scale : 0)
	 ------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(CHARCOL,TIMECOL) from AllDataTypesTable
	 COL1(datatype : CHAR, precision : 60, scale : 0)
	 ------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(CHARCOL,TIMESTAMPCOL) from AllDataTypesTable
	 COL1(datatype : CHAR, precision : 60, scale : 0)
	 ------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(CHARCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR' and 'BLOB' are not supported.
SELECT NULLIF(VARCHARCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'SMALLINT' are not supported.
SELECT NULLIF(VARCHARCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'INTEGER' are not supported.
SELECT NULLIF(VARCHARCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'BIGINT' are not supported.
SELECT NULLIF(VARCHARCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'DECIMAL' are not supported.
SELECT NULLIF(VARCHARCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'REAL' are not supported.
SELECT NULLIF(VARCHARCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'DOUBLE' are not supported.
SELECT NULLIF(VARCHARCOL,CHARCOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{15:30:20}
SELECT NULLIF(VARCHARCOL,VARCHARCOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(VARCHARCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(VARCHARCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(VARCHARCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(VARCHARCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(VARCHARCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'CLOB' are not supported.
SELECT NULLIF(VARCHARCOL,DATECOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
	 ---------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(VARCHARCOL,TIMECOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
	 ---------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(VARCHARCOL,TIMESTAMPCOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
	 ---------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(VARCHARCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR' and 'BLOB' are not supported.
SELECT NULLIF(LONGVARCHARCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'SMALLINT' are not supported.
SELECT NULLIF(LONGVARCHARCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'INTEGER' are not supported.
SELECT NULLIF(LONGVARCHARCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'BIGINT' are not supported.
SELECT NULLIF(LONGVARCHARCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'DECIMAL' are not supported.
SELECT NULLIF(LONGVARCHARCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'REAL' are not supported.
SELECT NULLIF(LONGVARCHARCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'DOUBLE' are not supported.
SELECT NULLIF(LONGVARCHARCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR' are not supported.
SELECT NULLIF(LONGVARCHARCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'VARCHAR' are not supported.
SELECT NULLIF(LONGVARCHARCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(LONGVARCHARCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(LONGVARCHARCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(LONGVARCHARCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(LONGVARCHARCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'CLOB' are not supported.
SELECT NULLIF(LONGVARCHARCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'DATE' are not supported.
SELECT NULLIF(LONGVARCHARCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'TIME' are not supported.
SELECT NULLIF(LONGVARCHARCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'TIMESTAMP' are not supported.
SELECT NULLIF(LONGVARCHARCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR' and 'BLOB' are not supported.
SELECT NULLIF(CHARFORBITCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'SMALLINT' are not supported.
SELECT NULLIF(CHARFORBITCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'INTEGER' are not supported.
SELECT NULLIF(CHARFORBITCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'BIGINT' are not supported.
SELECT NULLIF(CHARFORBITCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'DECIMAL' are not supported.
SELECT NULLIF(CHARFORBITCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'REAL' are not supported.
SELECT NULLIF(CHARFORBITCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'DOUBLE' are not supported.
SELECT NULLIF(CHARFORBITCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
SELECT NULLIF(CHARFORBITCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
SELECT NULLIF(CHARFORBITCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(CHARFORBITCOL,CHARFORBITCOL) from AllDataTypesTable
	 COL1(datatype : CHAR FOR BIT DATA, precision : 60, scale : 0)
	 -------------------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(CHARFORBITCOL,VARCHARFORBITCOL) from AllDataTypesTable
	 COL1(datatype : CHAR FOR BIT DATA, precision : 60, scale : 0)
	 -------------------------------------------------------------
	{null}
	{null}
	{null}
	{10aaaa202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020}
SELECT NULLIF(CHARFORBITCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(CHARFORBITCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CLOB' are not supported.
SELECT NULLIF(CHARFORBITCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'DATE' are not supported.
SELECT NULLIF(CHARFORBITCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'TIME' are not supported.
SELECT NULLIF(CHARFORBITCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'TIMESTAMP' are not supported.
SELECT NULLIF(CHARFORBITCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'SMALLINT' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'INTEGER' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'BIGINT' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'DECIMAL' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'REAL' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'DOUBLE' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'CHAR' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'VARCHAR' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,CHARFORBITCOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR FOR BIT DATA, precision : 60, scale : 0)
	 ----------------------------------------------------------------
	{null}
	{null}
	{null}
	{10aaba}
SELECT NULLIF(VARCHARFORBITCOL,VARCHARFORBITCOL) from AllDataTypesTable
	 COL1(datatype : VARCHAR FOR BIT DATA, precision : 60, scale : 0)
	 ----------------------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(VARCHARFORBITCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'CLOB' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'DATE' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'TIME' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'TIMESTAMP' are not supported.
SELECT NULLIF(VARCHARFORBITCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'VARCHAR () FOR BIT DATA' and 'BLOB' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'SMALLINT' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'INTEGER' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'BIGINT' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DECIMAL' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'REAL' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DOUBLE' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CHAR' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'CLOB' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'DATE' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'TIME' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'TIMESTAMP' are not supported.
SELECT NULLIF(LVARCHARFORBITCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'LONG VARCHAR FOR BIT DATA' and 'BLOB' are not supported.
SELECT NULLIF(CLOBCOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'SMALLINT' are not supported.
SELECT NULLIF(CLOBCOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'INTEGER' are not supported.
SELECT NULLIF(CLOBCOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'BIGINT' are not supported.
SELECT NULLIF(CLOBCOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'DECIMAL' are not supported.
SELECT NULLIF(CLOBCOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'REAL' are not supported.
SELECT NULLIF(CLOBCOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'DOUBLE' are not supported.
SELECT NULLIF(CLOBCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'CHAR' are not supported.
SELECT NULLIF(CLOBCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'VARCHAR' are not supported.
SELECT NULLIF(CLOBCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(CLOBCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(CLOBCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(CLOBCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(CLOBCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
SELECT NULLIF(CLOBCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'DATE' are not supported.
SELECT NULLIF(CLOBCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'TIME' are not supported.
SELECT NULLIF(CLOBCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'TIMESTAMP' are not supported.
SELECT NULLIF(CLOBCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'CLOB' and 'BLOB' are not supported.
SELECT NULLIF(DATECOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'SMALLINT' are not supported.
SELECT NULLIF(DATECOL,INTEGERCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'INTEGER' are not supported.
SELECT NULLIF(DATECOL,BIGINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'BIGINT' are not supported.
SELECT NULLIF(DATECOL,DECIMALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'DECIMAL' are not supported.
SELECT NULLIF(DATECOL,REALCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'REAL' are not supported.
SELECT NULLIF(DATECOL,DOUBLECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'DOUBLE' are not supported.
SELECT NULLIF(DATECOL,CHARCOL) from AllDataTypesTable
	 COL1(datatype : DATE, precision : 10, scale : 0)
	 ------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(DATECOL,VARCHARCOL) from AllDataTypesTable
	 COL1(datatype : DATE, precision : 10, scale : 0)
	 ------------------------------------------------
Data Conversion SQLException
SELECT NULLIF(DATECOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(DATECOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(DATECOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(DATECOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(DATECOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'CLOB' are not supported.
SELECT NULLIF(DATECOL,DATECOL) from AllDataTypesTable
	 COL1(datatype : DATE, precision : 10, scale : 0)
	 ------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(DATECOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'TIME' are not supported.
SELECT NULLIF(DATECOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'TIMESTAMP' are not supported.
SELECT NULLIF(DATECOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DATE' and 'BLOB' are not supported.
SELECT NULLIF(TIMECOL,SMALLINTCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'TIME' and 'SMALLINT' are not suppor