Mailing List Archive


Back to the month index Back to the list index
sbeer@ibm.net
Wed, 08 Jan 97 10:19:02 +0100 

Message-Id: <9701081521.AA0037@YOUR-HOST-NAME>
Date: Wed, 08 Jan 97 10:19:02 +0100
From: sbeer@ibm.net
Subject: Re: [mSQL] 2.0 Beta 2 INSERT/UPDATE more bugs

You wrote:
>
> 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)
How can this value exist if you cannot INSERT? Obviously we are missing some
more information about what works and what doesn't.

//----------------------------------------------------------
// Steve Beer
// sbeer@ibm.net
--------------------------------------------------------------------------
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!