1.5.0: Build breaks: error: no member named 'left' in 'duckdb::SetOperationNode'

[yurivict]

This extension fails to build for duckdb-1.5.0:

/usr/ports/databases/duckdb/work/duckdb-1.5.0/extension/sqlsmith/src/statement_simplifier.cpp:199:16: error: no member named 'left' in 'duckdb::SetOperationNode'
  199 |         Simplify(node.left);
      |                  ~~~~ ^
/usr/ports/databases/duckdb/work/duckdb-1.5.0/extension/sqlsmith/src/statement_simplifier.cpp:200:16: error: no member named 'right' in 'duckdb::SetOperationNode'
  200 |         Simplify(node.right);
      |                  ~~~~ ^
/usr/ports/databases/duckdb/work/duckdb-1.5.0/extension/sqlsmith/src/statement_simplifier.cpp:221:31: error: no member named 'left' in 'duckdb::SetOperationNode'
  221 |                 SimplifyReplace(node, setop.left);
      |                                       ~~~~~ ^
/usr/ports/databases/duckdb/work/duckdb-1.5.0/extension/sqlsmith/src/statement_simplifier.cpp:222:31: error: no member named 'right' in 'duckdb::SetOperationNode'
  222 |                 SimplifyReplace(node, setop.right);
      |                                       ~~~~~ ^
4 errors generated.

Rev. e6e6750

[derekmahar]

@yurivict Why does this error prevent FreeBSD Ports from building DuckDB 1.5.2?

===>  Cleaning for duckdb-1.5.2
===>  duckdb-1.5.2 is marked as broken:
https://github.com/duckdb/duckdb-sqlsmith/issues/66.
*** Error code 1

Why not just omit extension sqlsmith from the DuckDB CLI build?

I have successfully built DuckDB CLI 1.5.2 with extensions autocomplete, httpfs, icu, json, tpch, core_functions, and parquet using Clang 19.1.7 command GEN=ninja CORE_EXTENSIONS="autocomplete;httpfs;icu;json;tpch" gmake. I assume that this command does not build extension sqlsmith. I also regularly build DuckDB CLI 1.6.0 (the development branch) using the same command.

Python module py311-duckdb 1.5.2 also successfully builds DuckDB 1.5.2, though possibly with different extensions and probably without sqlsmith.

[derekmahar]

@yurivict My mistake. Please ignore my previous message. I resolved the build issue by deleting the configuration in /usr/ports/databases/duckdb and then disabling extension SQLSMITH:

cd  /usr/ports/databases/duckdb
sudo make rmconfig
sudo make config # Disable extension SQLSMITH in the dialog.
sudo make install