Bug #80259 sql statement "create user if not exists" fails if run twice
| Submitted: | 4 Feb 2016 2:08 | Modified: | 4 Feb 2016 4:33 |
|---|---|---|---|
| Reporter: | Fred Battle | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
| Version: | 5.7.10 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | SQL | ||
[4 Feb 2016 2:08]
Fred Battle
[4 Feb 2016 4:31]
MySQL Verification Team
Hello Fred, Thank you for the report. Observed this with 5.7.10. Thanks, Umesh
[4 Feb 2016 4:33]
MySQL Verification Team
Looks like this is duplicate of Bug #78374, and fixed in upcoming release per changelog: Noted in 5.7.12, 5.8.0 changelogs. For an existing user, CREATE USER IF NOT EXISTS produced an error rather than a warning. Similarly, for an nonexisting user, ALTER USER IF EXISTS produced an error rather than a warning.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 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.