lincoln lee created FLINK-29113: ----------------------------------- Summary: Join hint with invalid table name mixed with valid names will not raise an error Key: FLINK-29113 URL: https://issues.apache.org/jira/browse/FLINK-29113 Project: Flink Issue Type: Bug Reporter: lincoln lee Attachments: image-2022-08-26-15-26-33-305.png
add a BROADCAST hint to tpch q2 with a non exists table 'supp' works fine, while a single invalid table name 'supp' will raise an error ```sql explain SELECT /*+ BROADCAST(partsupp,supp) */ s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment FROM part, supplier, partsupp, nation, region WHERE p_partkey = ps_partkey AND s_suppkey = ps_suppkey AND p_size = 15 AND p_type LIKE '%BRASS' AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'EUROPE' AND ps_supplycost = ( SELECT min(ps_supplycost) FROM partsupp, supplier, nation, region WHERE p_partkey = ps_partkey AND s_suppkey = ps_suppkey AND s_nationkey = n_nationkey AND n_regionkey = r_regionkey AND r_name = 'EUROPE' ) ORDER BY s_acctbal DESC, n_name, s_name, p_partkey LIMIT 100 ``` !image-2022-08-26-15-26-33-305.png! -- This message was sent by Atlassian Jira (v8.20.10#820010)