[
https://issues.apache.org/jira/browse/CALCITE-1672?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15899838#comment-15899838
]
Julian Hyde commented on CALCITE-1672:
--------------------------------------
Well, what is the schema name in PostgreSQL? What SQL should Calcite be
generating?
> 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)
