d datetime subtraction can not work well with JDBC
adapter
I think you have identified the issues correctly.
I prefer SqlDatetimeSubtractionOperator to SqlTimestampDiffFunction because it
is standard and more powerful. But some work is needed to make SQL generation
run smoothly. Especially with data typ
I think you have identified the issues correctly.
I prefer SqlDatetimeSubtractionOperator to SqlTimestampDiffFunction because it
is standard and more powerful. But some work is needed to make SQL generation
run smoothly. Especially with data types, as you point out.
I would approach this by wr
Dear All,
As for issue https://issues.apache.org/jira/browse/CALCITE-3312(I'm working on
this issue), I have noticed several problems. So I am writing this mail for
some advices.
1.Calcite support the syntax like that "(datetime - datetime)
IntervalQualifier";
A simple test in JdbcTest:
@Te