Soumyadeep-github opened a new pull request, #5027: URL: https://github.com/apache/calcite/pull/5027
JIRA: [CALCITE-2901](https://issues.apache.org/jira/browse/CALCITE-2901) ## Changes Proposed - Scalar sub-queries now take the type of the one column inside the sub-query (copyType). We stopped forcing that type to always allow null after that. - The SQL checker and RECORD_TO_SCALAR use the same idea so types stay in sync end to end. - After sub-queries are turned into joins, some fields can be null from the join even when the checker said “not null”. The code adds casts in a few places so the plan matches what the checker expects (sub-query remove rule, sql-to-rel, one aggregate rule). - Tests were updated: core diff tests, decorrelator string plans, Quidem scalar / sub-query, validator/coercion/table-function checks, rel-to-SQL for one MySQL-style case, operator tests in testkit, and two TPC-H plan checks in plus. -- 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]
