[ https://issues.apache.org/jira/browse/HAWQ-1526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Oleksandr Diachenko resolved HAWQ-1526. --------------------------------------- Resolution: Fixed > 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)