Bug #89537 Regression in FEDERATED storage engine after GCC 7 fixes
Submitted: 5 Feb 14:34 Modified: 11 Jul 18:53
Reporter: Yura Sorokin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S2 (Serious)
Version:5.7.21, 8.0.4 OS:Any
Assigned to: CPU Architecture:Any

[5 Feb 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 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 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 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 15:17] Umesh Shastry
Hello Yura,

Thank you for the bug report and contribution.

Thanks,
Umesh
[9 Jul 19:16] Paul Dubois
Posted by developer:
 
Fixed in 8.0.13.

An earlier code cleanup caused FEDERATED storage engine failures.
[11 Jul 18:53] Yura Sorokin
Is this fixed in 5.7?
[13 Jul 1:34] Paul Dubois
Posted by developer:
 
Fixed in 5.7.24.