在mysql8.0.16下执行以下查询语句会报“Lost connection to MySQL server during query ”错误。
WITH T_USER_TMP AS (
SELECT
TU.USER_ID
FROM T_USER TU
LIMIT 1, 20
)
SELECT
A.*
FROM
( SELECT A.USER_ID FROM T_USER_TMP A ) A
LEFT JOIN ( SELECT B.USER_ID, COUNT( 1 ) AS COUNT FROM T_USER_TMP B GROUP BY B.USER_ID ) B ON A.USER_ID = B.USER_ID
关键出现在“LIMIT 1, 20”这一句,加上就报,不加就不报。
后来升级到8.0.18就正常了。
升级(Centos6.8):
service mysqld stop
yum -y update
(我的是使用yum安装的,所以这样升的级)