Derby 10.3.X sorts VARCHAR column incorrectly when table is indexed and VARCHAR
column contains a value of '00000'
------------------------------------------------------------------------------------------------------------------
Key: DERBY-3279
URL: https://issues.apache.org/jira/browse/DERBY-3279
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.3.2.1, 10.3.1.4
Environment: Rational Application Developer 7.0.0.2 (Eclipse 3.2.2),
J2RE 1.5.0 IBM J9 2.3 Windows XP
Reporter: Ajay Bhala
Running the following produces the error seen in Derby 10.3.X but not in 10.2.X
nor in 10.1.X.
Don't know if this related to DERBY-3231.
First query is incorrectly sorted whereas the second one is okay.
------
create table CHEESE (
CHEESE_CODE VARCHAR(5),
CHEESE_NAME VARCHAR(20),
CHEESE_COST DECIMAL(7,4)
);
create index cheese_index on CHEESE (CHEESE_CODE DESC, CHEESE_NAME DESC,
CHEESE_COST DESC);
INSERT INTO CHEESE (
CHEESE_CODE,
CHEESE_NAME,
CHEESE_COST)
VALUES ('00000', 'GOUDA', 001.1234),
('00000', 'EDAM', 002.1111),
('54321', 'EDAM', 008.5646),
('12345', 'GORGONZOLA', 888.2309),
('AAAAA', 'EDAM', 999.8888),
('54321', 'MUENSTER', 077.9545);
SELECT * FROM CHEESE
WHERE (CHEESE_CODE='00000' OR CHEESE_CODE='54321') AND CHEESE_NAME='EDAM'
ORDER BY CHEESE_CODE DESC, CHEESE_NAME DESC, CHEESE_COST DESC;
SELECT * FROM CHEESE
WHERE (CHEESE_CODE='AAAAA' OR CHEESE_CODE='54321') AND CHEESE_NAME='EDAM'
ORDER BY CHEESE_CODE DESC, CHEESE_NAME DESC, CHEESE_COST DESC;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
