Bug #102257 main.cast tests are failing on Ubuntu 20.04.1
Submitted: 15 Jan 11:35 Modified: 15 Jan 17:04
Reporter: Rael G. C. Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:8.0-8.0.22 OS:Ubuntu (20.04.1)
Assigned to: CPU Architecture:x86 (AMD Ryzen 5 4650G)
Tags: Tests

[15 Jan 11:35] Rael G. C.
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:


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 17:04] MySQL Verification Team
Thank you for the bug report.