Bug #4378 "create database IF NOT EXISTS thing" returns an error
Submitted: 2 Jul 2004 16:06 Modified: 9 Jul 2004 17:58
Reporter: Dan Greening
Status: Closed
Category:Server Severity:S1 (Critical)
Version:4.1.3beta OS:Microsoft Windows (Windows XP)
Assigned to: Bugs System Target Version:

[2 Jul 2004 16:06] Dan Greening 
Description:
"create database IF NOT EXISTS thing" returns an error if the database "thing" already
exists.  This is a new bug in 4.1.3beta, not present in 4.1.2alpha.

Because it returns an error, it breaks ant scripts and all sorts of other stuff.

How to repeat:
mysql> create database if not exists thing;
Query OK, 1 row affected (0.00 sec)

mysql> create database if not exists thing;
ERROR 1006 (HY000): Can't create database 'thing' (errno: 17)
mysql>
[2 Jul 2004 21:31] Miguel Solorzano 
I will test with the latest BK source tree.
[8 Jul 2004 17:43] Victor Vagin 
BTW, I couldn't find out why the mysql-4.1.2 didn't produce the bug...
Are you really sure, it was mysql-4.1.2, not mysql-4.1.1?

Date: Thu, 8 Jul 2004 21:25:20 +0500
Message-Id: <200407081625.i68GPKf00440@eagle.mysql.r18.ru>
From: vva@mysql.com
To: internals@lists.mysql.com
Subject: bk commit into 4.1 tree (vva:1.2022)

ChangeSet
  1.2022 04/07/08 21:25:17 vva@eagle.mysql.r18.ru +1 -0
  fixed Bug #4378 "create database IF NOT EXISTS thing" returns an error
[8 Jul 2004 20:30] Dan Greening 
Sorry. Right I think I was using 4.1.1a.  Did 4.1.2 ever make it to public distribution?
[9 Jul 2004 17:58] Victor Vagin 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html