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

Different Resultset with AllowDiskBasedAggregation = Y

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 23.10.3
    • PrimProc
    • None
    • 2024-1, 2024-2

    Description

      If a Query needs enabled
      AllowDiskBasedAggregation (without it throws out of memory),
      the amout of rows is different on every run with identical data

       
      		 
      32GB
      		 
      4012201 rows in set (1 min 37.685 sec)
      		 
       
      		 
      64GB
      		 
      4021058 rows in set (1 min 36.787 sec)
      		 
       
      		 
      3786817 rows in set (1 min 36.296 sec)

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5875 MariaDB Columnstore 23.10.2: wrong COUNT DISTINCTs in GROUP BY

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5689 Resultset will be cut with setting columnstore_um_mem_limit >0

          • Major - Major loss of function.
          • Closed

          Activity

            People

              alexey.antipovsky Alexey Antipovsky
              Richard Richard Stracke
              Leonid Fedorov Leonid Fedorov
              Susil Behera Susil Behera
              Votes:
              1 Vote for this issue
              Watchers:
              4 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.