[CARBONDATA-1725] Wrong data displayed for <= filter for timestamp column(dictionary column)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Assignee: dhatchayani
• Reporter: dhatchayani
• Created: 15/Nov/17 12:44
• Updated: 15/Nov/17 12:53
• Resolved: 15/Nov/17 12:53

Description

Issue:
<= filter is giving wrong results for timestamp dictioinary column

Steps to reproduce:
(1) Create a table with a timestamp dictionary column
create table t1(dob timestamp) stored by 'carbondata' TBLPROPERTIES ('DICTIONARY_INCLUDE'='dob')
(2) Load data
1970-01-01 05:30:00 (same value as 300 records)
(3) Apply filter on table
select count from t1 where dob=cast('1970-01-01 05:30:00' as timestamp);
--------

count(1)

--------

300

--------
select count from t1 where dob<=cast('1970-01-01 05:30:00' as timestamp);
--------

count(1)

--------

1

--------

Both the queries should give us the same results.

Solution:
In less than equal to filter, we are considering surrogate 2 as default value. But surrogate 1 is for default value.