[jira] [Created] (PHOENIX-62) Precision loss for decimal type when creation of Immutable Index happens after the record insertion

[Maryann Xue (JIRA)]

Maryann Xue created PHOENIX-62:
----------------------------------

             Summary: Precision loss for decimal type when creation of 
Immutable Index happens after the record insertion
                 Key: PHOENIX-62
                 URL: https://issues.apache.org/jira/browse/PHOENIX-62
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 2.2.3
            Reporter: Maryann Xue


Sql script:

CREATE TABLE IF NOT EXISTS "Items"
("ItemID" VARCHAR(10) NOT NULL PRIMARY KEY,
 "ItemName" VARCHAR(50),
 "Price" DECIMAL)
IMMUTABLE_ROWS=true;

UPSERT INTO "Items" ("ItemID", "ItemName", "Price")
VALUES ('I001', 'BX016', 15.96);

CREATE INDEX IF NOT EXISTS "iItems" ON "Items"
("ItemName")
INCLUDE
("Price");

SELECT "ItemName", "Price" FROM "Items";

Output:

ItemName        Price 
---------- ---------- 
BX016              15 

But if we put "CREATE INDEX ..." in front of "UPSERT INTO ...", the result 
comes out right as:

ItemName        Price 
---------- ---------- 
BX016              15.96 




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)