Kbase P121614: A UNION between two SQL-92 queries causes error 7498
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1E
SYMPTOM(s):
A UNION between two SQL-92 queries causes error 7498
Invalid number string (7498)
The resultset of the UNION is between a character column and an integer column
There is no error in Progress 9.1D FCS
CHANGE:
Upgraded from Progress 9.1D FCS
CAUSE:
The SQL-92 engine cannot perform a UNION between two different data-types.
FIX:
When performing a UNION, the columns between the queries have to be in the same order and of the same data type.