SQL compatibility issue: {system} s

Posted by thekevinday on September 15, 2009 at 9:15pm

Issue Summary

The installer has a couple of update commands like so:

UPDATE {system} s SET

Not specifying the AS will break any SQL languages that do not assume the AS keyword or have some sort of strict mode.

Please replace the code

UPDATE {system} s SET

with the following:

UPDATE {system} AS s SET

Posted by thekevinday on February 9, 2011 at 4:38pm

Status:

active

» closed (works as designed)