Thread Details

This query works in the console, but not in SOQL Studio: 

SELECT COUNT_DISTINCT(City__c) FROM property__c

The example is from the Dreamhouse test data.
Thank you,

Bradley

I notice that Max also needs attention:  this query fails with "Object reference not set to an instance of an object"

SELECT MAX(Status__c), Broker__r.Name
FROM Property__c
GROUP BY Broker__r.Name
HAVING MAX(status__c) = 'Closed'

Hi Bradley,

These issues have the same root cause as the count(field) issue you reported earlier.  All aggregate functions were affected except count(), as you reported, and all are fixed in the next release of SOQL Studio, due out in March.

This issue has been resolved in SOQL Studio 2021.1.290, released Monday, 3/15/2021