[ https://issues.apache.org/jira/browse/DRILL-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16746137#comment-16746137 ]
Denys Ordynskiy commented on DRILL-6783: ---------------------------------------- Tested with Drill version 1.16.0-SNAPSHOT (commit 172dc7cb4c3323e9650db2bf7fe1eab76c2fbbe1). Cases verified: - casting string month interval literal as "interval month"; - casting string month interval literal as "interval year"; - casting string month interval literal as "interval day"; - casting string day interval literal as "interval month"; - casting string day interval literal as "interval day". > CAST string literal as INTERVAL MONTH/YEAR works inconsistently when > selecting from a table with multiple rows > -------------------------------------------------------------------------------------------------------------- > > Key: DRILL-6783 > URL: https://issues.apache.org/jira/browse/DRILL-6783 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.15.0 > Reporter: Bohdan Kazydub > Assignee: Bohdan Kazydub > Priority: Critical > Labels: ready-to-commit > Fix For: 1.15.0 > > > Casting string literal as INTERVAL MONTH or INTERVAL YEAR produces different > values for each row (actually, with period of 4) when selecting data from > table with more than one row. > For example: > {code} > 0: jdbc:drill:zk=local> select cast('P314M' as interval month) from > cp.`employee.json` limit 10; > +--------------------------+ > | EXPR$0 | > +--------------------------+ > | 26 years 2 months | > | 81089877 years 5 months | > | 1714858 years 8 months | > | 6698 years 8 months | > | 26 years 2 months | > | 81089877 years 5 months | > | 1714858 years 8 months | > | 6698 years 8 months | > | 26 years 2 months | > | 81089877 years 5 months | > +--------------------------+ > 10 rows selected (0.186 seconds) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)