DBT2: stmt ERROR: 1406 Data too long for column ‘out_w_city’ at row 1

Another issue with the DBT2 benchmarking suite.

mysql reports SQL STMT: stmt ERROR: 1406 Data too long for column 'out_w_city' at row 1

Just edit the payment stored procedure and change;

DECLARE  out_w_city VARCHAR(10);

To;

DECLARE  out_w_city VARCHAR(20);

Leave a Reply