Hi community,
I recently ran into a problem that when we disable type coercion by
SqlValidator#setEnableTypeCoercion(false),
there will be two different behaviors between '>' and '=':
1. '>' between character and numeric (e.g. '1' > 1), the character will be
implicitly converted to numeric
2. '=' between character and numeric (e.g. '1' = 1), the character will `not`
be implicitly converted to numeric
I find the reason is that the SqlOperandTypeChecker.Consistency for
SqlStdOperatorTable.GREATER_THAN is `COMPARE` while
SqlStdOperatorTable.EQUALS is `LEAST_RESTRICTIVE`.
Is this by design?