Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Tue, 3 Jun 2014 18:23:06 +0000 (UTC)
From: "Xiao Meng (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12714385.1400118823046.66584.1401819786202@arcas>
In-Reply-To: <JIRA.12714385.1400118823046@arcas>
References: <JIRA.12714385.1400118823046@arcas>
Subject: [jira] [Updated] (DRILL-748) C++ Client - Support timestamp/date
 before unix time and handle y2028 problem
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DRILL-748?page=3Dcom.atlassian=
.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xiao Meng updated DRILL-748:
----------------------------

    Attachment:     (was: DRILL-748.1.patch.txt)

> C++ Client - Support timestamp/date before unix time and handle y2028 pro=
blem
> -------------------------------------------------------------------------=
----
>
>                 Key: DRILL-748
>                 URL: https://issues.apache.org/jira/browse/DRILL-748
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - C++
>            Reporter: Xiao Meng
>            Assignee: Xiao Meng
>              Labels: C++, client
>
> Query like:
> {code}
> show files in dfs.`/tmp`
> {code}
> will fail because the timestamp value =E2=80=991968-12-31 16:00:00'
> The C++ Drill Client use uint64_t to store the time, any timestamp before=
 unix time =E2=80=9C1970-1-1 00:00:00=E2=80=9D will fail.
> Query for Test
> {code}
> ./querySubmitter api=3Dasync type=3Dsql  connectStr=3Djdbc:drill:local=3D=
localhost:31010  query=3D"select cast('-123456-7-8' as date) as negative_da=
te, cast('876543-2-1' as date) as positive_date, timestamptztype(-2038,1,2,=
3,4,5,6,'UTC') as tz from INFORMATION_SCHEMA.SCHEMATA"
> {code}


--
This message was sent by Atlassian JIRA
(v6.2#6252)