Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Geting wrong tpch result of Q9 in mysql

on

I have reading the spec doc of tpch :

TPC BenchmarkTM H Standard Specification Revision 2.17.3

which can be found in the offical website of tpc.

It said the correct result of Q9 is 

NATION YEAR SUM_PROFIT
ALGERIA 1998 31342867.24

but I get this result in mysql (5.7.24)

+----------------+--------+---------------+
| NATION         | O_YEAR | SUM_PROFIT    |
+----------------+--------+---------------+
| ALGERIA        |   1998 | 27136900.1803 |

I had checked the data, it's all fine.

Then I google this wrong result "27136900.1803" and get this:

IMPALA-1655

It's a bug record of impala, it seem like they had using "27136900.1803" as the expect result.

So what's happening here,can anybody help me out this ? appreciate

Comments

Post a Comment