Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.7.0

Bug #4089 IF EXISTS not recognized in DROP statements
Submitted: 2005-04-06 19:51 UTC
From: epte at ruffdogs dot com Assigned: alan_k
Status: Closed Package: SQL_Parser
PHP Version: Irrelevant OS:
Roadmaps: 0.5.1    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
2011-02-14 10:08 UTC
Package:
Bug Type:
Summary:
From: epte at ruffdogs dot com
New email:
PHP Version: Package Version: OS:

 

 [2005-04-06 19:51 UTC] epte at ruffdogs dot com
Description: ------------ This sql breaks: Reproduce code: --------------- DROP TABLE IF EXISTS `mpn_bannerfinish`; Actual result: -------------- Parse error: Expected a table name on line 7 DROP TABLE IF EXISTS `mpn_bannerfinish`; ^ found: "IF"

Comments

 [2007-06-28 16:29 UTC] cybot (Sebastian Mendel)
added a patch which introduce support for create table options from MySQL
 [2011-02-13 22:12 UTC] alan_k (Alan Knowles)
-Assigned To: cybot +Assigned To: alan_k
 [2011-02-14 10:08 UTC] alan_k (Alan Knowles)
-Status: Assigned +Status: Closed
This bug has been fixed in SVN. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.