Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3607

ERROR 1815 with log10 and aggregation functions

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2, 1.2.5
    • 1.2.6
    • ExeMgr, PrimProc
    • None
    • 2019-06

    Description

      To reproduce

      create table log10test (a double) engine=columnstore;
      		 
      insert into log10test (a) values(123);
      		 
      select log10(sum(a)) from log10test;
      		 
      ERROR 1815 (HY000): Internal error: log10: datatype of long double

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MCOL-3647 Merge develop-1.2 into develop

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Richard Richard Stracke added a comment -

            workarround:

            select log10(CAST(sum(a) as decimal)) from log10test;

            Richard Richard Stracke added a comment - workarround: select log10(CAST(sum(a) as decimal)) from log10test;
            David.Hall David Hall (Inactive) added a comment -

            Added long double support to math functions

            David.Hall David Hall (Inactive) added a comment - Added long double support to math functions
            David.Hall David Hall (Inactive) added a comment -

            For QA, the following math functions are involved:
            acos, asin, atan, cos, cot, log, log2, log10, sin, sqrt, tan, radians, degrees

            Special cases of atan and log take an optional second parameter.

            The test is to use sum(v1) or avg(v1) as the argument

            David.Hall David Hall (Inactive) added a comment - For QA, the following math functions are involved: acos, asin, atan, cos, cot, log, log2, log10, sin, sqrt, tan, radians, degrees Special cases of atan and log take an optional second parameter. The test is to use sum(v1) or avg(v1) as the argument
            dleeyh Daniel Lee (Inactive) added a comment -

            Build verified: 1.2.6-1

            MariaDB [mytest]> select log10(sum(a)) from log10test;
            -------------------

            log10(sum(a))

            -------------------

            2.089905111439398

            -------------------
            1 row in set (0.065 sec)

            Also verified other functions in the last comment.

            Fixed has not yet been up merged to 1.4.1-1

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.2.6-1 MariaDB [mytest] > select log10(sum(a)) from log10test; ------------------- log10(sum(a)) ------------------- 2.089905111439398 ------------------- 1 row in set (0.065 sec) Also verified other functions in the last comment. Fixed has not yet been up merged to 1.4.1-1
            dleeyh Daniel Lee (Inactive) added a comment -

            The fix for 1.4.1-1 will be tracked in a different ticket. Closing this one.

            dleeyh Daniel Lee (Inactive) added a comment - The fix for 1.4.1-1 will be tracked in a different ticket. Closing this one.

            People

              dleeyh Daniel Lee (Inactive)
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.