>Description:
When creating a table with not null in an auto_increment field, mysql ignores the not null
>How-To-Repeat:
create table temptemp (ordid int not null auto_increment, ord varchar(50) not null,
primary key (ordid), index(ord,ordid));
show fields from temptemp;
+-------+-------------+------+-----+---------+----------------+---------------------------------+
| Field | Type | Null | Key | Default | Extra | Privileges
|
+-------+-------------+------+-----+---------+----------------+---------------------------------+
| ordid | int(11) | | PRI | NULL | auto_increment |
select,insert,update,references |
| ord | varchar(50) | | MUL | | |
select,insert,update,references |
+-------+-------------+------+-----+---------+----------------+---------------------------------+
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Thomas Lund
>Organization:
>MySQL support: licence
>Synopsis: create bug in 3.23.4
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.4-alpha (Homemade MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 7.11 Distrib 3.23.4-alpha, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.23.4-alpha-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 3 days 2 hours 7 sec
Threads: 2 Questions: 4334554 Slow queries: 1 Opens: 8736 Flush tables: 1 Open
tables: 63
>Environment:
System: Linux sol.id.dk 2.2.12 #2 Wed Sep 1 17:17:36 GMT+1 1999 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='egcs' CFLAGS=' -O6 -fomit-frame-pointer' CXX='egcs' CXXFLAGS='
-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Aug 30 11:35 /lib/libc.so.6 -> libc-2.1.1.so
-rwxr-xr-x 1 root root 4016683 Apr 16 21:48 /lib/libc-2.1.1.so
-rw-r--r-- 1 root root 19533408 Apr 16 21:48 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Apr 16 21:48 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--with-charset=danish --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--mandir=/usr/man '--with-comment=Homemade MySQL RPM'
Perl: This is perl, version 5.005_03 built for i386-linux
