[Bug] full outer join

[huyangg]

Search before asking

• I had searched in the issues and found no similar issues.

Version

PALO-0.14.13.1-release-binary

What's Wrong?

When I execute the following SQL, the error is as follows. I checked carefully that the field exists.

MySQL [(none)]> SELECT
-> if (b.brave_update_time > a.update_time, b.family_history_cancer_id, a.family_history_cancer_id)
->
-> FROM
-> ads_galileo_bu_limis_family_history_cancer_d a
-> full outer join ads_galileo_bu_limis_family_history_cancer_d b on
-> a.customer_id = b.customer_id
-> where a.customer_id = 1047963 ;
ERROR 1064 (HY000): errCode = 2, detailMessage = exec direct Error: 42S22 [MySQL][ODBC 8.0(w) Driver][mysqld-5.5.5-10.5.9-MariaDB-log]Unknown column 'customer_id' in 'field list' (1054)

What You Expected?

I expect the up SQL to be executed successfully. thanks.

How to Reproduce?

Create any table and execute SQL with full outer join.

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct