laptop and a wrench

Bogue

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

ArcGIS Pro
Numéro d’ID de bogue BUG-000159926
EnvoiJuly 18, 2023
Dernière modificationJanuary 6, 2026
S’applique àArcGIS Pro
Version trouvéeN/A
Système d’exploitationWindows OS
Version du système d’exploitationN/A
StatutAs Designed

Informations supplémentaires

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.

Étapes pour reproduire

ID de bogue: BUG-000159926

Logiciel:

  • ArcGIS Pro

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement