Mailing List Archive


Back to the month index Back to the list index
Alvaro de la Hera Martinez (alvaro@i2000.es)
Wed, 18 Sep 1996 16:12:15 -0100 

Date: Wed, 18 Sep 1996 16:12:15 -0100
From: Alvaro de la Hera Martinez <alvaro@i2000.es>
Subject: [mSQL] Problems using delete clause
Message-Id: <14141674300402@i2000.es>

        We are testing the capabilities of mSQL (version 1.0.11) both on
Solaris 2.5 on a Pentium machine. We have compiled mSQL with the GNU C
compiler version 2.6.0. And, we have some problems with the delete clause.

        So, if there is no primary key in a table, the mSQL works properly.
However, when we define a primary for a table, some problemas arise with the
delete clause.

        For example, we use the following table:

        table actors
                name char(20) primary key,
                surname (20)
                studio char(10).
        
        and the records

        Sharon Stone Warner-Bross
        Bruce Willis MGM
      .......

 and we want to delete the record of Sharon Stone. If we send the query:

        delete from actors where name='Sharon'

the mSQL reported the next error:

        Hit by a sig 11
        Forced server shutdown due to bad signal!
        Forcing close on Socket 5
        ERROR : MSQL server has gone away

However, the query

        delete from actors where surname='Stone'

the redord are deleted. Why ????

Thanks in advanced.
Alvaro de la Hera Martinez
Interlinea 2000
Kaskotegui 4, Bajo
20.305 Irun (Spain)
E-mail: alvaro@i2000.es
Telephone: 34-43-619101
Fax: 34-43-618159

--------------------------------------------------------------------------
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!