[
https://issues.apache.org/jira/browse/DRILL-915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-915:
---------------------------------
Fix Version/s: (was: Future)
1.0.0
Assignee: Mehant Baid
Priority: Critical (was: Major)
> Extracting year from a time literal should fail
> -----------------------------------------------
>
> Key: DRILL-915
> URL: https://issues.apache.org/jira/browse/DRILL-915
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Rahul Challapalli
> Assignee: Mehant Baid
> Priority: Critical
> Fix For: 1.0.0
>
>
> When we try to extract year, month or day from time, drill seems to be
> returning 1970, 1, 1 respectively (1970-01-01 is a valid date). When we try
> to extract hour, minute, or second from any date literal, drill gives 0's.
> In both cases we should fail the query with a proper message. Postgres fails
> the query in both the cases.
> select extract (day from time '02:22:12') from basic;
> select extract (hour from date '2000-04-21') from basic;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
