2594175 - Table with compressed lob column uses more space when populating table via view - SAP ASE

• Table with compressed text column and
• lob_compression = 0
• sp_spaceused shows more space used when data is inserted through the view rather than directly into the table:
  
  
• Data inserted directly into the table:
  sp_spaceused myTable, 1
  go
  

  index_name      size         reserved         
  -------------------- ------------  -------------
  idx1                         8 KB        64 KB           
  tmyTable            804 KB     832 KB        
  
  name          rowtotal    reserved   data   index_size   
  -------------- ------------- -------------- --------  --------------
  myTable            200      928 KB   8 KB    812 KB

• Same data inserted into the table through the view
  

  sp_spaceused myTable, 1
  go

  index_name      size         reserved         
  -------------------- ------------  -------------
  idx1                         8 KB        64 KB           
  tmyTable          4804 KB    4848 KB        
  
  name          rowtotal    reserved   data   index_size   
  -------------- ------------- -------------- --------  --------------
  myTable            200     4944 KB  8 KB   4812 KB

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem