TPC-H issue -- decimal unsupported?

[aengelke]

I'm unable to run TPC-H benchmarks (sf=0.01, for testing), e.g. Q6, with the WasmV8 backend:

$ echo "CREATE DATABASE TPC; USE TPC; CREATE TABLE Lineitem (l_orderkey INT(4) NOT NULL, l_partkey INT(4) NOT NULL, l_suppkey INT(4) NOT NULL, l_linenumber INT(4) NOT NULL, l_quantity DECIMAL(10, 2) NOT NULL, l_extendedprice DECIMAL(10, 2) NOT NULL, l_discount DECIMAL(10, 2) NOT NULL, l_tax DECIMAL(10, 2) NOT NULL, l_returnflag CHAR(1) NOT NULL, l_linestatus CHAR(1) NOT NULL, l_shipdate DATE NOT NULL, l_commitdate DATE NOT NULL, l_receiptdate DATE NOT NULL, l_shipinstruct CHAR(25) NOT NULL, l_shipmode CHAR(10) NOT NULL, l_comment CHAR(44) NOT NULL); IMPORT INTO Lineitem DSV \"benchmark/tpc-h/data/lineitem.tbl\" ROWS 60175 DELIMITER \"|\"; SELECT         SUM(l_extendedprice * l_discount) AS revenue FROM         Lineitem WHERE         l_shipdate >= d'1994-01-01'         AND l_shipdate < d'1995-01-01'         AND l_quantity < 24;" | build_debug/bin/shell --benchmark --times --backend WasmV8 --data-layout PAX4M --quiet -
Read DSV file: 2243.2
/mutable/src/backend/WasmUtil.cpp:82:13: runtime error: execution reached an unreachable program point
SUMMARY: UndefinedBehaviorSanitizer: undefined-behavior /mutable/src/backend/WasmUtil.cpp:82:13 

Built with the following commands in a Ubuntu 24.04 container:

apt-get update
apt-get install -y clang cmake ninja-build git libboost-dev wget xz-utils
cmake -S mutable -B mutable/build_debug -DCMAKE_C_COMPILER=clang -DCMAKE_CXX_COMPILER=clang++ -G Ninja
TAR_OPTIONS=--no-same-owner ninja -C mutable/build_debug

Other queries also don't work, probably due to lineitem using decimal. How to fix?

[ImmanuelHaffner]

Did you use our TPC-H schema definition?