• Annamalai Gurusami's avatar
    Bug #13453036 ERROR CODE 1118: ROW SIZE TOO LARGE - EVEN · 4a3d325d
    Annamalai Gurusami authored
    THOUGH IT IS NOT.
    
    The following error message is misleading because it claims 
    that the BLOB space is not counted.  
    
    "ERROR 1118 (42000): Row size too large. The maximum row size for 
    the used table type, not counting BLOBs, is 8126. You have to 
    change some columns to TEXT or BLOBs"
    
    When the ROW_FORMAT=compact or ROW_FORMAT=REDUNDANT is used,
    the BLOB prefix is stored inline along with the row.  So 
    the above error message is changed as follows depending on
    the row format used:
    
    For ROW_FORMAT=COMPRESSED or ROW_FORMAT=DYNAMIC, the error
    message is as follows:
    
    "ERROR 42000: Row size too large (> 8126). Changing some
    columns to TEXT or BLOB may help. In current row format, 
    BLOB prefix of 0 bytes is stored inline."
    
    For ROW_FORMAT=COMPACT or ROW_FORMAT=REDUNDANT, the error
    message is as follows:
    
    "ERROR 42000: Row size too large (> 8126). Changing some
    columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or 
    ROW_FORMAT=COMPRESSED may help. In current row
    format, BLOB prefix of 768 bytes is stored inline."
    
    rb://1252 approved by Marko Makela
    4a3d325d
innodb.result 98 KB