db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1452) jdbcapi/resultset.java fails with 10.1 client and 10.2 server
Date Mon, 26 Jun 2006 12:00:30 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1452?page=comments#action_12417794 ] 

Kathey Marsden commented on DERBY-1452:
---------------------------------------

Actually, there are other type  comparisons  failing too besides LONGVARCHAR FOR BIT DATA.
This needs a closer look to see if there are regressions or if the change was intentional
and release note is needed.


> jdbcapi/resultset.java fails with 10.1 client and 10.2 server
> -------------------------------------------------------------
>
>          Key: DERBY-1452
>          URL: http://issues.apache.org/jira/browse/DERBY-1452
>      Project: Derby
>         Type: Test

>     Versions: 10.2.0.0, 10.1.3.0
>  Environment: derbyclient.jar and derbyTesting.jar from 10.1
> all other jars from 10.2
>     Reporter: Deepa Remesh

>
> Diff is:
> *** Start: resultset jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-06-23 02:07:01
***
> 1467,1468d1466
> < 	 COL1(datatype : CHAR, precision : 60, scale : 0)
> < 	 ------------------------------------------------
> 1471,1472d1468
> < 	 COL1(datatype : CHAR, precision : 60, scale : 0)
> < 	 ------------------------------------------------
> 1475,1476d1470
> < 	 COL1(datatype : CHAR, precision : 60, scale : 0)
> < 	 ------------------------------------------------
> 1517,1518d1510
> < 	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
> < 	 ---------------------------------------------------
> 1521,1522d1512
> < 	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
> < 	 ---------------------------------------------------
> 1525,1526d1514
> < 	 COL1(datatype : VARCHAR, precision : 60, scale : 0)
> < 	 ---------------------------------------------------
> 1732a1721,1734
> > Data Conversion SQLException
> > SELECT NULLIF(DATECOL,VARCHARCOL) from AllDataTypesTable
> > 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
> 1735,1752d1736
> < 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)
> < 	 ------------------------------------------------
> 1775a1760,1775
> > Data Conversion SQLException
> > SELECT NULLIF(TIMECOL,VARCHARCOL) from AllDataTypesTable
> > Data Conversion SQLException
> > SELECT NULLIF(TIMECOL,LONGVARCHARCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIME' and 'LONG VARCHAR' are not supported.
> > SELECT NULLIF(TIMECOL,CHARFORBITCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIME' and 'CHAR () FOR BIT DATA' are not supported.
> > SELECT NULLIF(TIMECOL,VARCHARFORBITCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIME' and 'VARCHAR () FOR BIT DATA' are not supported.
> > SELECT NULLIF(TIMECOL,LVARCHARFORBITCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIME' and 'LONG VARCHAR FOR BIT DATA' are not
supported.
> > SELECT NULLIF(TIMECOL,CLOBCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIME' and 'CLOB' are not supported.
> > SELECT NULLIF(TIMECOL,DATECOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIME' and 'DATE' are not supported.
> > SELECT NULLIF(TIMECOL,TIMECOL) from AllDataTypesTable
> 1778 del
> < Data Conversion SQLException
> 1779,1797d1777
> < SELECT NULLIF(TIMECOL,VARCHARCOL) from AllDataTypesTable
> < 	 COL1(datatype : TIME, precision : 8, scale : 0)
> < 	 -----------------------------------------------
> < Data Conversion SQLException
> < SELECT NULLIF(TIMECOL,LONGVARCHARCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIME' and 'LONG VARCHAR' are not supported.
> < SELECT NULLIF(TIMECOL,CHARFORBITCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIME' and 'CHAR () FOR BIT DATA' are not supported.
> < SELECT NULLIF(TIMECOL,VARCHARFORBITCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIME' and 'VARCHAR () FOR BIT DATA' are not supported.
> < SELECT NULLIF(TIMECOL,LVARCHARFORBITCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIME' and 'LONG VARCHAR FOR BIT DATA' are not
supported.
> < SELECT NULLIF(TIMECOL,CLOBCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIME' and 'CLOB' are not supported.
> < SELECT NULLIF(TIMECOL,DATECOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIME' and 'DATE' are not supported.
> < SELECT NULLIF(TIMECOL,TIMECOL) from AllDataTypesTable
> < 	 COL1(datatype : TIME, precision : 8, scale : 0)
> < 	 -----------------------------------------------
> 1818a1799,1816
> > Data Conversion SQLException
> > SELECT NULLIF(TIMESTAMPCOL,VARCHARCOL) from AllDataTypesTable
> > Data Conversion SQLException
> > SELECT NULLIF(TIMESTAMPCOL,LONGVARCHARCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'LONG VARCHAR' are not supported.
> > SELECT NULLIF(TIMESTAMPCOL,CHARFORBITCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'CHAR () FOR BIT DATA' are not
supported.
> > SELECT NULLIF(TIMESTAMPCOL,VARCHARFORBITCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'VARCHAR () FOR BIT DATA' are not
supported.
> > SELECT NULLIF(TIMESTAMPCOL,LVARCHARFORBITCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'LONG VARCHAR FOR BIT DATA' are
not supported.
> > SELECT NULLIF(TIMESTAMPCOL,CLOBCOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'CLOB' are not supported.
> > SELECT NULLIF(TIMESTAMPCOL,DATECOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'DATE' are not supported.
> > SELECT NULLIF(TIMESTAMPCOL,TIMECOL) from AllDataTypesTable
> > ERROR 42818: Comparisons between 'TIMESTAMP' and 'TIME' are not supported.
> > SELECT NULLIF(TIMESTAMPCOL,TIMESTAMPCOL) from AllDataTypesTable
> 1821 del
> < Data Conversion SQLException
> 1822 del
> < SELECT NULLIF(TIMESTAMPCOL,VARCHARCOL) from AllDataTypesTable
> 1823 del
> < 	 COL1(datatype : TIMESTAMP, precision : 26, scale : 6)
> 1824,1842d1818
> < 	 -----------------------------------------------------
> < Data Conversion SQLException
> < SELECT NULLIF(TIMESTAMPCOL,LONGVARCHARCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'LONG VARCHAR' are not supported.
> < SELECT NULLIF(TIMESTAMPCOL,CHARFORBITCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'CHAR () FOR BIT DATA' are not
supported.
> < SELECT NULLIF(TIMESTAMPCOL,VARCHARFORBITCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'VARCHAR () FOR BIT DATA' are not
supported.
> < SELECT NULLIF(TIMESTAMPCOL,LVARCHARFORBITCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'LONG VARCHAR FOR BIT DATA' are
not supported.
> < SELECT NULLIF(TIMESTAMPCOL,CLOBCOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'CLOB' are not supported.
> < SELECT NULLIF(TIMESTAMPCOL,DATECOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'DATE' are not supported.
> < SELECT NULLIF(TIMESTAMPCOL,TIMECOL) from AllDataTypesTable
> < ERROR 42818: Comparisons between 'TIMESTAMP' and 'TIME' are not supported.
> < SELECT NULLIF(TIMESTAMPCOL,TIMESTAMPCOL) from AllDataTypesTable
> < 	 COL1(datatype : TIMESTAMP, precision : 26, scale : 6)
> < 	 -----------------------------------------------------
> Test Failed.
> *** End:   resultset jdk1.5.0_02 DerbyNetClient derbynetmats:jdbcapi 2006-06-23 02:07:19
***

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message