不具合
Query with LIKE operator returns an error, "Invalid SQL statement was used" on a joined feature class.
| 不具合 ID 番号 | BUG-000085345 |
|---|---|
| 送信されました | February 17, 2015 |
| 最終更新日 | June 5, 2024 |
| 適用対象 | 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 アプリのダウンロード