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

Wed Aug 1 16:35:50 CDT 2007

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

Andreas Deininger updated DSY-523:
----------------------------------

    Attachment: DSY-523.patch

This patch also fixes a typo in an exception error message.

> [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
>  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