[jira] [Created] (CARBONDATA-2886) select filter with int datatype is showing incorrect result in case of table created and loaded on old version and queried in new version

["Surbhi Joshi (JIRA)" <ji...@apache.org>]

Surbhi Joshi created CARBONDATA-2886:
----------------------------------------

             Summary: select filter with int datatype is showing incorrect result in case of table created and loaded on old version and queried in new version
                 Key: CARBONDATA-2886
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2886
             Project: CarbonData
          Issue Type: Bug
          Components: core
            Reporter: Surbhi Joshi


select filter with int datatype is showing incorrect result in case of table created and loaded on old version and queried in new version
 
Steps:
created table and loaded data in base carbon version 1.1
refresh table in 1.4.1
select filter query for integer column with valid existing value
 
 
 
expected result: the filtered row must be shown
actual result: filtered row is not shown
 
Note:
1.  this happens for a particular table in the store
2. If filter has integer column with any other column then it displays the result

select cust_id,cust_name from uniqdata_load where cust_name= 'CUST_NAME_00075' or cust_id=9010;
+----------+------------------+--+
| cust_id | cust_name |
+----------+------------------+--+
| 9010 | CUST_NAME_00010 |
| 9075 | CUST_NAME_00075 |
+----------+------------------+--+
2 rows selected (0.652 seconds)
 select cust_id,cust_name from uniqdata_load where cust_id=9010;
+----------+------------+--+
| cust_id | cust_name |
+----------+------------+--+
+----------+------------+--+
No rows selected (0.351 seconds)


 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)