Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.0(EOL)
-
None
-
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. |