为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:3.0.3
- 【问题描述】:我在tidb中使用以下SQL:
SELECT sfv.id AS subject_form_value_id, COUNT(iv.id) total_item_value_id, ( CASE WHEN iv.add_item_type IN(3,6) THEN 1 ELSE NULL END ) total_saved_item_value_id FROM edc.edc_subject_form_value sfv, edc.edc_subject_item_value iv WHERE sfv.id = iv.subject_form_value_id AND sfv.save_date IS NULL GROUP BY sfv.id;
结果报错信息如下: 错误代码: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘edc.iv.add_item_type’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
请帮忙看一下如何解决这个问题?