| # Shared template for every predicate_eval benchmark. Each qNN.benchmark sets its | |
| # `subgroup` directive and includes this template with parameters: | |
| # QUERY query file stem under queries/ (e.g. costsel/q01) | |
| # DATASET load script stem under load/ (e.g. markers) | |
| # NAME criterion display name (e.g. costsel_q01_regexp_selective_last) | |
| # Optional, read by the load scripts as ${...:-default}: | |
| # PRED_ROWS synthetic row count (default 1000000) | |
| # PRED_FILL filler chars per marker, the string-width knob (default 30) | |
| # The knob sweeps reuse another subgroup's query file through QUERY, and the table | |
| # is always named `t`, so cleanup is uniform across datasets. | |
| load sql_benchmarks/predicate_eval/load/${DATASET}.sql | |
| name ${NAME} | |
| group predicate_eval | |
| run sql_benchmarks/predicate_eval/queries/${QUERY}.sql | |
| result sql_benchmarks/predicate_eval/results/${NAME}.csv | |
| cleanup sql_benchmarks/predicate_eval/init/cleanup.sql |