summaryrefslogtreecommitdiff
path: root/docs/database.txt
diff options
context:
space:
mode:
Diffstat (limited to 'docs/database.txt')
-rw-r--r--docs/database.txt11
1 files changed, 11 insertions, 0 deletions
diff --git a/docs/database.txt b/docs/database.txt
index b9fa6ff7..3985b70e 100644
--- a/docs/database.txt
+++ b/docs/database.txt
@@ -186,3 +186,14 @@ MediaWiki does support the following other DBMSs to varying degrees.
More information can be found about each of these databases (known issues,
level of support, extra configuration) in the "databases" subdirectory in
this folder.
+
+------------------------------------------------------------------------
+ Use of GROUP BY
+------------------------------------------------------------------------
+
+MySQL supports GROUP BY without checking anything in the SELECT clause.
+Other DBMSs (especially Postgres) are stricter and require that all the
+non-aggregate items in the SELECT clause appear in the GROUP BY. For
+this reason, it is highly discouraged to use SELECT * with GROUP BY
+queries.
+