[ https://issues.apache.org/jira/browse/EMPIREDB-241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rainer Döbele closed EMPIREDB-241. ---------------------------------- > Error in lower() implementation for PostgreSQL > ---------------------------------------------- > > Key: EMPIREDB-241 > URL: https://issues.apache.org/jira/browse/EMPIREDB-241 > Project: Empire-DB > Issue Type: Bug > Components: Core > Affects Versions: empire-db-2.4.4 > Reporter: Vladimir Lahoda > Assignee: Francis De Brabandere > Fix For: empire-db-2.4.5 > > > The function lower() is not properly supported for PostgreSQL. The following > patch for DBDatabaseDriverPostgreSQL solves the problem: > =================================================================== > --- > empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java > (revision a812088bc78f7d98d19842d6abe0f4a7727deb83) > +++ > empire-db/src/main/java/org/apache/empire/db/postgresql/DBDatabaseDriverPostgreSQL.java > (revision ) > @@ -348,7 +348,7 @@ > case SQL_FUNC_STRINDEXFROM: return > "strindexfrom_not_available_in_pgsql({0}, ?, {1})"; // "locate({0}, ?, {1})"; > case SQL_FUNC_LENGTH: return "length(?)"; > case SQL_FUNC_UPPER: return "upper(?)"; > - case SQL_FUNC_LOWER: return "lcase(?)"; > + case SQL_FUNC_LOWER: return "lower(?)"; > case SQL_FUNC_TRIM: return "trim(?)"; > case SQL_FUNC_LTRIM: return "ltrim(?)"; > case SQL_FUNC_RTRIM: return "rtrim(?)"; -- This message was sent by Atlassian JIRA (v6.3.4#6332)