jasonliangyc created FLINK-32579:
------------------------------------
Summary: The filter criteria on the lookup table of Lookup join
has no effect
Key: FLINK-32579
URL: https://issues.apache.org/jira/browse/FLINK-32579
Project: Flink
Issue Type: Bug
Components: Table SQL / Client
Affects Versions: 1.17.1, 1.17.0
Reporter: jasonliangyc
Attachments: image-2023-07-12-09-31-18-261.png,
image-2023-07-12-09-42-59-231.png, image-2023-07-12-09-47-31-397.png
*1.* I joined two tables using the lookup join as below query in sql-client,
the filter criteria of (p.name = '??????') didn't shows up in the execution
detail and it returned the rows only base on one condiction (cdc.product_id =
p.id)
{code:java}
select
cdc.order_id,
cdc.order_date,
cdc.customer_name,
cdc.price,
p.name
FROM orders AS cdc
left JOIN products
FOR SYSTEM_TIME AS OF cdc.proc_time as p ON p.name = '??????' and
cdc.product_id = p.id
; {code}
!image-2023-07-12-09-31-18-261.png|width=657,height=132!
*2.* It showed the werid results when i changed the query as below, cause there
were no data in the table(products) that the value of column 'name' is '??????'
and and execution detail didn't show us the where criteria.
{code:java}
select
cdc.order_id,
cdc.order_date,
cdc.customer_name,
cdc.price,
p.name
FROM orders AS cdc
left JOIN products
FOR SYSTEM_TIME AS OF cdc.proc_time as p ON cdc.product_id = p.id
where p.name = '??????'
; {code}
!image-2023-07-12-09-42-59-231.png|width=684,height=102!
!image-2023-07-12-09-47-31-397.png|width=685,height=120!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
