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  


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 40 + 9 = ?

 
 [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.