Kbase P133952: SQL query with qualified wildcard and alias generates error 7519
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2009 |
|
Status: Unverified
SYMPTOM(s):
SQL query with qualified wildcard and alias generates error 7519
Table/View/Synonym not found (7519)
FACT(s) (Environment):
Query has the form:
SELECT <alias or table name>.* FROM <table> <alias>
Example:
SELECT c.* FROM Customer c;
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
Bug# OE00172742
FIX:
None at this time. The following are two suggested workarounds:
1. List all column names instead of using the "*" wildcard.
2. If the resulting query is unambiguous, use "*" without the qualifier