Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.7.0
Request #6209 PATCH NEEDED - Tables like [cat/dog] not recognized
Submitted: 2005-12-09 13:37 UTC
From: not at wgpower dot net Assigned:
Status: Verified Package: SQL_Parser
PHP Version: Irrelevant OS: Irrelevant
Roadmaps: (Not assigned)    
Subscription  


 [2005-12-09 13:37 UTC] not at wgpower dot net
Description: ------------ SQL writted with MS ACCESS allows to name tables with '/' symbols , like 'cats/dogs' , and to access to them we should use [] symbols, for exemple SELECT * FROM [cats/dogs] , the parse don't recognize [] and / symbols in table names.

Comments

 [2005-12-13 17:50 UTC] epte at php dot net
In fact, MS ACCESS SQL isn't very supported at all. So far, the main targets have been ANSI and mysql. Thank you for the bug report. It will take me a little while before you see a fix. I've got some serious refactoring to do in there. If you want to try your hand at making a patch, you're more than welcome :) Erich
 [2011-02-14 10:11 UTC] alan_k (Alan Knowles)
-Summary: Tables like [cat/dog] not recognized +Summary: PATCH NEEDED - Tables like [cat/dog] not recognized