Kbase P140183: CREATE VIEW FROM SELECT ... AS uses SELECT list instead of AS clause aliases for column names
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/01/2009 |
|
Status: Unverified
SYMPTOM(s):
CREATE VIEW FROM SELECT ... AS uses SELECT list instead of AS clause aliases for column names
After executing the command
CREATE VIEW MyView
AS SELECT
Customer.CustNum AS CustomerNumber,
Customer.Name AS CustomerName
FROM PUB.Customer
the column names in the resulting view are "CustNum" and "Name" instead of the expected "CustomerNumber" and "CustomerName".
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
CAUSE:
Bug# OE00133311
FIX:
Upgrade to OpenEdge 10.1B01 or later. If upgrading to OpenEdge 101B01 or later is not feasible, then define the column names explicitly in the CREATE VIEW statement instead of using the AS clause. For example:
CREATE VIEW MyView (CustomerNumber, CustomerName)
AS SELECT
Customer.CustNum,
Customer.Name
FROM PUB.Customer