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