Using Informix Developer Edition (IBM Informix Dynamic Server Version 11.70.FC3DE)
Does anybody know of an issue with the TRUNCATE statement on a fragmented table. When I use the TRUNCATE statement on a table fragmented by round robin the rows in the table are deleted but it doesn't release the extents in the dbspaces.
The TRUNCATE statement works fine on a none fragmented table. I don't have this problem on our production box (11.70.FC2).
I have inspected the restrictions for the TRUNCATE statement in the SQL Guide and I don't think I'm encountering any of the conditions.