'IF NOT EXISTS' ignored?

[Hassan Schroeder]

Is there a problem with 'IF NOT EXISTS' in the following scenario?

This statement creates the table as expected ...

CREATE TEMPORARY TABLE IF NOT EXISTS
        showcase (
                  PRIMARY KEY (product)
                  )
SELECT product FROM productList
.. but re-running it (from the console or via page reload) results
in  "ERROR 1062: Duplicate entry 'foo' for key 1"
I expected it to simply exit silently when it finds that the table
*does* already exist. So what am I missing?  :-)
/*  environment: MySQL 3.23.58 (on W2K)  */

TIA!
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
                          dream.  code.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]