I recently discovered that the following
create table ttt (
id serial primary key,
txt text
);
show index from ttt
is telling me that there is a primary ke on id column with BTREE
and at the same time, there is another unique index on the id column.
This is redundant.
if the id column had been specified as
id integer auto_increment primary key,
then there is only one primary key
So it looks that there is a bug in the mysql source code.
Could some exper please confirm my opinion?
I am using version 4.1
Kemin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
