db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1452) jdbcapi/resultset.java fails with 10.1 client and 10.2 server
Date Sat, 24 Jun 2006 00:11:32 GMT
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