Hi, My Name is Wangminhao Gou,I hava used calcite to operate several relational databases including PG,however,when I want to insert timestamp value,there is an exception.The information is like this: org.apache.calcite.runtime.CalciteContextException: From line 1, column 47 to line 1, column 60: Cannot assign to target field 'plt_createtime' of type TIMESTAMP(3) from source field 'EXPR$1' of type CHAR(23) Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'plt_createtime' of type TIMESTAMP(3) from source field 'EXPR$1' of type CHAR(23) however when I used the same SQL statement in the navicat towards the PG,it succeeds. What should I do then?Thank you.
Sincerely, Wangminhao Gou
