TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
542 stars 115 forks source link

Add schema and consistency checks for all databases for TPROC-C and TPROC-H #664

Closed sm-shaw closed 5 months ago

sm-shaw commented 5 months ago

As described in #659 PR adds another GUI option and checkschema CLI command to run the following tests to validate the schema and also to verify that the data is consistent after running a test. All databases have been checked to verify that this is the case in a default scenario.

TPROC-C

Check 1 Database Exist

Check 2 Tables Exist

Check 3 Warehouse count in schema is the same as dict setting

Check 4 Tables are indexed

Check 5 Tables are populated

Check 6 Stored Procedures Exist

Consistency check 1

Consistency check 2

Consistency check 3

Consistency check 4

TPROC-H

Check 1 Database Exist

Check 2 Tables Exist

Check 3 supplier count in schema is the same as dict setting

Check 4 Tables are indexed

Check 5 Tables are populated

Consistency check

abondvt89 commented 5 months ago

Merging after reviews and approval of the three members of the code maintenance team.