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. |
aferrett,
Could you please clarify why you consider it a MariaDB problem?
Be it a bug or a feature, it appears to be happening on the gateway side.
Also, quick internet search shows that it might be a known issue
https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:4406709207206
https://arindomdam.wordpress.com/2013/05/07/access-mysql-from-oracle/