Mailing List Archive


Back to the month index Back to the list index
Gunnar Rxnning (gunnar@candleweb.no)
Mon, 06 Jan 1997 19:16:20 +0100 

Message-Id: <32D14174.41C67EA6@candleweb.no>
Date: Mon, 06 Jan 1997 19:16:20 +0100
From: Gunnar Rxnning <gunnar@candleweb.no>
Subject: [mSQL] msql 2 beta 2 bug

I've found a strange bug in the beta 2 version released today. I get the
following error message every other time I do a insert into my table :
ERROR : Index field "name" cannot be NULL

Here is a script that reproduces the bug :

drop table pubs \p\g
create table pubs (
        name char(32),
        address char(64),
        submitter char(32),
        descr text(256),
        xc int,
        yc int
) \p\g
CREATE UNIQUE INDEX pubs_idx ON pubs (name) \p\g
insert into pubs values ('my','test','prog','bugs',1,2)\p\g
insert into pubs values ('fiasco','test','prog','bugs',1,2)\p\g
insert into pubs values ('three','test','prog','bugs',1,2)\p\g

And here is the system info:

Version Details :-

        msqladmin version 2.0 Beta 2
        mSQL server version 2.0 Beta 2
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform SunOS-4.1.4-Sparc

Configuration Details :-

        Default config file /usr/local/Hughes/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/Hughes/msql2.sock
        mSQL user gunnar
        Admin user root
        Install directory /usr/local/Hughes
        PID file location /usr/local/Hughes/msql2d.pid 

-- 
Gunnar Rxnning (gunnar@candleweb.no) | http://www.candleweb.no/~gunnar/
#include <std.disclaimer>           | http://www.candleweb.no/
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!