Kbase P123428: First character of the first field of an SQL query is corrupted if the length of subsequent fields e
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/26/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
SYMPTOM(s):
Executing SQL query
First character of the first field of an SQL query is corrupted
Example, where PD is the correct value:
<D 11479.049115447229983720204
2D 16830.896523966903768605020
PD 31044.693328379734621268998
PD 24831.706643756272623369117
PD 11895.42000000
PD 50984.785743955706571516291
PD 45684.254522093824255605693
PD 61952.470288624787775891341
?D 56176.994906621392190152801
Corruption does not affect all rows
Corruption only affects the first character of the first field
Size of second field exceeds 32K
Using ROUND function to reduce the field size does not always work
CAUSE:
This is a known issue being investigated by Development
FIX:
Implement a dummy field as the first field in the query. This field will be corrupted but data in other fields will not. For example:
SELECT 'aa', custnum FROM pub.customer