db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3997) ORDER BY causes column to be returned
Date Tue, 30 Dec 2008 00:27:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12659709#action_12659709
] 

Bryan Pendleton commented on DERBY-3997:
----------------------------------------

Thanks Knut for having a go at this. Your analysis sounds quite good to me.

One interesting variant will be when the select list contains *, as I think there are
some complexities about whether you can remove the ORDER BY column in
this case, since it should end up in the result after all.

So it might be worth ensuring that you try a few test cases including select * queries
when testing the patch.


> 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.4.1.3
>         Environment: Mac OS 10.4, JDK 1,6
>            Reporter: geoff hendrey
>            Assignee: Knut Anders Hatlen
>
> 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.


Mime
View raw message