php - MySQL 5.0.12 - 列表不在 GROUP BY 子句中并且包含非聚合列？

Question

为什么我在 mysqlnd 5.0.12-dev 上出现以下错误:

1055 - Expression #29 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_name.p2.url' which is not

functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

查询:

SELECT p.* , 
    p2.article_id AS parent_id  , 
    p2.url AS parent_url  , 
    p3.article_id AS parent_parent_id  , 
    p3.url AS parent_parent_url  , 
    p3.title AS parent_parent_title   

FROM article AS p  
LEFT JOIN article AS p2  
ON p2.article_id = p.parent_id  
AND p.article_id <> p2.article_id  

LEFT JOIN article AS p3  
ON p3.article_id = p2.parent_id  
AND p2.article_id <> p3.article_id  

WHERE p.url = 'contact'  
AND p.type = 'page'  
AND p.hide = '0'  
GROUP BY p.article_id  
ORDER BY p.backdated_on DESC 

该查询在 mysqlnd 5.0.11-dev 上正常工作。

有什么想法吗？

Answer 1

看来您的 group by 子句仅包含 p.article_id而您的选择有

p.* , 
    p2.article_id AS parent_id  , 
    p2.url AS parent_url  , 
    p3.article_id AS parent_parent_id  , 
    p3.url AS parent_parent_url  , 
    p3.title AS parent_parent_title

要么将所有选择查询列包含在 group by 中，要么将它们包装在聚合函数中，例如 sum()、count()、max() 等。您实际上想从这个查询中得到什么？