[
https://issues.apache.org/jira/browse/CARBONDATA-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chetan Bhat reassigned CARBONDATA-2886:
---------------------------------------
Assignee: Manish Gupta
> 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
> Assignee: Manish Gupta
> Priority: Minor
>
> 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)
