Mailing List Archive


Back to the month index Back to the list index
Jesper Weissglas (jesper@robot.se)
Mon, 21 Apr 1997 15:41:08 +0100 

Message-Id: <v03010d07af8129aad92d@[194.52.223.22]>
Date: Mon, 21 Apr 1997 15:41:08 +0100
From: Jesper Weissglas <jesper@robot.se>
Subject: [mSQL] 2.0b6 Update only modifies one row

While trying out mSQL 2.0 beta 6 for a new project I came across the
strangeness. The problem is repeatable. It shows at the bottom of the
following transcript.

The file Dump_970419.sql is available at:

ftp://hondo.robot.se/pub/Dump_970419.sql

Regards,
/jesper

------------------------------------------------------------------

% msqladmin version

Version Details :-

        msqladmin version 2.0 Beta 6
        mSQL server version 2.0 Beta 6
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform HP-UX-A.09.05-9000_715

Configuration Details :-

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

% msqladmin drop Test

Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the "Test" database? [Y/N] y
Database "Test" dropped
% msqladmin create Test
Database "Test" created.
% msql Test <Dump_970419.sql

.....lots of prompts snipped.....

% msql Test

Welcome to the miniSQL monitor. Type \h for help.

mSQL > select TextID, TextCategoryID from Texts where TextID='selectLanguage'\g

Query OK. 2 row(s) modified or retrieved.

 +----------------------+----------------+
 | TextID | TextCategoryID |
 +----------------------+----------------+
 | selectLanguage | 3 |
 | selectLanguage | 3 |
 +----------------------+----------------+

mSQL > update Texts set TextCategoryID=1 where TextID='selectLanguage'\g

Query OK. 2 row(s) modified or retrieved.

mSQL > select TextID, TextCategoryID from Texts where TextID='selectLanguage'\g

Query OK. 2 row(s) modified or retrieved.

 +----------------------+----------------+
 | TextID | TextCategoryID |
 +----------------------+----------------+
 | selectLanguage | 3 |
 | selectLanguage | 1 |
 +----------------------+----------------+

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