[DRILL-6472] Drill allows to use decimal zero precision in CAST function for CTAS

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.14.0
• Labels: ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Denys Ordynskiy
• Reviewer: Arina Ielchiieva
• Created: 06/Jun/18 13:07
• Updated: 08/Jul/19 15:59
• Resolved: 13/Jul/18 12:56

Description

I can run query with casting data for decimal with zero precision in SELECT statement

select cast(1111.05 as decimal(0,5));

+-------------+
| EXPR$0      |
+-------------+
| 1111.05000  |
+-------------+

Also I can use this query for CTAS

create table dfs.tmp.`zero_pr` as select cast(1111.05 as decimal(0,5));

+----------+---------------------------+
| Fragment | Number of records written |
+----------+---------------------------+
| 0_0      | 1                         |
+----------+---------------------------+

But when I try to select data from this table, I get an error:

create table dfs.tmp.`zero_pr` as select cast(1111.05 as decimal(0,5));

Error: SYSTEM ERROR: IllegalArgumentException: Invalid DECIMAL precision: 0 [Error Id: 2e320f55-aa65-4127-82be-6256e0744bdc on maprhost:31010] (state=,code=0)

Issue Links

• is related to: DRILL-6471 Different result for CAST String and Decimal literals as Decimal
• links to: GitHub Pull Request #1380