Bug #4378 "create database IF NOT EXISTS thing" returns an error
Submitted: 2 Jul 2004 14:06 Modified: 9 Jul 2004 15:58
Reporter: Dan Greening Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.3beta OS:Windows (Windows XP)
Assigned to: Bugs System CPU Architecture:Any

[2 Jul 2004 14:06] Dan Greening
"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)
[2 Jul 2004 19:31] MySQL Verification Team
I will test with the latest BK source tree.
[8 Jul 2004 15: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)

  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 18: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 15: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