Daniel Lindner

Change `CREATE TABLE` Columns' Default Nullability and Track Constraints

3

This PR makes the columns of `CREATE TABLE` statements nullable by default to conform to the SQL standard (see hyrise/sql-parser#209 for details). Furthermore, it stores `UNIQUE` and `PRIMARY KEY` constraints...

TSAN error during JoinHash's radix bit calculation

1

In recent CI builds, we encountered TSAN errors when running TPC-H Queries (see [full trace](https://github.com/hyrise/hyrise/files/9300437/tsan.log)): ``` #0 memcpy (hyriseBenchmarkTPCH+0x8efd87) #1 auto auto opossum::JoinHash::_on_execute()::$_1::operator()(boost::hana::basic_type) const::'lambda'(boost::hana::basic_type)::operator()(boost::hana::basic_type) const /var/lib/jenkins/workspace/hyrise_hyrise_PR-2490/src/lib/operators/join_hash.cpp:184:23 (libhyrise_impl.so+0x954add4) #2 auto void...

Correct Handling of Negative Numerical Literals

4

As mentioned by @JoyBinY in #213, the parser does not handle negative numerical literals correctly in all cases, especially for `INSERT` statements. Code for Reproduction: ```SQL INSERT INTO foo VALUES...

While going through the Public BI Benchmark, I found multiple queries with `HAVING` clauses but no `GROUP BY` columns (e.g., [1, 2, 3]). I'd like to discuss whether we want...

Consider the following SQL query: ```SQL SELECT CASE WHEN a < 1 THEN 1 WHEN a < 2 THEN 2 ELSE 3 END; ``` When parsing the query with 'example',...

Hyrise's `meta_segments_accurate` table contains the number of unique non-NULL values per segment. If a segment is not dictionary-encoded, this distinct value count has to be computed for each request. Since...

Refactor SortedSegmentSearch and add information to performance data

2

#2283 tracked SortedSegmentSearch's shortcuts (each/none value matches) for ColumnBetweenScans. This PR implements and tracks them for ColumnVsValueScans. Furthermore, the SortedSegmentSearch is refactored: (i) strict order of private/public methods, (ii) simplification...

While working on #2497, I noticed that we mix up access specifiers in some headers (e.g., `public` after `private`). After a quick search, I found header files with alternating specifiers,...

maybe fixes #220

#218 showed that issues with debug builds and recent GCC versions were not detected by the CI. Thus, this PR adds debug builds to all CI jobs and runs the...