Bug #6209

PATCH NEEDED - Tables like [cat/dog] not recognized

Details

Request #6209	PATCH NEEDED - Tables like [cat/dog] not recognized
Submitted	2005-12-09 13:37 UTC
From	not at wgpower dot net
Status	Verified
Package	SQL_Parser
PHP Version	Irrelevant
OS	Irrelevant
Roadmaps	(Not assigned)

Comments

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

[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