You are correct. There is a JIRA case to add support for implicit casts, https://issues.apache.org/jira/browse/CALCITE-2302 <https://issues.apache.org/jira/browse/CALCITE-2302>.
Julian > On Feb 25, 2019, at 10:12 PM, 宋之白(之白) <zhibai....@alibaba-inc.com> wrote: > > > Hi > for current calcite master repo does not support implicit type cast in > validation, for example > insert into emp values (1, 'nom', 'job', 0, timestamp '1970-01-01 > 00:00:00', 1, 1, 1, false) > is OK for validator > > but > insert into emp values (1, 'nom', 'job', 0, '1970-01-01 00:00:00', 1, > 1, 1, false) > is not OK for validator >