Mailing List Archive


Back to the month index Back to the list index
Wolfy Su (WolfySu@acer.net)
Thu, 9 Jan 1997 10:37:13 -0000 

Message-Id: <199701090255.KAA20461@m2.acer.net>
From: "Wolfy Su" <WolfySu@acer.net>
Subject: Re: [mSQL] 2.0 Beta 2 INSERT/UPDATE more bugs
Date: Thu, 9 Jan 1997 10:37:13 -0000

> Hmm...few bugs were fixed...more bugs created ;)
>
> CREATE TABLE stat (
> Acct_Session_Id CHAR(255) NOT NULL,
> User_Name CHAR(255),
> Client_Id CHAR(16),
> Client_Port_Id INT
> [etc skiped] )
> CREATE UNIQUE INDEX idx1 ON stat ( Acct_Session_Id ) \g
>
> query:
> insert into stat (Acct_Session_Id) values ('A0000F2C')
> Error : Field "Acct_Session_Id" cannot be null
>
> another query:
> UPDATE stat SET Client_Port_Id = 0 WHERE Acct_Session_Id = 'A0000F2B'
> (value 'A0000F2B' exists)
> Error : Index condition for "Acct_Session_Id" cannot be NULL
>
> Running MSQL 2.0 beta 2 via localhost and remote
> Linux 2.0.24 i586
>
> Any suggestions how to fix it?
>
--------------------------------------------------------------------------
> 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!
Hi guy!
    I think you can try to download my patch at
http://www.acer.net/~wolfy/msqldb.c
. I use my patch but doesn't have such question like you post. try it!!!
Good luck!
----------------------------------------------------------
| My Company: AcerNet Inc In Taiwan |
| My Email: WolfySu@acer.net |
| My href: http://www.acer.net/~wolfy |
| My Addr: 4F. 132 Sec. 1, Tun Hua S. Road, |
| Taipei 106, Taiwan, R.O.C. |
| My Tel: 886-2-7317588-233 |
----------------------------------------------------------
--------------------------------------------------------------------------
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!