db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasenjit Sarkar (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4
Date Wed, 02 Aug 2006 18:48:14 GMT
Regression: The fields of views are not being calculated properly since 10.1.2.4
--------------------------------------------------------------------------------

                 Key: DERBY-1633
                 URL: http://issues.apache.org/jira/browse/DERBY-1633
             Project: Derby
          Issue Type: Bug
          Components: Regression Test Failure
    Affects Versions: 10.1.3.1, 10.1.3.0
         Environment: 2.8 GHZ dual PIV on Windows XP SP2, 2 GB memory
            Reporter: Prasenjit Sarkar


Database can be assumed to be same as in Derby - 1205 Jira issue

SELECT PORT1.PORT_ID FROM T_RES_PORT PORT1, T_VIEW_ENTITY2PORT ENTITY2PORT WHERE ENTITY2PORT.PORT_ID
= PORT1.PORT_ID

This works fine in 10.1.2.1 but fails thereafter complaining that Comparison between INTEGER
and CHAR is not supported

for some reason, it thinks one of the PORT_ID columns is a character, when in reality both
are integers.

		SELECT DISTINCT 
		    ZONE.ZONE_ID ZONE_ID, 
			 PORT2ZONE.ZONE_MEMBER_ID  
		FROM  
			 T_RES_ZONE ZONE left outer join T_VIEW_PORT2ZONE PORT2ZONE on  
			 ZONE.ZONE_ID = PORT2ZONE.ZONE_ID   ,  T_RES_FABRIC FABRIC 

In this query, it is complaining that one of the columns is a VARCHAR and cannot be compared
to INTEGER, when clearly this is not the case...

Same issue

-- 
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