Hi,

regarding Jira Issue: https://issues.apache.org/jira/browse/DERBY-3997

The fix version is listed as 10.4.2.1. I downloaded 10.4.2.1 from Sun in order to test the fix. Here is where I downloaded 10.4.2.1 from:  https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_SMI-Site/en_US/-/USD/ViewFilteredProducts-SingleVariationTypeFilter

The issue does not seem to be fixed. For example, here is a printout of a prepared statement:

SELECT
"r"."PK" AS "r.PK"
FROM
    "GEOFF__REVIEWS__REVIEW" AS "r",
    "GEOFF__REVIEWS__REVIEWABLE" AS "v"
WHERE
    "v".PK = "r".FK_REVIEWABLE_REVIEWS AND ( "v"."PK" = ? AND "r"."title" = ? 
  AND "r"."authorname" = ? )  AND  "v".PK >  ?
ORDER BY
    "v".PK 


And here is a result set. Notice that the "PK" column still appears in the select clause. As I mentioned, this is a serious production issue for us causing problems throughout our system, and customer issues.

+----+--
|r.PK|PK
+----+--
| 55| 17
+----+--

Any suggestions?
 
-geoff
How many legs does a dog have if you call the tail a leg? Four. Calling a tail a leg doesn't make it a leg.
– A. Lincoln