Mailing List Archive


Back to the month index Back to the list index
Derick Siddoway (derick@valinor.med.utah.edu)
Sun, 5 Jan 1997 11:48:15 -0700 (MST) 

Date: Sun, 5 Jan 1997 11:48:15 -0700 (MST)
From: Derick Siddoway <derick@valinor.med.utah.edu>
Subject: Re: [mSQL] bug with UPDATE  in MSQL-2.0-B 1?
Message-Id: <Pine.LNX.3.95.970105114319.19556A-100000@valinor.med.utah.edu>

On Fri, 3 Jan 1997, Henry Minsky wrote:

> I have been experiencing what looks like a bug with UPDATE statements
> in MSQL 2.0 Beta 1. It appears that UPDATE will not work on fields of
> type CHAR, only on INT or REAL types.

{snip}

> Anyone else get this behavior??

{snip}

Yes. Here's my pertinant info:

valinor:/usr/local/Hughes/bin# ./msqladmin version

Version Details :-

        msqladmin version 2.0 Beta 1
        mSQL server version 2.0 Beta 1
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform

>> I don't know why this isn't showing that I compiled it for
>> Linux 2.0.0.

Configuration Details :-

        Default config file /usr/local/Hughes/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/Hughes/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /usr/local/Hughes
        PID file location /usr/local/Hughes/msql2d.pid

Here's a script I ran to show the problem:

> update emplm set eessn='999999999' where eeempl='9901' and eeco='9999'\g
>
> select eefrst,eelast,eessn from emplm where eeempl='9901' and
> eeco='9999'\g

And here's the output from this script:

> Welcome to the miniSQL monitor. Type \h for help.
>
>
> mSQL >
> Query OK. 1 row(s) modified or retrieved.
>
>
>
>
> mSQL >
> Query OK. 1 row(s) modified or retrieved.
>
> +----------------------+--------------------------------+-----------+
> | eefrst | eelast | eessn |
> +----------------------+--------------------------------+-----------+
> | Derick | Siddoway | |
> +----------------------+--------------------------------+-----------+
>
>
>
> mSQL >
> Bye!

I note that the value in eessn is no longer NULL as it used to be, but
seems to be set to "". 

--
Derick Siddoway              
Computer Flunky              
University Hospital         Will Rogers never met Rush Limbaugh.
University of Utah

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