Hello, Jian Chen In Ignite date values can also be inserted by KV API, so year stored in the database can be outside of valid SQL standard range (0001-9999). If such values will be prohibited inside the "toInternal" method, there can be unexpected exceptions on select from the database. Some pure SQL databases (for example, PostgreSQL) do not have such limitation, perhaps we also can live without it, especially when "invalid" values can be inserted via KV API.
вт, 21 февр. 2023 г. в 07:48, Jian Chen <chenjian2...@gmail.com>: > Hi Igniters, > > I want to fix https://issues.apache.org/jira/browse/IGNITE-7360 . > Currently, I plan to added a date validation function in class > "org.apache.ignite.internal.processors.query.calcite.util.TypeUtils" to > validate the value of date that comes from the methods: > > - toInternal > - fromInternal > - fromLiteral > > Any suggestions? > > > Stephen >