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

Integrated release builds cause random results for some queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.5.2
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      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

            Activity

              People

              Assignee:
              ben.thompson Ben Thompson
              Reporter:
              pleblanc Patrick LeBlanc
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated: