-
magnus.blaudd@oracle.com authored
- two different SELECT DISTINCT queries fail because they use ORDER BY on a column not in select list, this is not allowed with the new ONLY_FULL_GROUP_BY sql_mode. - Fix by turning ONLY_FULL_GROUP_BY off and then back on after the queries - Re WL2489 "better only_full_group_by"
magnus.blaudd@oracle.com authored- two different SELECT DISTINCT queries fail because they use ORDER BY on a column not in select list, this is not allowed with the new ONLY_FULL_GROUP_BY sql_mode. - Fix by turning ONLY_FULL_GROUP_BY off and then back on after the queries - Re WL2489 "better only_full_group_by"
Loading