[DERBY-1633] Regression: The fields of views are not being calculated properly since 10.1.2.4

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.3.1
• Fix Version/s: 10.1.3.2, 10.2.1.6, 10.3.1.4
• Component/s: SQL
• Environment: 2.8 GHZ dual PIV on Windows XP SP2, 2 GB memory
• Urgency: Blocker
• Issue & fix info: Release Note Needed
• Bug behavior facts: Regression
• Assignee: A B
• Reporter: Prasenjit Sarkar
• Created: 02/Aug/06 18:47
• Updated: 30/Jun/09 16:12
• Resolved: 28/Aug/06 16:09

Description

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