diff options
| author | Chris Calender <chris@mariadb.com> | 2018-04-17 15:00:15 -0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2018-06-07 17:21:14 +0400 |
| commit | d9b159a2027c56c5c87385cfe1ae43b8c73a97b6 (patch) | |
| tree | b459a45cea9cca0f5183aa36dd601a4bda7f7e85 /mysql-test/t/mysqlslap.test | |
| parent | 75b4eb5cc969a1f5fc221d03c62987b8e57d6332 (diff) | |
| download | mariadb-git-d9b159a2027c56c5c87385cfe1ae43b8c73a97b6.tar.gz | |
MDEV-15789 - mysqlslap use incorrect table def
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.
Diffstat (limited to 'mysql-test/t/mysqlslap.test')
| -rw-r--r-- | mysql-test/t/mysqlslap.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/mysqlslap.test b/mysql-test/t/mysqlslap.test index c49c4ab3d7d..81115d59d09 100644 --- a/mysql-test/t/mysqlslap.test +++ b/mysql-test/t/mysqlslap.test @@ -80,3 +80,11 @@ DROP DATABASE bug58090; --exec $MYSQL_SLAP --create-schema=test --init-command="CREATE TABLE t1(a INT)" --silent --concurrency=1 --iterations=1 DROP TABLE t1; + +--echo # +--echo # Bug MDEV-15789 (Upstream: #80329): MYSQLSLAP OPTIONS --AUTO-GENERATE-SQL-GUID-PRIMARY and --AUTO-GENERATE-SQL-SECONDARY-INDEXES DONT WORK +--echo # + +--exec $MYSQL_SLAP --concurrency=1 --silent --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --create-schema=slap + +--exec $MYSQL_SLAP --concurrency=1 --silent --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-secondary-indexes=1 --create-schema=slap |