BUG-000085345 for ArcSDE/Enterprise Geodatabase

不具合 ID 番号	BUG-000085345
送信されました	February 17, 2015
最終更新日	January 28, 2021
適用対象	ArcSDE/Enterprise Geodatabase
見つかったバージョン	10.1
ステータス	Will Not Be Addressed

参考情報

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.

再現の手順

不具合 ID: BUG-000085345

ソフトウェア:

ArcSDE/Enterprise Geodatabase

ArcGIS の専門家からヘルプを受ける

テクニカルサポートへのお問い合わせ

Esri Support アプリのダウンロード

ダウンロードオプションに移動

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

参考情報

再現の手順

このトピックについてさらに調べる