The arcpy.da.SearchCursor queries produce inconsistent results if ordering is used.
Last Published: December 10, 2015ArcGIS for Desktop
Bug ID Number
November 5, 2015
November 24, 2020
ArcGIS for Desktop
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
Unable to reproduce
Remove the SQL postfix and use the Python sorted method instead of ORDER BY. cursor = sorted(arcpy.da.SearchCursor(fc_path, search_fields, where))