laptop and a wrench

Bug

The GROUP BY SQL clause in data access using cursors does not work as expected.

ArcGIS Pro
Bug ID Number BUG-000159926
SubmittedJuly 18, 2023
Last ModifiedJanuary 6, 2026
Applies toArcGIS Pro
Version foundN/A
Operating SystemWindows OS
Operating System VersionN/A
StatusAs Designed

Additional Information

The GROUP BY clause is an aggregation function, and columns must appear in the selected columns to be used in the aggregation GROUP BY clause. Applying a GROUP BY without aggregation columns such as SUM or MAX is unlikely to produce meaningful results but is possible by passing each column into the postfix, for example, "GROUP BY county, age, name." For examples that pass strings using the Python and keyword, this performs a boolean operation on the two strings, so the final string is returned. For example, test = 'a' and 'b' returns 'b'. Please refer to Python truth value testing available at https://docs.python.org/3/library/stdtypes.html#truth-value-testing for more information.

Steps to Reproduce

Bug ID: BUG-000159926

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options