Kbase P42522: Syntax error when querying a long SQL-92 view
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Syntax error (7587) when querying a long, complex SQL-92 view
The view creation has a select statement longer than 2000 characters
The view is created without errors
CAUSE:
Bug 20030916-007
FIX:
Upgrade to service pack 7 or later. If this is not possible, split the query into two views and then create a third view based on these two.