[
https://issues.apache.org/jira/browse/DRILL-3719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14744513#comment-14744513
]
Chun Chang commented on DRILL-3719:
-----------------------------------
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select commit_id from
sys.version;
+-------------------------------------------+
| commit_id |
+-------------------------------------------+
| 0686bc23e8fbbd14fd3bf852893449ef8552439d |
+-------------------------------------------+
1 row selected (0.232 seconds)
0: jdbc:drill:schema=dfs.drillTestDirDropTabl> select -extract(day from
birth_date) from cp.`employee.json` limit 1;
+---------+
| EXPR$0 |
+---------+
| -26 |
+---------+
1 row selected (0.278 seconds)
> Adding negative sign in front of EXTRACT triggers Assertion Error
> -----------------------------------------------------------------
>
> Key: DRILL-3719
> URL: https://issues.apache.org/jira/browse/DRILL-3719
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 1.2.0
>
>
> A simple repo:
> When we typing
> {code}
> select -EXTRACT(DAY FROM birth_date) from cp.`employee.json`;
> {code}
> we probably mean
> {code}
> select -1 * EXTRACT(DAY FROM birth_date) from cp.`employee.json`;
> {code}
> However, the first one will trigger assertion error:
> Error: SYSTEM ERROR: AssertionError: todo: implement syntax
> PREFIX(-(EXTRACT(FLAG(DAY), $0)))
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
