Mailing List Archive


Back to the month index Back to the list index
Stephanie Coriat (coriat@jacobson.contrib.com)
Thu, 12 Sep 1996 16:53:09 +0200 

Message-Id: <323823D4.167EB0E7@jacobson.contrib.com>
Date: Thu, 12 Sep 1996 16:53:09 +0200
From: Stephanie Coriat <coriat@jacobson.contrib.com>
Subject: [mSQL] BUG with the Insert Query

Hi,

The Insert Queries sometime return "Query OK", but do NOT insert the new
record, or insert strange values.

Version Details :-

        msqladmin version 1.0.16
        mSQL connection Localhost via UNIX socket
        mSQL server version 1.0.16
        mSQL protocol version 6
        mSQL TCP socket 1112
        mSQL UNIX socket /dev/msql
        mSQL root user root
        Host Architecture FreeBSD-2.2-960323-SNAP-i386

Table = domain_reg

 +-----------------+----------+--------+----------+-----+
 | Field | Type | Length | Not Null | Key |
 +-----------------+----------+--------+----------+-----+
 | domain_nr | int | 4 | Y | Y |
 | date | char | 8 | N | N |
 +-----------------+----------+--------+----------+-----+

mSQL > select * from domain_reg
    -> \g

Query OK.

17 rows matched.

 +-----------+----------+
 | domain_nr | date |
 +-----------+----------+
 | 1 | 19950715 |
 | 3 | 19640912 |
 | 14 | 19960612 |
 | 15 | 19960612 |
 | 16 | 19960612 |
 | 17 | 19960612 |
 | 18 | 19960612 |
 | 19 | |
 | 20 | 19960617 |
 | 142 | 19960710 |
 | 22 | 19960618 |
 | 23 | 19960618 |
 | 24 | 19960619 |
 | 25 | 19960625 |
 | 36865 | NULL |
 | 36097 | NULL |
 | NULL | NULL |
 +-----------+----------+

Have anyone had the same problem ???

Thanks,
Stephanie. 

-- 
Stephanie Coriat                            coriat@jacobson.contrib.com
                                            scoriat@cs.tu-berlin.de
http://www.cs.tu-berlin.de/~scoriat/        scoriat@ifhamy.insa-lyon.fr
--------------------------------------------------------------------------
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!