MDL-33172 - filestorage: Fix oracle incompatibilites
authorDan Poltawski <dan@moodle.com>
Thu, 24 May 2012 05:35:13 +0000 (01:35 -0400)
committerSam Hemelryk <sam@moodle.com>
Thu, 24 May 2012 23:17:56 +0000 (11:17 +1200)
commit3447100cdb2c0f5170ea0ca15940cd4996af4e28
tree79381dfe89ac13d70cfee1bc35e510ab4da80b60
parentac29403e398d724f30b0f34b0bcfc09da2278a08
MDL-33172 - filestorage: Fix oracle incompatibilites

Fixes the following problems:

* When we select from two tables with the same named fields (id)
  and ask to sort by that field, Oracle doesn't know which table to
  sort frm unless that field is named in the SELECT. Here we do that
  by explicitly naming the fields. This keeps compatibility with before
  the reference table was added.

* Text comparisong without sql_compare_text
lib/filestorage/file_storage.php