Bug #25709 Federated: disallow duplicate CREATE SERVER options
Submitted: 18 Jan 2007 22:24 Modified: 18 Jan 2007 22:59
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Federated storage engine Severity:S4 (Feature request)
Version:5.1.15-beta-debug-log OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: CPU Architecture:Any

[18 Jan 2007 22:24] Peter Gulutzan
For most CREATE statements, I can't use the same clause more than once.
The same should apply for CREATE SERVER.

How to repeat:
mysql> create table ty (s1 int);
Query OK, 0 rows affected (0.37 sec)

mysql> create index iy on ty (s1,s1);
ERROR 1060 (42S21): Duplicate column name 's1'
mysql> create server sy foreign data wrapper mysql options (user 'a', user 'b', user 'b');
Query OK, 1 row affected (0.00 sec)

The feature request is that there should be an error message.
[18 Jan 2007 22:59] MySQL Verification Team
Thank you for the bug report.