Description
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)
Attachments
Issue Links
- links to