projects / GitHub / WoltLab / WCF.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ce16380) | patch
Fix selection of related articles for old MySQL versions
authorTim Düsterhus <duesterhus@woltlab.com>
Mon, 24 Aug 2020 09:54:19 +0000 (11:54 +0200)
committerTim Düsterhus <duesterhus@woltlab.com>
Mon, 24 Aug 2020 10:22:17 +0000 (12:22 +0200)
commit8c586d9a4d2cd6991bd362651fd1049421a5e888
tree027a3846ab8e365f2021b7fd205945ff0b57b8e3tree | snapshot (tar.gz zip)
parentce163806c468763f6e3b04e4bf7318c6f8035737commit | diff
Fix selection of related articles for old MySQL versions

MySQL < 5.7 and apparently MariaDB up to at least 10.3 is unable to deduce
that there can only be exactly a single row from the `article` table, because
it is functionally dependent on `tag_to_object.objectID`.

Help them out by using `MAX` which effectively does nothing, because we're
taking the `MAX` of a single item.

Fixes #3528.
wcfsetup/install/files/lib/page/AbstractArticlePage.class.php diff | blob | blame | history
WoltLab Suite Core (previously WoltLab Community Framework)