[jira] [Created] (TRAFODION-2591) Creating INDEX on ADDED column gives corrupted results

["Eric Owhadi (JIRA)" <ji...@apache.org>]

Eric Owhadi created TRAFODION-2591:
--------------------------------------

             Summary: Creating INDEX on ADDED column gives corrupted results
                 Key: TRAFODION-2591
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2591
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
    Affects Versions: 2.2-incubating
            Reporter: Eric Owhadi



CREATE TABLE "car" (
":car_id" CHAR(27) CHARACTER SET ISO88591 NOT NULL PRIMARY KEY,
"a" CHAR(27) CHARACTER SET ISO88591 NOT NULL,
"b" DATE,
"c" VARCHAR(30),
"d" DATE,
"e" VARCHAR (30),
"f" CHAR(1) NOT NULL,
":brand" CHAR(1) CHARACTER SET ISO88591,
":horsePower" INT,
":featuresFlag" INT
);

UPSERT INTO TABLE "car" VALUES
('sdcABddOdsSk5DzWZxQFO2BkDLc','bbHABhqOdsSk5DwdEsQFO2BkDss',CURRENT_DATE,'me',CURRENT_DATE,'me', 'A','a',122,7),
('wwsvchqOhmksh564ZxsdOSasdcx','bbHABhqOdsSk5DwdEsQFO2BkDss',CURRENT_DATE,'me',CURRENT_DATE,'me', 'A','b',121,3),
('fcxdBhDlsdFc5DzWZaSFO2Bjh67','bbHABhqOdsSk5DwdEsQFO2BkDss',CURRENT_DATE,'me',CURRENT_DATE,'me', 'A','c',133,2),
('ldsxRdqkKkSk5DzWZxQFOsd7shF','bbHABhqOdsSk5DwdEsQFO2BkDss',CURRENT_DATE,'me',CURRENT_DATE,'me', 'A','d',201,1);

select ":car_id" from "car";
--data good

ALTER TABLE "car" ADD COLUMN "fk_owns_person" CHAR(27) CHARACTER SET ISO88591; 

select ":car_id" from "car";
-- data good

CREATE INDEX "car_idx_fk_owns_person" ON "car" ("fk_owns_person");

select ":car_id" from "car";
-- corrupted data



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)