joomla/joomla-cms — pull request #185 by wdaniels (2012-04-10 12:06:16+00:00)
Title: SQL92 RDBMS Portability

First set of patches to assist RDBMS portability as previously discussed on the general development list. This covers the following:

- Identifier quoting of SQL reserved words:
- LANGUAGE
- MODULE
- OPTION
- TIME

- Identifier quoting of Virtuoso reserved word:
- PASSWORD

- Quoting of string literals in some places

- Correct use of non-standard != logic comparison operator to <>

- Casting of some long types used in SQL functions that may not support long types

These changes are organised by front/admin then by component/module/plugin but squashed into single commits with respect to the categories of changes listed above. Given that none of the categories of changes are intended to alter any functional features, I hope that this is suitably divided and correct granularity for manual testing.

If preferred the commits are available unsquashed on separate branches under wdaniels/joomla-cms as indicated by the [branch-name] prefixes of the squashed commits messages where merged into this (sql92) branch.

These patches are relatively trivial and I do not believe to be contentious. Further patch sets I intend to raise for discussion on joomla platform/cms lists as appropriate.