[DRILL-6710] Disallow negative scale for VarDecimal

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.15.0
• Component/s: Execution - Relational Operators
• Labels: ready-to-commit
• Assignee: Vova Vysotskyi
• Reporter: Robert Hou
• Reviewer: Sorabh Hamirwasia
• Created: 23/Aug/18 21:13
• Updated: 27/Sep/19 18:20
• Resolved: 05/Sep/18 18:12

Description

Query is:
select cast('999999999999999999' as decimal(18,0)) + cast('9999999999999999999999999999999999999' as decimal(38,0)) from data limit 1

This is the error I get when my test program calls SQLExecDirect:

The driver reported the following diagnostics whilst running SQLExecDirect

HY000:1:40140:[MapR][Support] (40140) Scale can't be less than zero.

Issue Links

• is a parent of: DRILL-6713 Infinite loop when retrieving decimal value with scale = -1
• links to: GitHub Pull Request #1451
• links to: GitHub Pull Request #1453