[
https://issues.apache.org/jira/browse/DERBY-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12722744#action_12722744
]
Kathey Marsden commented on DERBY-3997:
---------------------------------------
I am backporting this patch to 10.2 and notice that it uses
ResultColumnList.removeOderByColumns which was added in DERBY-681. Just adding
the one method to the 10.2 ResultColumnList seems to make everything work ok
and orderByElimination passes, but I just thought I would mention it in case it
seems like a problem to anyone. I will run the full regression tests.
> ORDER BY causes column to be returned
> -------------------------------------
>
> Key: DERBY-3997
> URL: https://issues.apache.org/jira/browse/DERBY-3997
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.1.3
> Environment: Mac OS 10.4, JDK 1,6
> Reporter: geoff hendrey
> Assignee: Knut Anders Hatlen
> Fix For: 10.4.2.1, 10.5.1.1
>
> Attachments: d3997.diff, d3997.stat
>
>
> The ORDER BY is causing the ordered column to be retrieved even though it is
> not part of the SELECT clause. Here is a script to create a table, insert a
> row, and perform the select:
> CREATE TABLE "REVIEWS"."GEOFF__REVIEWS__REVIEW"
> (
> PK INTEGER PRIMARY KEY not null,
> numstars BIGINT,
> body VARCHAR(32672),
> title VARCHAR(32672),
> authoremail VARCHAR(32672)
> );
> INSERT INTO "REVIEWS"."GEOFF__REVIEWS__REVIEW"
> (PK,numstars,body,title,authoremail) VALUES (0 /*not
> nullable*/,0,'s','s','s');
> SELECT "review"."numstars"
> FROM
> "GEOFF__REVIEWS__REVIEW" AS "review"
> WHERE
> "review"."PK" = 1
> ORDER BY
> "review".PK
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
