chbenchmark's queries refer to non-existent tables

[alexanderlaw]

When running chbenchmark (on 12e3acc56): java -jar benchbase.jar -b chbenchmark -c config/postgres/chbenchmark_config.xml -create true -load true - -execute true

I get a lot of error messages generated: chbenchmark: [WARN ] 2023-05-20 03:44:16,025 [CHBenCHmarkWorker<000>] com.oltpbenchmark.api.Worker doWork - SQLException occurred during [com.oltpbenchmark.benchmarks.chbenchmark.queries.Q8/08] and will not be retried... sql state [42P01], error code [0]. chbenchmark: org.postgresql.util.PSQLException: ERROR: relation "stock" does not exist chbenchmark: Position: 162 chbenchmark: at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) chbenchmark: at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) chbenchmark: at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) chbenchmark: at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) chbenchmark: at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) chbenchmark: at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) chbenchmark: at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134) chbenchmark: at com.oltpbenchmark.benchmarks.chbenchmark.queries.GenericQuery.run(GenericQuery.java:33) chbenchmark: at com.oltpbenchmark.benchmarks.chbenchmark.CHBenCHmarkWorker.executeWork(CHBenCHmarkWorker.java:38) chbenchmark: at com.oltpbenchmark.api.Worker.doWork(Worker.java:416) chbenchmark: at com.oltpbenchmark.api.Worker.run(Worker.java:282) chbenchmark: at java.base/java.lang.Thread.run(Thread.java:833)

grep -r 'ERROR: relation "stock" does not exist' run.log | wc -l 937674

Really, https://github.com/cmu-db/benchbase/blob/main/src/main/resources/benchmarks/chbenchmark/ddl-postgres.sql and https://github.com/cmu-db/benchbase/blob/main/src/main/java/com/oltpbenchmark/benchmarks/chbenchmark/CHBenCHmarkLoader.java don't create and load the table "stock", but it's presented in the benchmark schema: https://github.com/cmu-db/benchbase/wiki/CH-benCHmark and used, for example, in https://github.com/cmu-db/benchbase/blob/main/src/main/java/com/oltpbenchmark/benchmarks/chbenchmark/queries/Q2.java

(chbenchmark/queries refer also other non-existent tables)