Re: [Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-08 Thread tonytao
method *visitRoot* work well.Ichange my code to :         RelToSqlConverter converter = new RelToSqlConverter(PostgresqlSqlDialect.DEFAULT);         SqlSelect select = converter.visitRoot(project1).asSelect(); fixed the problem. Thank you again! On 12/8/20 4:09 PM, tonytao wrote: Tkansks,I

Re: [Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-08 Thread tonytao
Tkansks,I created a jira:https://issues.apache.org/jira/browse/CALCITE-4430 On 12/8/20 2:50 PM, Chunwei Lei wrote: Hi, Tao. Thank you for your report. It would be great if you can file an JIRA and provide a test case that can reproduce the error. Best, Chunwei On Tue, Dec 8, 2020 at 2:33 PM

Re: [Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-07 Thread Chunwei Lei
Hi, Tao. Thank you for your report. It would be great if you can file an JIRA and provide a test case that can reproduce the error. Best, Chunwei On Tue, Dec 8, 2020 at 2:33 PM tonytao wrote: > Hi folks, > > I found a RelToSqlConverter bug existed in 1.24-1.26. > > I has a logical plan as

[Bug Report]RelToSqlConverter stack error in 1.24-1.26

2020-12-07 Thread tonytao
Hi folks, I found a RelToSqlConverter bug existed in 1.24-1.26. I has a logical plan as below:   LogicalProject(id=[$0], CAST=[CAST($1):DATE])     LogicalFilter(condition=[AND(<($1, 2011-12-01 00:00:00), >($0, 100))])   JdbcTableScan(table=[[public, testdata]]) when concert