[ http://issues.apache.org/jira/browse/DERBY-1633?page=comments#action_12431073 ] A B commented on DERBY-1633: ----------------------------
Thanks for continuing to test this particular fix, Prasenjit. I assume the query in the above comment is supposed to be run agains the same database that's in DERBY-1205? When I try to run it I see: prepare qFail as ' SELECT HOST2FABRIC1.FABRIC_ID, HOST2FABRIC1.PREFIX_ID, HOST2FABRIC1.HOST_ID FROM T_VIEW_HOST2FABRIC HOST2FABRIC1, T_VIEW_HOST2FABRIC HOST2FABRIC2 WHERE HOST2FABRIC1.PREFIX_ID = HOST2FABRIC2.HOST_ID AND HOST2FABRIC1.HOST_ID = HOST2FABRIC2.HOST_ID AND HOST2FABRIC2.FABRIC_ID = ? '; ERROR 42X04: Column 'HOST2FABRIC1.PREFIX_ID' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVIN G clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'HOST2FABRIC1.PREFIX_ID' is not a column in the target table. I also see this error when running against 10.1.2. So I'm wondering if this is actually the query you intended to post? Could you double-check and post the exact query that's causing the failure? Thanks. > 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: SQL > Affects Versions: 10.1.3.0, 10.1.3.1 > Environment: 2.8 GHZ dual PIV on Windows XP SP2, 2 GB memory > Reporter: Prasenjit Sarkar > Assigned To: A B > Fix For: 10.2.1.0, 10.3.0.0, 10.1.3.2 > > Attachments: d1633_10_1_merge.patch, d1633_repro.sql, > d1633_v1_reviewOnly.patch, d1633_v2.patch, d1633_v3_code.patch, > d1633_v3_tests.patch, DERBY-1633_v1.html, DERBY-1633_v2.html, > DERBY-1633_v3.html > > > 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
