Mailing-List: contact commits-help@empire-db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: empire-db-dev@empire-db.apache.org
Date: Sat, 29 Oct 2016 11:08:58 +0000 (UTC)
From: =?utf-8?Q?Rainer_D=C3=B6bele_=28JIRA=29?= <empire-db-dev@incubator.apache.org>
To: empire-db-commits@incubator.apache.org
Message-ID: <JIRA.13016349.1477739313000.125420.1477739338313@Atlassian.JIRA>
In-Reply-To: <JIRA.13016349.1477739313000@Atlassian.JIRA>
References: <JIRA.13016349.1477739313000@Atlassian.JIRA> <JIRA.13016349.1477739313031@arcas>
Subject: [jira] [Created] (EMPIREDB-248) date functions not properly handled
 in PostgreSQL
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Sat, 29 Oct 2016 11:09:00 -0000

Rainer D=C3=B6bele 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=C3=B6bele
            Assignee: Rainer D=C3=B6bele
             Fix For: empire-db-2.4.5


Alberto Osvaldo Gonzalez reported:

Hi, this is Alberto from Argentina. I=E2=80=99m using empire-db and found a=
n issue using postgresqldriver.=20
The problem appears when using the =E2=80=9Cyear=E2=80=9D function to extra=
ct the year from a date.=20

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
(v6.3.4#6332)