Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-2513

SUM measure return type should not overflow

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: v1.6.0
    • Fix Version/s: v2.0.0
    • Component/s: Metadata
    • Labels:
      None

      Description

      Currently, the SUM measure return type is the same with original table column type, that would not work if the original table column has very limit digit capability. Take an example, the original column type is decimal(1,0), if we SUM on this column, the result will be overflow soon.

      Proposal: Define the return type much more clear. If the original column type is decimal with decimal point, no matter what the precision digit is, define the return type as decimal(19,4). If the original column type has no decimal point´╝îdefine the return type as decimal(14,0). If the original column is integer family, the return type would be bigint.

        Attachments

          Activity

            People

            • Assignee:
              mahongbin Hongbin Ma
              Reporter:
              yimingliu Billy Liu

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment