Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
Currently if the two sides of a join condition are of different types then we implicitly add a cast on one side so that the join condition works as expected. However when we apply a cast to variable width type (varchar or varbinary) we don't include the length parameter as part of the arguments. This causes the function resolver to not match against any function implementation and return a NULL expression.