[
https://issues.apache.org/jira/browse/HAWQ-1526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Diachenko reassigned HAWQ-1526:
-----------------------------------------
Assignee: Oleksandr Diachenko (was: Ed Espino)
> Queries with functions in WHERE clause return empty result for external PXF
> tables
> ----------------------------------------------------------------------------------
>
> Key: HAWQ-1526
> URL: https://issues.apache.org/jira/browse/HAWQ-1526
> Project: Apache HAWQ
> Issue Type: Bug
> Components: PXF
> Reporter: Oleksandr Diachenko
> Assignee: Oleksandr Diachenko
> Fix For: 2.3.0.0-incubating
>
>
> Two same queries with the same WHERE clauses(having function call) return a
> different result based on a column in SELECT clause:
> {code}
> template1=# select transaction_id from ext_purchase_data WHERE
> to_timestamp(order_time)::DATE = '2017-09-10'::DATE and project = 'Dating'
> and project_subtype in ('DACH','NG');
> transaction_id
> ----------------
> (0 rows)
> template1=# select * from ext_purchase_data WHERE
> to_timestamp(order_time)::DATE = '2017-09-10'::DATE and project = 'Dating'
> and project_subtype in ('DACH','NG');
> meta_extracted_at_time | meta_utc_time_offset | meta_transaction_action |
> meta_source_system | project | project_subtype | transaction_id | user_id |
> amount | currency_code | reference_transaction_id | product_type |
> transaction_type | order_time | vat | legal_entity | sale_action_id |
> content_id | content_name | content_quantity
> ------------------------+----------------------+-------------------------+--------------------+---------+-----------------+----------------+---------+--------+---------------+--------------------------+--------------+------------------+------------+------+--------------+----------------+------------+--------------+------------------
> 1505056530 | +1 | +1 |
> fancy system | Dating | NG | 12345 | acedres |
> 20.5 | EUR | 123456789 | DATA | Online
> | 1505056530 | 21.4 | BBVA | 1234 | 10 | Diez
> | 100
> (1 row)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
