Josef Spillner created CALCITE-5791:
---------------------------------------
Summary: DDL commands ceased to work in 1.23-1.24 transition
Key: CALCITE-5791
URL: https://issues.apache.org/jira/browse/CALCITE-5791
Project: Calcite
Issue Type: Bug
Components: server
Affects Versions: 1.34.0, 1.33.0, 1.32.0, 1.31.0, 1.30.0, 1.29.0, 1.28.0,
1.27.0, 1.26.0, 1.25.0, 1.24.0
Environment: OpenJDK 17 on Linux
Reporter: Josef Spillner
Fix For: 1.23.0
Attachments: testcase-ddl.zip
I'm interested in a self-contained prototype for UDF extensions, and looked at
calcite-server for that purpose. The code snippet on
[https://calcite.apache.org/docs/adapter.html] looked promising but does not
run for me in the latest Git version despite adding the calcite-server JAR file
to sqlline:
_{color:#000000}Error: Error while executing SQL {color}{color:#ff54ff}"CREATE
TABLE testtable (counter int, content varchar(256))"{color}{color:#000000}:
Property
{color}{color:#ff54ff}'org.apache.calcite.sql.parser.ddl.SqlDdlParserImpl#FACTORY'{color}{color:#000000}
not{color}_
_valid as
{color:#ff54ff}'org.apache.calcite.sql.parser.ddl.SqlDdlParserImpl#FACTORY'{color}{color:#000000}
not found in the classpath (state=,code=0){color}_
Inspired by ServerTest.java I played with the JDBC API myself and found that
DDL works fine up to Calcite 1.23 but something must have broken it in more
recent versions. The attached testcase makes this reproducible by changing the
two JAR versions in pom.xml from 1.23 to e.g. 1.34, and rm -rf target. The
error message with more recent versions is:
_{color:#000000}Exception in thread "main" java.sql.SQLException: Error while
executing SQL "create table t (i int not null)": DDL not supported: CREATE
TABLE `T` (`I` INTEGER NOT NULL){color}_
(I also tried reproducing with sqlline from older Calcite releases from Git but
they don't build anymore due to dependency errors. I guess the programmatic
test case is good enough to demonstrate the issue.)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
