laptop and a wrench

Bug

Add Query Layer does not recognize the NOT NULL constraint.

Last Published: June 11, 2019 ArcGIS for Desktop
Bug ID Number BUG-000116399
SubmittedAugust 29, 2018
Last ModifiedSeptember 19, 2024
Applies toArcGIS for Desktop
Version found10.5
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusKnown Limit

Additional Information

This is an Oracle limitation that a not null or a check constraint cannot be added on a view created based on a union for two tables. Describe the view itself from Oracle, the not null constraints are already gone: SQL> desc vtestnull Name Null? Type ----------------------------------------- -------- ---------------------------- MANDANT NUMBER(38) RISIKO_ID NUMBER(38) VN NUMBER(38)

Workaround

This is a display problem. No workaround required.

Steps to Reproduce

Bug ID: BUG-000116399

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