Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9070

Access to MariaDB table from Oracle returns ORA-02085: database link <name> connects to HO.WORLD

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0.20
    • Component/s: OTHER
    • Labels:
      None
    • Environment:
      Server version: 10.0.20-MariaDB-log MariaDB Server
      Red Hat Linux
      Connecting from Oracle Enterprise Edition 11.2.0.4 with "global_names=true" set.

      Description

      See the following. This is using Oracle Gateway to ODBC to access MariaDB.

      SQL> create public database link ZLX70604.DB.ATT.COM connect to "dblink" identified by "<password>" using 'ZLX70604.DB.ATT.COM';

      Database link created.

       
      SQL> select * from "test1"@ZLX70604.DB.ATT.COM;
      select * from "test1"@ZLX70604.DB.ATT.COM
      *
      ERROR at line 1:
      ORA-02085: database link ZLX70604.DB.ATT.COM connects to HO.WORLD
       
      SQL> alter session set global_names=false;
       
      Session altered.
       
      SQL> select * from "test1"@ZLX70604.DB.ATT.COM;
       
      col       col2
      --- ----------
      B          987   <<< works with global_names=false.

        Attachments

          Activity

            People

            • Assignee:
              Lawrin Lawrin Novitsky
              Reporter:
              aferrett Andy Ferretti
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: