[CALCITE-4725] Between clause operands checker should check all combi…

[paul8263]

…nations of the three operands

What is the purpose of the change

Fix the issue that between clause operands checker should check all combinations of the three operands, as what has been discuss in CALCITE-4725 in ASF Jira.

Brief change log

• core/src/main/java/org/apache/calcite/sql/type/SameOperandTypeChecker.java
• core/src/main/java/org/apache/calcite/sql/type/SameOperandTypeExceptLastOperandChecker.java

[NobiGo]

@paul8263 please add unit test in this patch.

[paul8263]

Hi @NobiGo , Thank you for your advice. Unit test has been added and several errors have been fixed.

[paul8263]

Hi @NobiGo , Could you please help review this issue?

[mihaibudiu]

I plan to review this PR. It looks like BETWEEN cannot currently compare TIMESTAMPS, for example