[Phpmyadmin-devel] about keywords

Michal Čihař michal at cihar.com
Mon Jan 31 15:01:50 CET 2005


On Sun 30. 1. 2005 14:07, Marc Delisle wrote:
> I remember about this. The original sqlparser.data.php used MySQL sources.
> But I don't think the problem is there.

Yes, the problem is here. We can use same reserved words as MySQL does and we 
would not have this problem.

> We want to treat "events" as a keyword and capitalize it for pretty 
> but this causes problems when not backquoted by the user.

And WHY do we treat events as reserved word? We mix pretty printing and syntax 
analysing and it can't work without hacks. "EVENTS" has special meaning only 
in SHOW BINLOG EVENTS (maybe others, I'm not sure), so it should be 
highlighted as keyword only here.

> I think the analyser should be modified to avoid caps when the keyword is 
> in this context (as a field name or table name) but it would become complex 
to do.

MySQL reserved words are AFAIK not allowed in this context.

    Michal Čihař | http://www.cihar.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20050131/499b0e09/attachment.sig>

More information about the Developers mailing list