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.

CommentFileSizeAuthor
#2 postgreSQL_chokes_on_earth_distance_sql-1008976-2.patch729 bytesIcanDivideBy0

Comments

dcostalis’s picture

dcostalis commented
Version: 6.x-3.x-dev » 7.x-3.x-dev

This 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

IcanDivideBy0’s picture

IcanDivideBy0 commented
Priority: Normal » Critical
Status: Active » Needs review
StatusFileSize
new postgreSQL_chokes_on_earth_distance_sql-1008976-2.patch729 bytes

Since it totally breaks the SQL query, I think this is critical.

liam morland’s picture

liam morland
Primary language English
Location Ontario, CA 🇨🇦
commented
Issue tags: +PostgreSQL
podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
commented
Priority: Critical » Normal
Status: Needs review » Active

#1931088: [META] Fixing tests tests were broken, so triggering to active

podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
commented
Status: Active » Needs review

bot

podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
commented
Status: Needs review » Fixed

#2 commited pushed to 7.x-3.x
thanks!!!

podarok’s picture

podarok
🇺🇦 he/him/his
Primary language Ukrainian
Location Ukraine
commented

http://drupal.org/node/1942736 tagged in alpha release

Status: Fixed » Closed (fixed)
Issue tags: -PostgreSQL

Automatically closed -- issue fixed for 2 weeks with no activity.

Issue tags: +PostgreSQL

Restoring issue tags, see #2125755: System messages removed all issue tags during D7 upgrade.