Kbase 21645: Error Inconsistent types (7481) with SQL-92 queries
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/01/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.0x
FACT(s) (Environment):
Progress 9.1A
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
Inconsistent types (7481)
Using numeric functions
SQL-92
Can't upgrade to Progress 9.1C
CAUSE:
There are some problems with SQL-92 functions that manipulate numbers and can lead to the error message. For example, the following query will fail if executed against sports2000 database on Progress 9 prior to 9.1C:
SELECT DECODE(ADJUSTMENT,0,0.0, amount / adjustment)
FROM pub.invoice
WHERE adjustment <> 0
FIX:
As a workaround, change the query to avoid the usage of some numeric functions whenever possible.