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

Bug #9999 release is a reserved work in mysql 5
Submitted: 2007-02-01 01:18 UTC Modified: 2007-03-21 16:18 UTC
From: justinpatrin Assigned: saltybeagle
Status: Closed Package: pearweb (version 1.2.0RC1)
PHP Version: Irrelevant OS:
Roadmaps: 1.11.0    
Subscription  


 [2007-02-01 01:18 UTC] justinpatrin (Justin Patrin)
Description: ------------ Any SQL with a column named "release" fails with mysql 5 as it's a reserved word.

Comments

 [2007-02-01 05:46 UTC] mj (Martin Jansen)
We probably only need to put backticks around "release" in our queries in order to make this work again ... FYI, the complete list of reserved keywords can be found on http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
 [2007-02-01 08:34 UTC] danielc (Daniel Convissor)
Using identifiers that need to be delimited is a bad practice that leads to long term headaches. It would be best to rename the column.
 [2007-02-01 10:38 UTC] justinpatrin (Justin Patrin)
Using the quoteIdentifier feature of MDB2 would fix this problem. Of course, with the current state of the pearweb code this would mean major changes.
 [2007-02-10 00:52 UTC] cellog (Greg Beaver)
this can't/won't be fixed until pecl moves off of our box, too much bother otherwise.
 [2007-03-21 16:17 UTC] cellog (Greg Beaver)
This bug has been fixed in CVS. 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.