Bug #102257 main.cast tests are failing on Ubuntu 20.04.1

• Submitted: 15 Jan 2021 11:35
• Modified: 15 Jan 2021 17:04
• Reporter: Rael G. C.
• Status: Verified
• Category: MySQL Server: Tests
• Severity: S7 (Test Cases)
• Version: 8.0-8.0.22
• OS: Ubuntu (20.04.1)
• CPU Architecture: x86 (AMD Ryzen 5 4650G)
• Tags: Tests

[15 Jan 2021 11:35] Rael G. C.

Description:
I've tried to compile MySQL Server on Ubuntu, using the available source package. And during the testing phase, it failed on `main.cast` suite with the following log:

https://pastebin.com/gBAjF6sh

I can see some casting reported bugs, not sure if related:

- [CAST from large double to integer produces inconsistent results](https://bugs.mysql.com/bug.php?id=50567)
- [Equivalent SQL like "select cast( varchar as decimal)" returns different results](https://bugs.mysql.com/bug.php?id=78415)
- [https://bugs.mysql.com/bug.php?id=100567](https://bugs.mysql.com/bug.php?id=100567)

How to repeat:
In order to get the source code, I've enabled source repositories, then:

1. sudo apt build-dep mysql-server-core-8.0
2. apt-get source --compile mysql-server-core-8.0

Then later the failing testing can be re-run using the `mysql-test-run.pl` or invoking the Debian build binary command, `debuild -b -uc -us`.

[15 Jan 2021 17:04] MySQL Verification Team

Thank you for the bug report.