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

[Bruno Dumon (JIRA)]

     [ http://issues.cocoondev.org//browse/DSY-523?page=all ]

Bruno Dumon updated DSY-523:
----------------------------

    Component: Repository - database support
                   (was: Repository)
                   (was: Repository - querying and indexing)

> [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 - database support
>     Versions: 2.1
>  Environment: SVN 4286
>     Reporter: Andreas Deininger
>     Priority: Minor
>  Attachments: DSY-523.patch
>
> 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