db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "geoff hendrey (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3997) ORDER BY causes column to be returned
Date Wed, 24 Dec 2008 06:08:44 GMT
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.


Mime
View raw message