Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Simply putting the issue raised in http://drupal.org/node/502048 in the bug queue of the Location module. IFNULL is a MySQL-only function, while COALESCE works in both MySQL and PostgreSQL. Similar issue was raised in http://drupal.org/node/319441 as the Comment Subscribe module suffered from the same issue.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | postgreSQL_chokes_on_earth_distance_sql-1008976-2.patch | 729 bytes | IcanDivideBy0 |
Comments
Comment #1
dcostalis CreditAttribution: dcostalis commentedThis is still an issue in the latest 3.x build, and causes the distance filter to break. Changing "IFNULL" to "COALESCE" on line 122 of earth.inc fixes the problem for Postgres
Comment #2
IcanDivideBy0 CreditAttribution: IcanDivideBy0 commentedSince it totally breaks the SQL query, I think this is critical.
Comment #3
Liam MorlandComment #4
podarok#1931088: [META] Fixing tests tests were broken, so triggering to active
Comment #5
podarokbot
Comment #6
podarok#2 commited pushed to 7.x-3.x
thanks!!!
Comment #7
podarokhttp://drupal.org/node/1942736 tagged in alpha release