[development] Any solution for solving DB reserved wordconflict?

[Edison Wong]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
| I'm actually against adding more regexes to the database system.  
Regexing a serialized data structure is a design flaw.  If we're 
colliding with reserved words, let's just update the schema to not use 
reserved words per the SQL 99 spec.  Problem solved.

Hope to point out an interesting founding: the performance is not much 
different from our existing implementation, even I try to add some stuff 
in order to support totally 5 databases, both legacy and PDO 
implementation. This is proved by benchmarking result 
(http://edin.no-ip.com/project/siren/siren-1.0#benchmarking_result). We 
may not need to seems this minor regex as a monster.

Using escape character can solve the conflict *forever*; BTW, we always 
need to keep trace our source code in order to avoid the use of conflict 
wording (e.g. if database upgrade with some new reserved word, we will 
also need to upgrade our core; who can for sure that MySQL won't add 
some new wordings?). IMHO, I would prefer a permanent solution, rather 
than an open issue always stay beside us ;-)

- -
Edison Wong
hswong3i at gmail.com
http://edin.no-ip.com/html/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iD8DBQFHudunBPIQaq+ZRd8RAifOAJ0XUr2E15rPvIIo6aEy6EnXWTtlRQCeLlTg
YCbLUbow/JiGjPYGn/HqZjM=
=e0GS
-----END PGP SIGNATURE-----

-------------- next part --------------
A non-text attachment was scrubbed...
Name: hswong3i.vcf
Type: text/x-vcard
Size: 187 bytes
Desc: not available
Url : http://lists.drupal.org/pipermail/development/attachments/20080219/33602609/attachment.vcf