coalescetests.out

derby database source code.good for you.

	{11.0}
	{111.0}
	{null}
SELECT VALUE(INTEGERCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands INTEGER , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{11.0}
	{111.0}
	{null}
SELECT COALESCE(INTEGERCOL,CHARCOL) from AllDataTypesTable
 Operands INTEGER , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'CHAR' is incompatible.
SELECT VALUE(INTEGERCOL,CHARCOL) from AllDataTypesTable
 Operands INTEGER , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'CHAR' is incompatible.
SELECT COALESCE(INTEGERCOL,VARCHARCOL) from AllDataTypesTable
 Operands INTEGER , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'VARCHAR' is incompatible.
SELECT VALUE(INTEGERCOL,VARCHARCOL) from AllDataTypesTable
 Operands INTEGER , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'VARCHAR' is incompatible.
SELECT COALESCE(INTEGERCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands INTEGER , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'LONG VARCHAR' is incompatible.
SELECT VALUE(INTEGERCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands INTEGER , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'LONG VARCHAR' is incompatible.
SELECT COALESCE(INTEGERCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands INTEGER , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(INTEGERCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands INTEGER , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT COALESCE(INTEGERCOL,VARCHARFORBITCOL) from AllDataTypesTable
 Operands INTEGER , VARCHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'VARCHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(INTEGERCOL,VARCHARFORBITCOL) from AllDataTypesTable
 Operands INTEGER , VARCHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'VARCHAR () FOR BIT DATA' is incompatible.
SELECT COALESCE(INTEGERCOL,LVARCHARFORBITCOL) from AllDataTypesTable
 Operands INTEGER , LONG VARCHAR FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'LONG VARCHAR FOR BIT DATA' is incompatible.
SELECT VALUE(INTEGERCOL,LVARCHARFORBITCOL) from AllDataTypesTable
 Operands INTEGER , LONG VARCHAR FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'LONG VARCHAR FOR BIT DATA' is incompatible.
SELECT COALESCE(INTEGERCOL,CLOBCOL) from AllDataTypesTable
 Operands INTEGER , CLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'CLOB' is incompatible.
SELECT VALUE(INTEGERCOL,CLOBCOL) from AllDataTypesTable
 Operands INTEGER , CLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'CLOB' is incompatible.
SELECT COALESCE(INTEGERCOL,DATECOL) from AllDataTypesTable
 Operands INTEGER , DATE are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'DATE' is incompatible.
SELECT VALUE(INTEGERCOL,DATECOL) from AllDataTypesTable
 Operands INTEGER , DATE are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'DATE' is incompatible.
SELECT COALESCE(INTEGERCOL,TIMECOL) from AllDataTypesTable
 Operands INTEGER , TIME are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'TIME' is incompatible.
SELECT VALUE(INTEGERCOL,TIMECOL) from AllDataTypesTable
 Operands INTEGER , TIME are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'TIME' is incompatible.
SELECT COALESCE(INTEGERCOL,TIMESTAMPCOL) from AllDataTypesTable
 Operands INTEGER , TIMESTAMP are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'TIMESTAMP' is incompatible.
SELECT VALUE(INTEGERCOL,TIMESTAMPCOL) from AllDataTypesTable
 Operands INTEGER , TIMESTAMP are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'TIMESTAMP' is incompatible.
SELECT COALESCE(INTEGERCOL,BLOBCOL) from AllDataTypesTable
 Operands INTEGER , BLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'BLOB' is incompatible.
SELECT VALUE(INTEGERCOL,BLOBCOL) from AllDataTypesTable
 Operands INTEGER , BLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'INTEGER' and 'BLOB' is incompatible.
SELECT COALESCE(BIGINTCOL,SMALLINTCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , SMALLINT will have result data type of BIGINT
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{22}
	{222}
	{3333}
SELECT VALUE(BIGINTCOL,SMALLINTCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , SMALLINT will have result data type of BIGINT
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{22}
	{222}
	{3333}
SELECT COALESCE(BIGINTCOL,INTEGERCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , INTEGER will have result data type of BIGINT
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{22}
	{222}
	{3333}
SELECT VALUE(BIGINTCOL,INTEGERCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , INTEGER will have result data type of BIGINT
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{22}
	{222}
	{3333}
SELECT COALESCE(BIGINTCOL,BIGINTCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , BIGINT will have result data type of BIGINT
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{22}
	{222}
	{3333}
SELECT VALUE(BIGINTCOL,BIGINTCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , BIGINT will have result data type of BIGINT
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{22}
	{222}
	{3333}
SELECT COALESCE(BIGINTCOL,DECIMALCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , DECIMAL(10,5) will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 24, scale : 5)
	 ---------------------------------------------------
	{null}
	{22.00000}
	{222.00000}
	{3333.00000}
SELECT VALUE(BIGINTCOL,DECIMALCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , DECIMAL(10,5) will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 24, scale : 5)
	 ---------------------------------------------------
	{null}
	{22.00000}
	{222.00000}
	{3333.00000}
SELECT COALESCE(BIGINTCOL,REALCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , REAL will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{22.0}
	{222.0}
	{3333.0}
SELECT VALUE(BIGINTCOL,REALCOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , REAL will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{22.0}
	{222.0}
	{3333.0}
SELECT COALESCE(BIGINTCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{22.0}
	{222.0}
	{3333.0}
SELECT VALUE(BIGINTCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands BIGINT , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{22.0}
	{222.0}
	{3333.0}
SELECT COALESCE(BIGINTCOL,CHARCOL) from AllDataTypesTable
 Operands BIGINT , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'CHAR' is incompatible.
SELECT VALUE(BIGINTCOL,CHARCOL) from AllDataTypesTable
 Operands BIGINT , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'CHAR' is incompatible.
SELECT COALESCE(BIGINTCOL,VARCHARCOL) from AllDataTypesTable
 Operands BIGINT , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'VARCHAR' is incompatible.
SELECT VALUE(BIGINTCOL,VARCHARCOL) from AllDataTypesTable
 Operands BIGINT , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'VARCHAR' is incompatible.
SELECT COALESCE(BIGINTCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands BIGINT , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'LONG VARCHAR' is incompatible.
SELECT VALUE(BIGINTCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands BIGINT , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'LONG VARCHAR' is incompatible.
SELECT COALESCE(BIGINTCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands BIGINT , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(BIGINTCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands BIGINT , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT COALESCE(BIGINTCOL,VARCHARFORBITCOL) from AllDataTypesTable
 Operands BIGINT , VARCHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'VARCHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(BIGINTCOL,VARCHARFORBITCOL) from AllDataTypesTable
 Operands BIGINT , VARCHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'VARCHAR () FOR BIT DATA' is incompatible.
SELECT COALESCE(BIGINTCOL,LVARCHARFORBITCOL) from AllDataTypesTable
 Operands BIGINT , LONG VARCHAR FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'LONG VARCHAR FOR BIT DATA' is incompatible.
SELECT VALUE(BIGINTCOL,LVARCHARFORBITCOL) from AllDataTypesTable
 Operands BIGINT , LONG VARCHAR FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'LONG VARCHAR FOR BIT DATA' is incompatible.
SELECT COALESCE(BIGINTCOL,CLOBCOL) from AllDataTypesTable
 Operands BIGINT , CLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'CLOB' is incompatible.
SELECT VALUE(BIGINTCOL,CLOBCOL) from AllDataTypesTable
 Operands BIGINT , CLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'CLOB' is incompatible.
SELECT COALESCE(BIGINTCOL,DATECOL) from AllDataTypesTable
 Operands BIGINT , DATE are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'DATE' is incompatible.
SELECT VALUE(BIGINTCOL,DATECOL) from AllDataTypesTable
 Operands BIGINT , DATE are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'DATE' is incompatible.
SELECT COALESCE(BIGINTCOL,TIMECOL) from AllDataTypesTable
 Operands BIGINT , TIME are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'TIME' is incompatible.
SELECT VALUE(BIGINTCOL,TIMECOL) from AllDataTypesTable
 Operands BIGINT , TIME are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'TIME' is incompatible.
SELECT COALESCE(BIGINTCOL,TIMESTAMPCOL) from AllDataTypesTable
 Operands BIGINT , TIMESTAMP are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'TIMESTAMP' is incompatible.
SELECT VALUE(BIGINTCOL,TIMESTAMPCOL) from AllDataTypesTable
 Operands BIGINT , TIMESTAMP are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'TIMESTAMP' is incompatible.
SELECT COALESCE(BIGINTCOL,BLOBCOL) from AllDataTypesTable
 Operands BIGINT , BLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'BLOB' is incompatible.
SELECT VALUE(BIGINTCOL,BLOBCOL) from AllDataTypesTable
 Operands BIGINT , BLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'BIGINT' and 'BLOB' is incompatible.
SELECT COALESCE(DECIMALCOL,SMALLINTCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , SMALLINT will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}
	{3.33000}
	{2.00000}
SELECT VALUE(DECIMALCOL,SMALLINTCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , SMALLINT will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}
	{3.33000}
	{2.00000}
SELECT COALESCE(DECIMALCOL,INTEGERCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , INTEGER will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 15, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}