[jira] [Created] (CALCITE-5894) Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key

2023-08-03 Thread JingDas (Jira)
JingDas created CALCITE-5894: Summary: Add SortRemoveRedundantRule to remove redundant sort fields if sort fields contains unique key Key: CALCITE-5894 URL: https://issues.apache.org/jira/browse/CALCITE-5894

Re: AggregateProjectPullUpConstantsRule not working with the Volcano Planner

2023-08-03 Thread Nick Riasanovsky
Thank you for your response. There was an issue with my configuration that I was able to resolve. On Thu, Aug 3, 2023 at 4:33 PM Julian Hyde wrote: > The constraints on a RelSubset should be the union of the constraints of > all of the RelNodes in that subset. (I haven’t tested it, or read the

DECIMAL(2, 3) meaning

2023-08-03 Thread mbudiu
Hello, I notice that Calcite happily accepts decimal type specifications where the scale is greater than the precision. There are quite a few tests with such types. What is the meaning of such types? The SQL 92 standard has this statement on page 109: 15)The of an shall not be

Re: AggregateProjectPullUpConstantsRule not working with the Volcano Planner

2023-08-03 Thread Julian Hyde
The constraints on a RelSubset should be the union of the constraints of all of the RelNodes in that subset. (I haven’t tested it, or read the code. But if it doesn’t do that, you’re probably seeing a bug, or you haven’r configured your metadata providers correctly.) > On Aug 3, 2023, at 9:33

AggregateProjectPullUpConstantsRule not working with the Volcano Planner

2023-08-03 Thread Nick Riasanovsky
Hello everyone, I am attempting to use AggregateProjectPullUpConstantsRule within an optimizer that is using the VolcanoPlanner. When doing so I encounter issues with what should be valid constants on the line `mq.getPulledUpPredicates()` because aggregate.getInput() is a RelSubset. As a result,

Re: Easier and more comprehensive testing

2023-08-03 Thread Stamatis Zampetakis
Hey Mihai, Indeed the .iq files are mostly end-to-end tests in Calcite. The Quidem [1] framework is used for running these tests. The Quidem approach is pretty neat cause we don't have to carry Java boilerplate code and formatting around which makes the tests much easier to read, write, inspect

Re: [Question] CAST possibility cases

2023-08-03 Thread stanilovsky evgeny
Thanks a lot for response. Ok i found partial CAST tests like : SqlOperatorTest#testCastBooleanToNumeric, SqlOperatorTest#testCastToString and so on. Soon i will try to fix all observed CAST discrepancy according to: ISO/IEC 9075-2:1999 6.22 standard Hi,stanilovsky, CALCITE-5662