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

Integrated release builds cause random results for some queries

    XMLWordPrintable

Details

    Description

      We're not sure why yet, but doing an integrated build (CS is built as part of the server build) with CMAKE_BUILD_TYPE=Release, causes some queries with joins and aggregations to return random wrong results.

      Easiest reproduction is SELECT COUNT FROM LINEITEM, ORDERS WHERE L_ORDERNUM=O_ORDERNUM

      The correct result is the number of rows in LINEITEM table. When reproducing you will see much smaller number.

      Switching the build type to RelWithDebInfo makes it work, and doing a non-integrated build (CS repo is built separately from the server) makes it work.

      For now I've set our ci/cd system to do RelWithDebInfo builds so we don't create broken pkgs.

      The goal of this top-level ticket is to find and fix the cause of the problem with integrated release builds.

      Existing tickets fixed by this build type change can be made subtasks of this ticket. I would suggest if the build type fixes it, then those existing tickets can also be marked fixed. They'd be considered symptoms of this ticket, not a separate problem.

      Attachments

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              leonid.fedorov Leonid Fedorov
              pleblanc Patrick LeBlanc (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.