[
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)
