Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-1672

schema name alias doesn't work in INSERT INTO

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: jdbc-adapter
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                davy-wei Lei Wei
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: