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.