Mailing List Archive


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

Date: Wed, 11 Sep 1996 16:05:24 -0100
From: Alvaro de la Hera Martinez <alvaro@i2000.es>
Message-Id: <14065547001166@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 teachers
                name char(20) primary key,
                surname char (20)
                dept char(10).
        
        and the records

        Sharon Stone Compuer Science
        Bruce Willis Compuer Sicence
      .......

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

        delete from teachers 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 teachers 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!