Hi all,
Since Calcite has been used as planners for many projects, each with its
own definition of flexibility, I am thinking if we could make
type-check-mechanism plugable?
For the first example, currently, the following filter will trigger
exception:
col - to_timestamp('XXXX-XX-XX XX:XX:XX','YYYY-MM-dd HH:mm:ss') <
interval 'X XX:XX:X' day to second
=> Cannot apply '-' to arguments of type '<ANY> - <TIMESTAMP(0)>
Another example is cast function, where less type conversion is allowed in
calcite than in Drill or MS-SQL.
Please let me know if this proposal makes sense.
