This package contains the Join Order Benchmark (JOB) queries from: "How Good Are Query Optimizers, Really?" by Viktor Leis, Andrey Gubichev, Atans Mirchev, Peter Boncz, Alfons Kemper, Thomas Neumann PVLDB Volume 9, No. 3, 2015 http://www.vldb.org/pvldb/vol9/p204-leis.pdf
the csv_files/schematext.sql and queries/*.sql is modified to MySQL syntax.
IMDB Data Set
The CSV files used in the paper, which are from May 2013, can be found at http://homepages.cwi.nl/~boncz/job/imdb.tgz
use load_data.sh to load data into mysql or TiDB.
queries/17b.sql and queries/8d.sql have order problem, because we use diffrent order rule from MySQL, so it is not a real bug.
exec analyze_table.sql