Lei Wei created CALCITE-1672:
--------------------------------
Summary: schema name alias doesn't work in INSERT INTO
Key: CALCITE-1672
URL: https://issues.apache.org/jira/browse/CALCITE-1672
Project: Calcite
Issue Type: Bug
Reporter: Lei Wei
Assignee: Julian Hyde
Priority: Minor
Hi, I setup calcite connecting with posgresql db, and starting avatica to take
jdbc connectivities. I used alias on the schemas that added to the root schema.
I'm able to run select statements using alias schema, but it doesn't work in
INSERT and UPDATE.
Exception: ExampleExceptionFormatter: exception message was: Error -1 (00000) :
Error while executing SQL "update LEI_DEMO_SANDBOX2.test_table set
no='1111111'": Remote driver error: RuntimeException: while executing SQL
[UPDATE "LEI_DEMO_SANDBOX2"."test_table" SET "no" = '1111111'] ->
PSQLException: ERROR: schema "LEI_DEMO_SANDBOX2" does not exist
ExampleExceptionFormatter: exception message was: Error -1 (00000) : Error
while executing SQL "insert into LEI_DEMO_SANDBOX2.test_table(no) values
('1111111')": Remote driver error: RuntimeException: while executing SQL
[INSERT INTO "LEI_DEMO_SANDBOX2"."test_table" ("no")
VALUES ('1111111')] -> PSQLException: ERROR: schema "LEI_DEMO_SANDBOX2" does
not exist
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
