After zooming a table column with
ALTER TABLE
where, "new_size" > "old_size" is valid,
- the following SELECT statement SELECT * FROM
WHERE ='value'
- as wells as the call of dbschema -hd
leads to the error: inf750: Invalid distribution format found for
The Informix query optimizer attempts to access the changed column of this table using old statistics information. (Bug in Informix online 6.x/7.x)
SolutionExecute an "UPDATE STATISTICS MEDIUM/HIGH" on the affected columns. Should that not help, please do an "update statistics low for table
before doing an "update statistics medium for table
Additional key words
PTS PTS_BUG PTS_BUG_xxxxx
No comments:
Post a Comment