Hello, I noticed that in an update statement, when you assign a INT to a BIGINT (set clause), a cast is not needed.
However, if you do a INT = BIGINT in a where clause, a cast is applied from INT to BIGINT. In the first case, TypeCoercion is responsible for deciding if a cast is needed. In the second case, the operandTypeChecker of the EQUALS operator decides the need of the cast (in SqlToRelConverter) Question:Shouldn't the assignment operator used in the update statement be consulted if a cast is needed rather than this being done in the TypeCoercion class?
