yanjing.wang created CALCITE-5024:
-------------------------------------
Summary: Big INTERVAL_HOUR precision can't be converted to row
expression
Key: CALCITE-5024
URL: https://issues.apache.org/jira/browse/CALCITE-5024
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.29.0
Environment: jdk8
Reporter: yanjing.wang
Assignee: yanjing.wang
{code:java}
@Test void testBigIntervalHourPrecision() {
String expr = "interval '1000000' hour";
expr(expr).withFactory(t -> t.withTypeFactoryFactory(
f -> new JavaTypeFactoryImpl() {
@Override
public RelDataTypeSystem getTypeSystem() {
return new RelDataTypeSystemImpl() {
@Override
public int getDefaultPrecision(SqlTypeName typeName) {
switch (typeName) {
case INTERVAL_HOUR:
return SqlTypeName.MAX_INTERVAL_START_PRECISION;
default:
break;
}
return super.getDefaultPrecision(typeName);
}
};
}
}
)).ok();
} {code}
This will cause SqlValidatorException: Interval field value 1,000,000 exceeds
precision of HOUR(2) field.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
