Hi Abbas, I don't understand what you mean. Can you use an SQL statement to express what kind of output you want and What the Calcite's output is? Then we will discuss the details.
Abbas Gadhia <[email protected]> 于2024年10月23日周三 19:12写道： > > 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?
