Bug #6471 auto_increment example with groups just does not work any more!
| Submitted: | 5 Nov 2004 21:23 | Modified: | 5 Nov 2004 23:22 |
|---|---|---|---|
| Reporter: | Mircea LUTIC | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
| Version: | 4.1.7 | OS: | Windows (winxp) |
| Assigned to: | CPU Architecture: | Any |
[5 Nov 2004 22:00]
Mircea LUTIC
I just noticed this does not happen for type=myisam; It may depend on the storage engine.
[5 Nov 2004 22:02]
Mircea LUTIC
I re-read the doc and it says indeed that this only works for MyISAM and BDB tables. I have been playing with memory tables (never did that before). Sorry.
[5 Nov 2004 23:22]
Paul DuBois
Closed per poster report.
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.
Description: The auto_increment example with groups just does not work any more! Id used to. Now I got 4.1.7 it doesn't work any more. I just happen to need this exact thing. mysql> CREATE TABLE animals ( -> grp ENUM('fish','mammal','bird') NOT NULL, -> id MEDIUMINT NOT NULL AUTO_INCREMENT, -> name CHAR(30) NOT NULL, -> PRIMARY KEY (grp,id) -> ); ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key How to repeat: I just copied the example in the doc & pasted it into mysql cmd line. Suggested fix: make it work...