[ https://issues.apache.org/jira/browse/DRILL-6783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6783: ------------------------------------ Fix Version/s: 1.15.0 > 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: Minor > 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)