laptop and a wrench

Bug

A drawing error with an invalid SQL query is received when creating a join using the Add Join tool on a feature layer with definition query that is utilizing the 'OR' or 'AND' operators.

Last Published: November 27, 2017 ArcGIS for Desktop
Bug ID Number BUG-000108997
SubmittedOctober 21, 2017
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.5.1
Operating SystemWindows OS
Operating System Version2012 R2
StatusWill Not Be Addressed

Additional Information

We apologize that we were unable to address this issue within the current product support cycle.  If the issue continues to affect your work in a supported release, please contact Technical Support.

Workaround

-Creating a join using the 'Join data' dialog box does not give the same error and the SQL query is not altered. -Right-click the feature layer FC1. -Click Join and Relates. -> Join.- Using the Join Field tool also does not give the error and SQL query is not altered.

Steps to Reproduce

Bug ID: BUG-000108997

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options