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!
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.