geonetwork/core-geonetwork — pull request #353 by riniangreani (2014-01-21 09:28:40+00:00)
Title: #1239: Fix SQL queries for case sensitive db.

This is an attempt to fix http://trac.osgeo.org/geonetwork/ticket/1239. The workaround (setting MySQL global lower_case_table_names parameter to 1) is not always applicable, e.g. for our case, the server is shared with other databases used by other applications.

I previously created a big patch fixing all the queries, applied them to 2.10.1 source and tested them on our local instance. However, I noticed the develop branch has changed significantly and the queries seem to be done in a more sophisticated way.

I am not sure if the static fields in Param and Geonet.Elem are also used for SQL queries (e.g. Params.GROUPS, Geonet.Elem.GROUPS). If they do, then we need to update them as well, since they're all in lower case, whereas the table names start with upper case.