[CALCITE-6631] The common type for a comparison operator returns the wrong type when comparing a Java type long with a SQL type INTEGER

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.38.0
• Fix Version/s: 1.39.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: xiong duan
• Created: 6 days ago 01:08
• Updated: 5 days ago 20:10
• Resolved: 5 days ago 20:10

Description

The unit test:

RelDataType longJavaType = this.typeFactory.createJavaType(Long.class);
@Test void testComparisonJavaTypeAndSqlTypeCoercion() {
final Fixture f = fixture();
f.comparisonCommonType(f.intType, f.longJavaType, null);
}

The common type for a comparison operator when when comparing a Java type long with a SQL type INTEGER should return LONG type or NULL, now return the INTEGER type.

Issue Links

• is related to: CALCITE-6617 TypeCoercion is not applied correctly to comparisons
• is related to: CALCITE-119 Comparing Java type long with SQL type INTEGER gives wrong answer
• links to: GitHub Pull Request #4006