Kbase P119338: SQL: Error (7524) executing SQL CREATE VIEW statement with the AS option in the column list clause.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/2/2009 |
|
Status: Verified
SYMPTOM(s):
SQL: Error (7524) executing SQL CREATE VIEW statement with the AS option in the column list clause.
=== SQL Exception 1 ===
SQLState=42S21
ErrorCode=-20010
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Duplicate column specification (7524)
Duplicate column specification (7524)
The error is generated executing an SQL CREATE VIEW using the following syntax:
CREATE VIEW
ViewName
AS SELECT
Customer.CustNum AS alpha,
Order.CustNum AS Beta
FROM
PUB.Customer,
PUB.Order
WHERE
Customer.CustNum = Order.CustNum;
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.0B
OpenEdge 10.1A
OpenEdge 10.1B
CAUSE:
Bug# OE00133311
FIX:
Upgrade to OpenEdge 10.1B01 or later.
If upgrading to OpenEdge 10.1B01 or later is not feasible, use the CREATE VIEW statement without the AS option. For example:
CREATE VIEW
ViewName (alpha, Beta)
AS SELECT
Customer.CustNum,
Order.CustNum
FROM
PUB.Customer,
PUB.Order
WHERE
Customer.CustNum = Order.CustNum;