Crash mysqld 8.0.18 when run explain analyze with recursive cte
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Lalit Choudhary August 18, 2020 at 11:43 AM
Issue not reproduciable with latest PS version Server version: 8.0.20-11 Percona Server (GPL), Release 11, Revision 159f0eb
Lalit Choudhary March 18, 2020 at 8:54 AM
Not reproduciable with the upstream mysql version.
mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)
1 row in set (0.00 sec)
Lalit Choudhary March 18, 2020 at 8:53 AM
Hi Max,
Thank you for the report and test case.
Verified as described with PS 8.0.18
I am working with Percona Server 8.0.18-9 and i have crash
Steps for reproduce
1. docker run -d --name percona-80 -eMYSQL_ROOT_PASSWORD=123 -d percona:8.0.18-9
2. login to mysql and do query
mysql -uroot -p123 -e 'explain analyze WITH RECURSIVE sequence AS ( SELECT 0 UNION ALL SELECT n + 1 FROM sequence WHERE n <= 10 ) SELECT n FROM sequence'
Enter password:
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
server crash immediately with this stack trace
native mysql 8.0.19 don't affected of this bug