Bug #106229 ndbinfo_plans test case unstable

• Submitted: 20 Jan 2022 17:09
• Modified: 3 Mar 2022 18:37
• Reporter: Mikael Ronström
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.28
• OS: Any
• CPU Architecture: Any

[20 Jan 2022 17:09] Mikael Ronström

Description:
The test case ndbinfo_plans has a lot of EXPLAIN statements which consists of
output of floating point values.

The floating points can sometimes be vary even on the same platform in
different runs, even more with different platforms.

How to repeat:
./mtr --suite=ndb ndbinfo_plans

Will probably work most of the time, but change some values in NdbInfoTables.cpp
to generate different costs and this can happen.

Suggested fix:
To stabilise MTR tests using EXPLAIN one can put the following before the EXPLAIN output.

--replace_regex /cost=[0-9]+\.[0-9]+/cost=#/

[21 Jan 2022 6:48] MySQL Verification Team

Thanks for the report Mikael,

all best
Bogdan Kecman

[3 Mar 2022 18:37] Jon Stephens

Fixed in NDB 8.0.29.

Test case only, no changelog entry needed.

Closed.