Support for constraints in jdbc adapter and optional decorrelation step in PlannerImpl.rel?

2021-07-04 Thread Arthur Pan
Greetings to dev@calcite: I am currently working on extracting RelNodes from DML queries with schemas derived from DDL statements, and I have encountered a few issues: 1. My current method to derive schemas from DDL statements is (a) connect to "jdbc:calcite" with parser factory set to Server

Re: Support for constraints in jdbc adapter and optional decorrelation step in PlannerImpl.rel?

2021-07-06 Thread Julian Hyde
Re 1. It seems that the Server parser goes further than the Server implementation. You can specify PRIMARY KEY in the DDL, and we can parse it, but Server cannot create tables with primary keys. Please log a bug. Contributions welcome. One workaround is for you to parse but not execute. The inf