• Chris Calender's avatar
    MDEV-15789 - mysqlslap use incorrect table def · d9b159a2
    Chris Calender authored
    The bug arises when one uses --auto-generate-sql-guid-primary (and
    --auto-generate-sql-secondary-indexes) with mysqlslap and also have
    sql_mode=STRICT_TRANS_TABLE.
    
    When using this option, mysqlslap should create a column with varchar(36),
    but it appears to create it as a varchar(32) only. Then if one has
    sql_mode=STRICT_TRANS_TABLES, it throws an error, like:
    
      mysqlslap: Cannot run query INSERT INTO t1 VALUES (...)
      ERROR : Data too long for column 'id' at row 1
    
    Upstream bug report: BUG#80329.
    d9b159a2
mysqlslap.result 7.2 KB