TPC-H q8 fails with overflow (since version 28)

[andygrove]

Describe the bug

Arrow error: Compute error: Overflow happened on: 19293795273 * 100000000000000000000000000000000000000

To Reproduce

Here is a Google colab notebook that demonstrates the issue

https://colab.research.google.com/drive/13vCffhO1-IP3NtXT1FgO-j6MwoQZlPtm?usp=sharing

Expected behavior

No response

Additional context

This was originally discovered by Mimoune Djouallah:

https://twitter.com/mim_djo/status/1686955130812542976?s=20

[andygrove]

I confirmed that this issue does not happen with version 27

[andygrove]

Ok, I see that earlier versions returned the wrong result. It is better now that we fail, but will leave this issue open because we shouldn't fail either.

Related issue: #6794

[alamb]

I think this may be fixed now that #6832 has been merged

[viirya]

I've added additional cast to make TPCH q8 pass under benchmark. Let's see now if it can be passed after #6832.