Bug #1738 "IF NOT EXISTS" not working in CREATE TABLE
Submitted: 3 Nov 2003 0:55 Modified: 8 Nov 2003 8:04
Reporter: André Lehmann Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.16 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[3 Nov 2003 0:55] André Lehmann 
Description:
If you use the option "IF NOT EXISTS" in the "CREATE TABLE" command, the table is still replaced by the new one, and the former table is destroyed without warning.

How to repeat:
Using my database, the following statment erases systematically the former 'places' table :
CREATE TABLE IF NOT EXISTS places SELECT DISTINCT Site, YEAR(Date) as Date, Capteur FROM mesures
[3 Nov 2003 1:21] Indrek Siitan 
This is a duplicate of bug #1434, has been fixed in our development tree 
and will be fixed in 4.0.17.
[8 Nov 2003 8:04] Sergei Golubchik 
I wasn't able to repeat it - data are added to the table, old data are not replaced.
In the 4.0.16.

If you can provide a repeatable test case, please reopen this bugreport.