Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Cannot implement a JOIN whose ON clause contains a mixture of equi and theta conditions. The equivalent query expressed using WHERE can be implemented.
The solution is to make EnumerableJoinRule split the condition into equi and non-equi parts, provided that the join type is inner.
Attachments
Issue Links
- relates to
-
CALCITE-451 Implement theta join, inner and outer, in enumerable convention
- Closed