MySQL规则00108优化

[waterdrink]

版本信息（Version）

v4.25.02

问题描述（Describe）

以下sql期望触发MySQL规则，实际没有
SELECT postid AS Post_Link, mdi.numimages AS numMarkdownImages, hi.numimages AS NumHtmlImages, hi.viewcount AS ViewCount, hi.score AS Score, hi.creationdate AS CreationDate FROM ( SELECT postid, LENGTH(markdown) - LENGTH(REPLACE(markdown, '![', 'X')) AS numimages FROM ( SELECT postid, markdown FROM ( SELECT ph.postid AS postid, ph.text AS markdown FROM posthistory AS ph WHERE ph.postid IN ( SELECT postid FROM ( SELECT postid FROM posthistory WHERE posthistorytypeid IN (2,5,8) ) AS sub1 ) ) AS sub2 ) AS sub3 ) AS mdi JOIN ( SELECT id, creationdate, score, viewcount, LENGTH(body) - LENGTH(REPLACE(body, '<img src', '<img sr')) AS numimages FROM ( SELECT * FROM posts ) AS sub4 ) AS hi ON mdi.postid = hi.id WHERE mdi.numimages > 0 AND mdi.numimages > hi.numimages

截图或日志（Log）

如何复现（To Reproduce）

问题原因

解决方案

变更影响面

受影响的模块或功能

外部引用的潜在问题或风险

版本兼容性

测试建议