Mailing List Archive


Back to the month index Back to the list index
Andreas Koenig (k@anna.in-berlin.de)
Sun, 29 Sep 1996 12:02:47 +0200 

Date: Sun, 29 Sep 1996 12:02:47 +0200
Message-Id: <199609291002.MAA03011@anna.in-berlin.de>
From: Andreas Koenig <k@anna.in-berlin.de>
Subject: Re: [mSQL] add column to a table

>>>>> Shun Gao - 3669702 <sgao@nunic.nu.edu> writes:

shun> My attempt to add a column to an existing table yield severe
shun> bugs/errors.

shun> * Following the instructions in the FAQ, I dumped the schema and the
shun> content of the table, add a field to the schema, create the new table,
shun> modify the dumped data, and use the msql monitor to insert the data into
shun> the new table. All this works fine for tables with small number of
shun> records.
shun> However, this does NOT work for tables with number of records more than
shun> 20 - the msql monitor simply gets "chocked" and won't insert the records.
shun> What is the reason for this dismal performance of the monitor?
shun> Is there anywayt to force the poor monitor to handle more than 20 records
shun> at a time?

The msql monitor handles seemlessly my 400000 records table, do don't
blame the poor monitor. I'd rather expect you have an unrecognized
syntax error. Something of the type

    mSQL > create table foo ( bar char(2))\g

    Query OK.

    mSQL > insert into foo values ('1'')\g
    insert into foo values ('2')\g
    insert into foo values ('3')\g

    [...]

You see what's happening? The monitor waits for the \g and never gets
it because I challenged the pairwise tick recognition.

You can call it a bug, if you want.

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