coalescetests.out

derby database source code.good for you.

	{3.33000}
	{null}
SELECT VALUE(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}
	{3.33000}
	{null}
SELECT COALESCE(DECIMALCOL,BIGINTCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , BIGINT will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 24, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}
	{3.33000}
	{3333.00000}
SELECT VALUE(DECIMALCOL,BIGINTCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , BIGINT will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 24, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}
	{3.33000}
	{3333.00000}
SELECT COALESCE(DECIMALCOL,DECIMALCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , DECIMAL(10,5) will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}
	{3.33000}
	{null}
SELECT VALUE(DECIMALCOL,DECIMALCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , DECIMAL(10,5) will have result data type of DECIMAL
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{3.30000}
	{3.33000}
	{null}
SELECT COALESCE(DECIMALCOL,REALCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , REAL will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{3.3}
	{3.33}
	{4.443999767303467}
SELECT VALUE(DECIMALCOL,REALCOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , REAL will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{3.3}
	{3.33}
	{4.443999767303467}
SELECT COALESCE(DECIMALCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{3.3}
	{3.33}
	{null}
SELECT VALUE(DECIMALCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands DECIMAL(10,5) , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{3.3}
	{3.33}
	{null}
SELECT COALESCE(DECIMALCOL,CHARCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'CHAR' is incompatible.
SELECT VALUE(DECIMALCOL,CHARCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'CHAR' is incompatible.
SELECT COALESCE(DECIMALCOL,VARCHARCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'VARCHAR' is incompatible.
SELECT VALUE(DECIMALCOL,VARCHARCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'VARCHAR' is incompatible.
SELECT COALESCE(DECIMALCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'LONG VARCHAR' is incompatible.
SELECT VALUE(DECIMALCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'LONG VARCHAR' is incompatible.
SELECT COALESCE(DECIMALCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(DECIMALCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT COALESCE(DECIMALCOL,VARCHARFORBITCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , VARCHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'VARCHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(DECIMALCOL,VARCHARFORBITCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , VARCHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'VARCHAR () FOR BIT DATA' is incompatible.
SELECT COALESCE(DECIMALCOL,LVARCHARFORBITCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , LONG VARCHAR FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'LONG VARCHAR FOR BIT DATA' is incompatible.
SELECT VALUE(DECIMALCOL,LVARCHARFORBITCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , LONG VARCHAR FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'LONG VARCHAR FOR BIT DATA' is incompatible.
SELECT COALESCE(DECIMALCOL,CLOBCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , CLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'CLOB' is incompatible.
SELECT VALUE(DECIMALCOL,CLOBCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , CLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'CLOB' is incompatible.
SELECT COALESCE(DECIMALCOL,DATECOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , DATE are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'DATE' is incompatible.
SELECT VALUE(DECIMALCOL,DATECOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , DATE are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'DATE' is incompatible.
SELECT COALESCE(DECIMALCOL,TIMECOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , TIME are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'TIME' is incompatible.
SELECT VALUE(DECIMALCOL,TIMECOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , TIME are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'TIME' is incompatible.
SELECT COALESCE(DECIMALCOL,TIMESTAMPCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , TIMESTAMP are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'TIMESTAMP' is incompatible.
SELECT VALUE(DECIMALCOL,TIMESTAMPCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , TIMESTAMP are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'TIMESTAMP' is incompatible.
SELECT COALESCE(DECIMALCOL,BLOBCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , BLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'BLOB' is incompatible.
SELECT VALUE(DECIMALCOL,BLOBCOL) from AllDataTypesTable
 Operands DECIMAL(10,5) , BLOB(1k) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'DECIMAL' and 'BLOB' is incompatible.
SELECT COALESCE(REALCOL,SMALLINTCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , SMALLINT will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT VALUE(REALCOL,SMALLINTCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , SMALLINT will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT COALESCE(REALCOL,INTEGERCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , INTEGER will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT VALUE(REALCOL,INTEGERCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , INTEGER will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT COALESCE(REALCOL,BIGINTCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , BIGINT will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT VALUE(REALCOL,BIGINTCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , BIGINT will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT COALESCE(REALCOL,DECIMALCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , DECIMAL(10,5) will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT VALUE(REALCOL,DECIMALCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , DECIMAL(10,5) will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT COALESCE(REALCOL,REALCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , REAL will have result data type of REAL
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{4.4}
	{4.44}
	{4.444}
SELECT VALUE(REALCOL,REALCOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , REAL will have result data type of REAL
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{4.4}
	{4.44}
	{4.444}
SELECT COALESCE(REALCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT VALUE(REALCOL,DOUBLECOL) from AllDataTypesTable
 Coalesc/Value with operands REAL , DOUBLE will have result data type of DOUBLE
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{4.400000095367432}
	{4.440000057220459}
	{4.443999767303467}
SELECT COALESCE(REALCOL,CHARCOL) from AllDataTypesTable
 Operands REAL , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'CHAR' is incompatible.
SELECT VALUE(REALCOL,CHARCOL) from AllDataTypesTable
 Operands REAL , CHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'CHAR' is incompatible.
SELECT COALESCE(REALCOL,VARCHARCOL) from AllDataTypesTable
 Operands REAL , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'VARCHAR' is incompatible.
SELECT VALUE(REALCOL,VARCHARCOL) from AllDataTypesTable
 Operands REAL , VARCHAR(60) are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'VARCHAR' is incompatible.
SELECT COALESCE(REALCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands REAL , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'LONG VARCHAR' is incompatible.
SELECT VALUE(REALCOL,LONGVARCHARCOL) from AllDataTypesTable
 Operands REAL , LONG VARCHAR are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'LONG VARCHAR' is incompatible.
SELECT COALESCE(REALCOL,CHARFORBITCOL) from AllDataTypesTable
 Operands REAL , CHAR(60) FOR BIT DATA are incompatible for Coalesce/Value function
expected exception The data type, length or value of arguments 'REAL' and 'CHAR () FOR BIT DATA' is incompatible.
SELECT VALUE(REALCOL,CHARFORBITCOL) from AllD