You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Oleksandr Diachenko (JIRA)" <ji...@apache.org> on 2017/09/22 23:08:00 UTC
[jira] [Resolved] (HAWQ-1526) Queries with functions in WHERE
clause return empty result for external PXF tables
[ 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)