CREATE DATABASE IF NOT EXISTS not working in 4.1.2-alpha?

Hi,

I'm just looking at 4.1.2-alpha for the first time and immediately ran 
into a problem.  The IF NOT EXISTS part of CREATE DATABASE doesn't seem 
to be working -- it causes an error if the database does already exist, 
just as you would get without the IF NOT EXISTS bit:

=====
C:\mysql\bin>mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.2-alpha-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database if not exists foo;
Query OK, 1 row affected (0.00 sec)

mysql> create database if not exists foo;
ERROR 1006 (HY000): Can't create database 'foo' (errno: 17)
=====

The above SQL commands worked fine in 4.0.18.  Has this been 
deliberately changed (I couldn't see anything different in the manual), 
or is it broken?

- Steve



------------------------------------------------
Radan Computational Ltd.

The information contained in this message and any files transmitted with it are confidential and intended for the addressee(s) only.  If you have received this message in error or there are any problems, please notify the sender immediately.  The unauthorized use, disclosure, copying or alteration of this message is strictly forbidden.  Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Radan Computational Ltd.  The recipient(s) of this message should check it and any attached files for viruses: Radan Computational will accept no liability for any damage caused by any virus transmitted by this email.


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]