[DERBY-3997] ORDER BY causes column to be returned

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.3.1, 10.2.2.0, 10.3.3.0, 10.4.1.3
• Fix Version/s: 10.3.3.1, 10.4.2.1, 10.5.1.1
• Component/s: SQL
• Environment: Mac OS 10.4, JDK 1,6
• Urgency: Normal
• Assignee: Knut Anders Hatlen
• Reporter: geoff hendrey
• Created: 24/Dec/08 06:08
• Updated: 21/Jan/11 17:52
• Resolved: 05/Jan/09 15:32

Description

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

Issue Links

• is depended upon by: DERBY-3926 Incorrect ORDER BY caused by index