Mailing List Archive


Back to the month index Back to the list index
HELLFiRE (dron@netclub.ru)
Wed, 8 Jan 1997 11:52:11 +0300 

Date: Wed, 8 Jan 1997 11:52:11 +0300
From: HELLFiRE <dron@netclub.ru>
Subject: [mSQL] 2.0 Beta 2 INSERT/UPDATE more bugs
Message-Id: <Pine.3.89.9701081117.A30010-0100000@netclub.ru>

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!