[jira] Created: (DERBY-3997) ORDER BY causes column to be returned

[geoff hendrey (JIRA)]

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


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.