Skip to content

When running HammerDB-3.3 TPCH for SQL Server 2019 ,it occurs error #87

Answered by sm-shaw
Wendy798 asked this question in Q&A
Discussion options

You must be logged in to vote

Although SQL Server 2019 is not listed as tested there is no known reason why it should not work correctly. Yes you would expect the dataset to be larger than 1000GB for SF1000 as you have to allow for indexes etc - in a quick test with SF1 the datafile is 2.25GB.
The error “Arithmetic overflow error converting expression to data type int.” is an error in the query rather than the database - in this case you use the int count rather than count_big that returns bigint that you should be using. (This is used in the queries eg select o_orderpriority, count_big(*) as order_count ...)
For the error “orders ” only has one column "O_ORDERDATE" but the row count is correct - this is inconsistent …

Replies: 2 comments

Comment options

You must be logged in to vote
0 replies
Answer selected by abondvt89
Comment options

You must be logged in to vote
0 replies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants
Converted from issue

This discussion was converted from issue #87 on December 16, 2020 18:13.