Abacn commented on PR #35588:
URL: https://github.com/apache/beam/pull/35588#issuecomment-3074323401
BeamSqlDslExistsTest failed due to query had been parsed differently.
Previously, not exists parsed to
```
LogicalProject(c_custkey=[$0], c_acctbal=[$1], c_city=[$2])
LogicalFilter(condition=[IS NULL($4)])
LogicalJoin(condition=[=($0, $3)], joinType=[left])
```
and invokes logical join. Now it becomes
```
LogicalProject(c_custkey=[$0], c_acctbal=[$1], c_city=[$2])
LogicalFilter(condition=[NOT(EXISTS({
LogicalFilter(condition=[=($1, $cor0.c_custkey)])
BeamIOSourceRel(table=[[beam, ORDERS]])
}))], variablesSet=[[$cor0]])
BeamIOSourceRel(table=[[beam, CUSTOMER]])
```
condition becomes `[NOT(EXISTS({` and appears not implemented by Beam SQL
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
