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 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.3
Operating SystemWindows OS
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 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