empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rainer Döbele (JIRA) <empire-db-...@incubator.apache.org>
Subject [jira] [Created] (EMPIREDB-248) date functions not properly handled in PostgreSQL
Date Sat, 29 Oct 2016 11:08:58 GMT
Rainer Döbele created EMPIREDB-248:

             Summary: date functions not properly handled in PostgreSQL
                 Key: EMPIREDB-248
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-248
             Project: Empire-DB
          Issue Type: Bug
          Components: Core
            Reporter: Rainer Döbele
            Assignee: Rainer Döbele
             Fix For: empire-db-2.4.5

Alberto Osvaldo Gonzalez reported:

Hi, this is Alberto from Argentina. I’m using empire-db and found an issue using postgresqldriver.

The problem appears when using the “year” function to extract the year from a date. 

This is the original source code:

(line 347)

case SQL_FUNC_DAY:                return "day(?)";
case SQL_FUNC_MONTH:              return "month(?)";
case SQL_FUNC_YEAR:               return "year(?)";

And this is what i modified:

(line 347)
case SQL_FUNC_DAY:                return "extract(day from ?)";
case SQL_FUNC_MONTH:              return "extract(month from ?)";
case SQL_FUNC_YEAR:               return "extract(year from ?)";

This message was sent by Atlassian JIRA

View raw message