laptop and a wrench

Bug

A query in PostgreSQL omitting a column alias for a computed column passes validation when creating a query layer resulting in an empty attribute table.

Last Published: August 24, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000085650
SubmittedFebruary 25, 2015
Last ModifiedJune 11, 2020
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
Operating SystemWindows
Operating System Version2008 R2
StatusNon-Reproducible

Additional Information

The issue is not reproducible with ArcGIS 10.3.1 for Desktop.

Workaround

Add a column alias to computed columns or subqueries to make valid SQL queries.

Steps to Reproduce

Bug ID: BUG-000085650

Software:

  • ArcSDE/Enterprise Geodatabase

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback