1055 - Expression # 1 of the ORDER BY is not in GROUP BY clause and the contains nonaggregated column 'which is not functionally dependent on the columns in GROUP BY clause. This is incompatible with sql_mode=only_full_group_by,
Modify the data
(Err) 9500 ws-transaction too large, the size: 104857974
CodePudding user response:
What you mean? Don't understand,,,Disorderly, bless for you
CodePudding user response:
Tidb. Toml add:Sql_mode="STRICT_TRANS_TABLES NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
CodePudding user response:
Tidb. Toml add:Sql_mode="STRICT_TRANS_TABLES NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"
I add in tidb toml first line, or quote this is incompatible with sql_mode=only_full_group_by
Where sql_mode configuration files to add