Changes to the treatment of ORDER BY:
1. For json_query: when ORDER BY is expressed as an object keyed on class
(instead of an array of field specifications), and the class is not in
scope, error out instead of silently ignoring the class.
The other changes affect only methods other than json_query:
2. When the ORDER BY list is provided as a raw text string: block any
string containing a semicolon, in order to block simple SQL injections.
For now we make no exceptions for quoted semicolons, which are not
likely ever to appear an an ORDER BY clause.
3. Keep virtual fields out of the ORDER BY clause. For now we silently
ignore them, as we ignore non-existent fields. In both cases we should
perhaps error out.
4. Don't require that a class referenced in the ORDER BY clause also be
referenced in the SELECT clause. Just make sure it's in scope.
M Open-ILS/src/c-apps/oils_sql.c
git-svn-id: svn://svn.open-ils.org/ILS/trunk@18321
dcc99617-32d9-48b4-a31d-
7c20da2025e4