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

["Anoop Sharma (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anoop Sharma reassigned TRAFODION-2591:
---------------------------------------

    Assignee: Anoop Sharma

> 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
>            Assignee: Anoop Sharma
>
> 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)