Bug #89537 Regression in FEDERATED storage engine after GCC 7 fixes

• Submitted: 5 Feb 2018 14:34
• Modified: 11 Jul 2018 18:53
• Reporter: Yura Sorokin (OCA)
• Status: Closed
• Category: MySQL Server: Federated storage engine
• Severity: S2 (Serious)
• Version: 5.7.21, 8.0.4
• OS: Any
• CPU Architecture: Any

[5 Feb 2018 14:34] Yura Sorokin

Description:
"1030: Got error 1430 from storage engine" is reported form FEDERATED SE when executing SELECTS involving indexes (e.g 'SELECT * FROM local_table USE INDEX (ba) WHERE a<1 AND b=0').

This is a regression introduced after GCC 7 fixes
https://github.com/mysql/mysql-server/commit/ba1a99c (5.7)
https://github.com/mysql/mysql-server/commit/670bd1d (8.0)

It exists in 5.7 and 8.0 branches - 5.5 and 5.6 are fine.

See also
https://jira.percona.com/browse/PS-1134

How to repeat:
Put the attached 'percona_bug1739734.test' and 'percona_bug1739734.result' into 'mysql-test/suite/federated' folder.

run
'mysql-test/mtr --debug-server percona_bug1739734'

Suggested fix:
Revert changes in 'storage/federated/ha_federated.cc' from
commit ba1a99c (5.7) and commit 670bd1d (8.0)

[5 Feb 2018 14:35] Yura Sorokin

MTR test case file

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: percona_bug1739734.test (application/octet-stream, text), 1014 bytes.

[5 Feb 2018 14:35] Yura Sorokin

MTR result file

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: percona_bug1739734.result (application/octet-stream, text), 955 bytes.

[5 Feb 2018 14:37] Yura Sorokin

Suggested patch

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug89537.patch (application/octet-stream, text), 987 bytes.

[5 Feb 2018 15:17] MySQL Verification Team

Hello Yura,

Thank you for the bug report and contribution.

Thanks,
Umesh

[9 Jul 2018 19:16] Paul DuBois

Posted by developer:
 
Fixed in 8.0.13.

An earlier code cleanup caused FEDERATED storage engine failures.

[11 Jul 2018 18:53] Yura Sorokin

Is this fixed in 5.7?

[13 Jul 2018 1:34] Paul DuBois

Posted by developer:
 
Fixed in 5.7.24.