Mailing List Archive


Back to the month index Back to the list index
Robert Twitty (rtwitty@ushmm.org)
Tue, 28 Jan 1997 11:02:26 -0500 (EST) 

Date: Tue, 28 Jan 1997 11:02:26 -0500 (EST)
From: Robert Twitty <rtwitty@ushmm.org>
Subject: [mSQL] 2.0B3 Update kills server
Message-Id: <Pine.GSO.3.92.970128105035.2936A-100000@atom>

Hello everyone

I just installed msql 2.0B3 on a Sparc 20 running Solaris 2.4. I created
a database called "test" and then ran the following command:

        msql test < sample.msql

sample.msql is an example script included with the installation. The
problem is that after the execution of the SQL statement,

     update test set age = 26 where name = 'paulp'

the server crashes. Has anyone else experienced this problem? I have
included the output of the command "msql test < sample.msql" below.

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

mSQL > -> ->
Query buffer
------------

drop table test

[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> ->
Query buffer
------------
drop table test2

[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> -> -> -> -> -> ->
Query buffer
------------
create table test (
        name char(10),
        age int,
        phone char(20)
)

[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > ->
Query buffer
------------
create index idx1 on test (name)
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> -> -> ->
Query buffer
------------
create table test2 (
        user char(10),
        name char(30)
)
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > ->
Query buffer
------------
create index idx1 on test2 (user)
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> -> ->
Query buffer
------------
insert into test ( name, age, phone)
        values ( 'Bambi', 26, '(075) 951450')

[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> -> -> ->
Query buffer
------------
insert into test ( name, age, phone)
        values ( 'paulp', 25, '(075) 951412')

[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> ->
Query buffer
------------
insert into test2 (user, name) values ('paulp','Paul Pyyvaara')
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL >
Query buffer
------------
insert into test2 (user, name) values ('Bambi','David J. Hughes')
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> -> -> -> ->
Query buffer
------------

insert into test (age, phone)
        values ( 99, '9999')

[continue]
    ->

ERROR : Index field "name" cannot be NULL

mSQL > -> -> -> -> -> ->
Query buffer
------------

insert into test (name, age, phone)
        values ('Bambi', 26, '(075) Home_Number')

[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL > -> -> ->
Query buffer
------------
select phone from test where name = 'Bambi'

[continue]
    ->
Query OK. 2 row(s) modified or retrieved.

 +----------------------+
 | phone |
 +----------------------+
 | (075) 951450 |
 | (075) Home_Number |
 +----------------------+

mSQL > -> ->
Query buffer
------------
select * from test
[continue]
    ->
Query OK. 3 row(s) modified or retrieved.

 +------------+----------+----------------------+
 | name | age | phone |
 +------------+----------+----------------------+
 | Bambi | 26 | (075) 951450 |
 | paulp | 25 | (075) 951412 |
 | Bambi | 26 | (075) Home_Number |
 +------------+----------+----------------------+

mSQL > -> ->
Query buffer
------------
update test set age = 26 where name = 'paulp'

[continue]
    ->

ERROR : MSQL server has gone away

mSQL > -> ->
Query buffer
------------
select * from test
[continue]
    ->

ERROR : MSQL server has gone away

mSQL > -> ->
Query buffer
------------
select * from test where phone = '(075) 951412'

[continue]
    ->

ERROR : MSQL server has gone away

mSQL > -> -> -> ->
Query buffer
------------
select * from test where name like '%am%'

[continue]
    ->

ERROR : MSQL server has gone away

mSQL > -> -> -> -> -> ->
Query buffer
------------

select test2.name, test.phone
        from test2,test
        where test2.user = test.name

[continue]
    ->

ERROR : MSQL server has gone away

mSQL > -> -> -> -> -> ->
Query buffer
------------

select test2.name, test.phone
        from test2,test
        where test2.user = test.name
        order by test2.name

[continue]
    ->

ERROR : MSQL server has gone away

mSQL > -> -> ->
Bye!

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