SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
first thing i am not sure, if this is a bug or I am missunderstanding
something.
It is possible to insert multiple records in a database, having the same
unique key,
if the unique key or one of its fields contain NULL.
I know that NULL compares to itself as not equal, but I dont know if
this
should happen on a unique Key.
The documentation did not seem to say something about this
>How-To-Repeat:
create the following table (MyISAM)
create table times (
id int(11) not null,
start integer unsigned not null,
stop integer unsigned, # NULL is allowed
flags integer not null default 0,
unique (start, stop ,id)
);
insert into times (id,start,stop,flags) values (1,1000,null,0);
Repeat this insert statement.
you can insert the same dataset as often as you want. This works only if
one of the fields in the UNIQUE index is NULL.
This also happens under mysql 3.23.38
>Fix:
>Submitter-Id: <submitter ID>
>Originator: root
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-3.23.34 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.17 Distrib 3.23.34, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.34
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 18 days 1 hour 24 min 42 sec
Threads: 1 Questions: 57091 Slow queries: 0 Opens: 450 Flush tables:
1 Open tables: 64
Queries per second avg: 0.037
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux mfriebe1 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586
unknown
Architecture: i586
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
-mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions
-fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 5 02:40 /lib/libc.so.6
-> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000
/lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /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=/
--with-extra-charsets=complex
--exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info
--includedir=/usr/include --mandir=/usr/man
--without-berkeley-db --without-innobase '--with-comment=Official MySQL
RPM'
--
Martin Friebe
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
