Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6710

Disallow negative scale for VarDecimal

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    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.

      Attachments

        Issue Links

        is a parent of

        Bug - A problem which impairs or prevents the functions of the product. DRILL-6713 Infinite loop when retrieving decimal value with scale = -1

        • Major - Major loss of function.
        • Closed
        links to

        Web Link GitHub Pull Request #1451

        Web Link GitHub Pull Request #1453

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            volodymyr Vova Vysotskyi
            rhou Robert Hou
            Sorabh Hamirwasia Sorabh Hamirwasia
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment