[CALCITE-1672] schema name alias doesn't work in INSERT INTO

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: jdbc-adapter
• Assignee: Unassigned
• Reporter: Lei Wei
• Created: 07/Mar/17 17:34
• Updated: 22/Feb/19 01:21

Description

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

Issue Links

• is duplicated by: CALCITE-1692 JDBC UPDATE does not use correct schema name