[MDEV-7638] DROP SERVER IF EXISTS does not return a warning Created: 2015-02-26  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5, 10.0, 10.1
Fix Version/s: 10.4, 10.5

Type: Bug Priority: Minor
Reporter: Ian Gilfillan Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: upstream, verified
Environment:

Ubuntu 14.04


 Description   

I would imagine DROP SERVER IF EXISTS is supposed to return a warning if the server does not exist, as do all the other "IF EXISTS" DROP statements. However, no warning appears.

DROP SERVER server_1;
 
ERROR 1477 (HY000): The foreign server name you are trying to reference does not exist. Data source error:  server_1
 
 
 
DROP SERVER IF EXISTS server_1;
 
Query OK, 0 rows affected (0.00 sec)



 Comments   
Comment by Elena Stepanova [ 2015-02-27 ]

Same in MySQL.
Do you feel like creating a bug report at bugs.mysql.com? (I haven't found one about it)

Comment by Ian Gilfillan [ 2016-11-19 ]

I couldn't find the bug on MySQL's bug database. I tried to report it, but Oracle were asking for all sorts of information such as my phone number, address etc. so didn't go further.

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