[MDEV-6502] CONNECT: misleading error "table defined on itself" Created: 2014-07-28  Updated: 2014-08-10  Resolved: 2014-08-09

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.12
Fix Version/s: 10.0.14

Type: Bug Priority: Trivial
Reporter: Federico Razzoli Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: connect-engine


 Description   

I issued something like this:

MariaDB [test]> CREATE OR REPLACE TABLE target (id INT PRIMARY KEY) ENGINE = InnoDB;
 
Query OK, 0 rows affected (0.44 sec)
 
 
 
MariaDB [test]> CREATE OR REPLACE TABLE xyzzy
 
    -> ENGINE = CONNECT
 
    -> TABLE_TYPE = MYSQL
 
    -> CONNECTION = 'root:root@127.0.0.1/test/target'
 
    -> ;
 
ERROR 1105 (HY000): This MySQL table is defined on itself

I forgot "mysql://" in CONNECTION, but the error is misleading.

 Comments   
Comment by Olivier Bertrand [ 2014-08-09 ]

Trivial

Generated at Thu Feb 08 07:12:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.