]> git.mjollnir.org Git - moodle.git/commit
MDL-12523 accesslib:cleanup_contexts() - Fix invalid SQL syntax and reserved keywords
authormartinlanghoff <martinlanghoff>
Mon, 10 Dec 2007 21:35:58 +0000 (21:35 +0000)
committermartinlanghoff <martinlanghoff>
Mon, 10 Dec 2007 21:35:58 +0000 (21:35 +0000)
commit70dd126e0b0ce0827aeed0c79ca54b1c9f2a8dda
tree86f26a062c77f499ebbfcbfe0ff77fd171fa1b8a
parentaaa6ac6f2a1b332b5e47d277ffadfb50e390df87
MDL-12523 accesslib:cleanup_contexts() - Fix invalid SQL syntax and reserved keywords

cleanup_contexts() was not working on Oracle - mostly due to 2 SQL
syntax problems. So probably marginally working elsewhere.

 - We should not use AS when naming table/subselect aliases - only
   when referring to column aliases in the resultset

 - level is a reserved word - oops! - so back to contextlevel
lib/accesslib.php