Bug #80987 | mysqlslap auto-generate-sql-guid-primary | ||
---|---|---|---|
Submitted: | 7 Apr 2016 7:03 | Modified: | 7 Apr 2016 7:44 |
Reporter: | Ted Wennmark | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Command-line Clients | Severity: | S3 (Non-critical) |
Version: | 5.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[7 Apr 2016 7:03]
Ted Wennmark
[7 Apr 2016 7:44]
MySQL Verification Team
Hi Ted, Thank you for the report. Could you please confirm the exact 5.7 build you are using for tests? Imho, this issue was fixed in 5.7.8 post Bug #55265. Also, this can be confirmed from schema inspection in 5.7.11: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.11: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 22 Server version: 5.7.11 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show variables like 'sql_mode'; +---------------+---------------------------------------+ | Variable_name | Value | +---------------+---------------------------------------+ | sql_mode | STRICT_TRANS_TABLES,STRICT_ALL_TABLES | +---------------+---------------------------------------+ 1 row in set (0.00 sec) mysql> desc mysqlslap.t1; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | id | varchar(36) | NO | PRI | NULL | | | id0 | varchar(36) | YES | UNI | NULL | | | id1 | varchar(36) | YES | UNI | NULL | | | intcol1 | int(32) | YES | | NULL | | | charcol1 | varchar(128) | YES | | NULL | | +----------+--------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) mysql> For 5.6, issue still exists as noted in Bug #80329 Thanks, Umesh
[7 Apr 2016 7:56]
Ted Wennmark
Sorry, did not see that bug report. Worked good with 5.7.11 Thanks!