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