BUG-000085345 for ArcSDE/Enterprise Geodatabase

Bug-ID-Nummer	BUG-000085345
Eingereicht	February 17, 2015
Zuletzt geändert	January 28, 2021
Gilt für	ArcSDE/Enterprise Geodatabase
Gefunden in Version	10.1
Status	Will Not Be Addressed

Zusätzliche Informationen

This is expected behavior. The LIKE operator is an operator for character strings. If it is used against a numeric field, the data must be converted to a string. Some databases support implicit conversion from numeric to text, some do not. If the data is pulled from a single database, the query validation can be pushed down to the database. In the case of data being pulled from multiple sources, the validation cannot be pushed to the database and client rules are used instead, and character string operators such as LIKE are flagged as invalid by client-side validation. To query character matches like this the data should be stored as text, or the query should be written using >= and <= operators.

Schritte zur Reproduzierung

Bug-ID: BUG-000085345

Software:

ArcSDE/Enterprise Geodatabase

Hilfe von ArcGIS-Expert*innen erhalten

Technischen Support kontaktieren

Die Esri Support-App herunterladen

Zu den Download-Optionen

Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.

Zusätzliche Informationen

Schritte zur Reproduzierung

Weitere Informationen zu diesem Thema erkunden