Bug #57951 Can´t add primary key to existing table
| Submitted: | 3 Nov 2010 13:37 | Modified: | 18 Nov 2010 20:30 |
|---|---|---|---|
| Reporter: | Marian Zsemlye | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
| Version: | 5.2.29 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Alter table; add primary key | ||
[3 Nov 2010 13:37]
Marian Zsemlye
[3 Nov 2010 13:49]
Peter Laursen
Obviously this will fail "NOT NULL DEFAULT NULL" Peter (not a MySQL person)
[3 Nov 2010 17:02]
Valeriy Kravchuk
Verified on Mac OS X. Obviously setting column as PK (and, thus, NOT NULL) should remove DEFAULT NULL setting, if any is present.
[18 Nov 2010 20:30]
Alfredo Kojima
duplicate of bug #55456
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.041 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.