The query "SELECT MIN(date) AS oldest, MAX(date) AS latest FROM {antispam_counter} ORDER BY date DESC LIMIT 365" in antispam.admin.inc does not work on PostgreSQL because ORDER BY date does not work if date is used in aggregation functions (MIN and MAX). This is related to #1044738: wrong assumption in antispam_counter table queries.

Comments

apaderno’s picture

Title: [PostgreSQL] query in antispam.admin.inc is MySQL specific » Query in antispam.admin.inc is MySQL specific
Version: 7.x-1.0 » 7.x-1.x-dev
Issue summary: View changes