[PHOENIX-3996] DECIMAL TYPE DESC index compare wrong

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Invalid
• Affects Version/s: 4.8.1
• Labels: DESC
• Assignee: Viraj Jasani
• Reporter: steve, Oh
• Created: 06/Jul/17 07:39
• Updated: 26/Sep/19 05:27
• Resolved: 26/Sep/19 05:27

Description

I created decimal type descending index column. Some case compare result is odd.

1. table schema
   CREATE TABLE IF NOT EXISTS test_tbl2 (
   num DECIMAL NOT NULL
   CONSTRAINT pk PRIMARY KEY (num DESC)
   )
   ;

1. explain query
   explain
   select * from test_tbl2
   where
   num >= 1498755000000 and num <= 1498755999000;

1. explain result
   DEGENERATE SCAN OVER TEST_TBL2

Issue Links

• is related to: PHOENIX-4306 Add more tests for DESC sort order