
没在模型使用软删除,生成的查询SQL如下,是正确的
SELECT * FROM ( SELECT * FROM wx_article_1 UNION SELECT * FROM wx_article_2 UNION SELECT * FROM wx_article_3 UNION SELECT * FROM wx_article_4 UNION SELECT * FROM wx_article_5) AS Article ORDER BY `id`在模型开启软删除后,生成的查询SQL如下,是错误的SELECT * FROM ( SELECT * FROM wx_article_1 UNION SELECT * FROM wx_article_2 UNION SELECT * FROM wx_article_3 UNION SELECT * FROM wx_article_4 UNION SELECT * FROM wx_article_5) AS Article WHERE `( SELECT * FROM wx_article_1 UNION SELECT * FROM wx_article_2 UNION SELECT * FROM wx_article_3 UNION SELECT * FROM wx_article_4 UNION SELECT * FROM wx_article_5) AS Article`.`delete_time` IS NULL ORDER BY `id`正确的SQL应该是:SELECT * FROM ( SELECT * FROM wx_article_1 UNION SELECT * FROM wx_article_2 UNION SELECT * FROM wx_article_3 UNION SELECT * FROM wx_article_4 UNION SELECT * FROM wx_article_5) AS Article WHERE `Article`.`delete_time` IS NULL ORDER BY `id`不知道是我哪里配置问题,还是框架的BUG 最佳答案