diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-01-19 10:35:04 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-01-19 10:35:04 +0100 |
| commit | f551e16e21f029d84336d510115627a6cb043c48 (patch) | |
| tree | b4f5f1726e394c19b47438ecb4c082d52865fc5f | |
| parent | 09ee27d03df1fa8fe86fbc9489cc823180160b92 (diff) | |
Fixed 2022_01_18_07_world_2020_06_26_06_world.sql with sql_mode=ONLY_FULL_GROUP_BY
| -rw-r--r-- | sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql b/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql index 9ad0b083530..b4d7d1aeccd 100644 --- a/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql +++ b/sql/updates/world/master/2022_01_18_07_world_2020_06_26_06_world.sql @@ -6,7 +6,7 @@ FROM `creature` c INNER JOIN ( SELECT - ctm.CreatureDisplayID AS CreatureDisplayID, + SUM(ctm.CreatureDisplayID) AS CreatureDisplayID, -- SUM works around GROUP BY requirementof sql_mode=ONLY_FULL_GROUP_BY, we can do this because we are selecting only 1 row ctm.CreatureID AS CreatureID FROM creature_template_model ctm |