gnu-social/plugins/TagCloud/lib
Alexei Sorokin e902a9bdfc [DATABASE] Check SQL boolean values with "IS TRUE"
This way UNKNOWN (NULL) explicitly turns to FALSE when three-valued logic is
reduced to binary.
In pgsqlschema, however, use "IS FALSE" as boolean attributes in pg_index are
non-nullable, there is no outer join and there's no clear preference for NULL
reduction.

Over-complicated constructions in TagCloud queries have been simplified, which
should not affect their performance.

Additionally, in TagCloud's lib/subscriptionspeopleselftagcloudsection.php
a typing mistake in an equi-join of "profile_tag" and "profile_list" on
"tagger" was fixed.
That regression was introduced in f446db8e2a
2021-07-16 19:44:37 +01:00
..
attachmenttagcloudsection.php TagCloud turned into plugin (performance issues on large installs) 2016-08-27 15:24:25 +02:00
grouptagcloudsection.php [DATABASE] Consistently use the "LIMIT $limit OFFSET $offset" syntax 2021-07-16 19:44:35 +01:00
inboxtagcloudsection.php [DATABASE] Consistently use the "LIMIT $limit OFFSET $offset" syntax 2021-07-16 19:44:35 +01:00
personaltagcloudsection.php [DATABASE] Consistently use the "LIMIT $limit OFFSET $offset" syntax 2021-07-16 19:44:35 +01:00
publictagcloudsection.php [DATABASE] Consistently use the "LIMIT $limit OFFSET $offset" syntax 2021-07-16 19:44:35 +01:00
subpeopletagcloudsection.php [DATABASE] Consistently use the "LIMIT $limit OFFSET $offset" syntax 2021-07-16 19:44:35 +01:00
subscriberspeopleselftagcloudsection.php [DATABASE] Check SQL boolean values with "IS TRUE" 2021-07-16 19:44:37 +01:00
subscriberspeopletagcloudsection.php [DATABASE] Check SQL boolean values with "IS TRUE" 2021-07-16 19:44:37 +01:00
subscriptionspeopleselftagcloudsection.php [DATABASE] Check SQL boolean values with "IS TRUE" 2021-07-16 19:44:37 +01:00
subscriptionspeopletagcloudsection.php [DATABASE] Check SQL boolean values with "IS TRUE" 2021-07-16 19:44:37 +01:00
tagcloudsection.php TagCloud turned into plugin (performance issues on large installs) 2016-08-27 15:24:25 +02:00