[daisy] [JIRA] Created: (DSY-523) [PATCH] database indepent implementation of UpperCase() and LowerCase() functions

Wed Aug 1 16:33:53 CDT 2007

[PATCH] database indepent implementation of UpperCase() and LowerCase() functions
---------------------------------------------------------------------------------

         Key: DSY-523
         URL: http://issues.cocoondev.org//browse/DSY-523
     Project: Daisy
        Type: Bug
  Components: Repository, Repository - querying and indexing  
    Versions: 2.1    
 Environment: SVN 4286
 Reporter: Andreas Deininger
    Priority: Minor

Currently, the implementation of the LowerCase() and UpperCase() function of daisy's query language depends on the existence of the SQL string functions UCASE() and LCASE(). These functions, however, are not available on other databases (e.g. PostgreSQL). Therefore, the implementation of that functions should be based on the SQL UPPER()  and LOWER() functions which are available both in MySQL and PostgreSQL.
Affected file: org/outerj/daisy/jdbcutil/JdbcHelper.java

A patch for that issue is attached.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira