[Everydevel-bugs] [ everydevel-Bugs-508244 ] dbtable edit page allows reserved words

[<no...@so...>]

Bugs item #508244, was opened at 2002-01-24 17:32
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=426093&aid=508244&group_id=39838

Category: Interface (example)
Group: v1.0 (example)
Status: Open
Resolution: None
Priority: 3
Submitted By: Jay Bonci (jaybonci)
Assigned to: Nobody/Anonymous (nobody)
Summary: dbtable edit page allows reserved words

Initial Comment:
Quasi bug, quasi feature request.
<br><br>
When editing any dbtable, you can enter reserved words 
into it (causing mysql to fail miserably).  This code 
is primarily in dbtable.pm, but it may be trivial to 
have it reference a setting of forbidden keywords, 
attached to this bug.  Otherwise, it is easy to make 
the mistake of trying to create table and column names 
of type [character], [order], or [key] (or berkeley_db 
I suppose, but I mean cmon).
<br><br>
Attached is a Data::Dumper dump of all the reserved 
keywords for mySQL latest (lowercased).  It allows you 
to simply import it into a setting, and was ripped 
directly from the mySQL documentation.
<br><br>
(Note, I'm bugging this because, even though I could 
fix it probably, I am short on time, and there are 
millions of bored people across the globe, that 
possibly one of which could fix)


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=426093&aid=508244&group_id=39838