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)
