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
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.1.3beta
• OS: Windows (Windows XP)
• Assigned to: Victor Vagin
• CPU Architecture: Any

[2 Jul 2004 14: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 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: <[e-mail]>
From: [e-mail]
To: [e-mail]
Subject: bk commit into 4.1 tree (vva:1.2022)

ChangeSet
  1.2022 04/07/08 21:25:17 [e-mail] +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
    http://www.mysql.com/doc/en/Installing_source_tree.html