Mailing List Archive


Back to the month index Back to the list index
Jin S. Choi (jsc@atype.com)
Thu, 9 Jan 1997 16:31:58 -0500 

Date: Thu, 9 Jan 1997 16:31:58 -0500
Message-Id: <199701092131.QAA05442@canker.atype.com>
From: "Jin S. Choi" <jsc@atype.com>
Subject: [mSQL] 2.0-b2 fails regression tests (and other problems)

I just built msql-2.0-b2 under Linux 2.0.27 and encountered a few
problems.

The first is that it fails the second regression test. I've appended
"2.res" to the end of this message.

Secondly, I ran some tests by hand that were confusing to me. Can
someone explain what's going on?

CREATE TABLE t1 (first CHAR(10) NOT NULL, last CHAR(10) NOT NULL, pizza INT)
INSERT INTO t1 VALUES ('jin','choi',1)\g
INSERT INTO t1 VALUES ('foo','bar',0)\g
INSERT INTO t1 VALUES ('baz','fred',NULL)\g

mSQL > select * from t1 where first='jin'\g

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

 +------------+------------+----------+
 | first | last | pizza |
 +------------+------------+----------+
 +------------+------------+----------+

mSQL > select * from t1 where pizza=1\g

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

 +------------+------------+----------+
 | first | last | pizza |
 +------------+------------+----------+
 | baz | fred | NULL |
 +------------+------------+----------+

Huh?

Thirdly, /usr/local/Hughes/doc/manual gets installed with permissions
750, which mean ordinary mortals can't read any of the docs.

Fourthly, /usr/local/Hughes/include ends up containing "time.h", which
will cause problems for any build system which specifies
-I/usr/local/Hughes/include in order to include msql.h, and also
happens to try to include <times.h> (I had this problem with PHP/FI, a
package that has mSQL support). A minor problem, but it would be
convenient if time.h could be renamed.

Lastly, relshow segfaults when given a third argument that is not an
index.
----------------------------------------------------------------------

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

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

insert into test(user,age,phone)values( 'Bambi',26,'(075) 951450')
[continue]
    ->

ERROR : Field "user" cannot be null

mSQL >
Query buffer
------------
insert into test(user,age,phone)values( 'paulp',25,'(075) 951412')
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

mSQL >
Query buffer
------------
insert into test(user,age,phone)values( 'fred',31,'(075) 951431')
[continue]
    ->

ERROR : Field "user" cannot be null

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

mSQL >
Query buffer
------------
insert into test2 (user, fullname) values ('Bambi','David J. Hughes')
[continue]
    ->

ERROR : Field "user" cannot be null

mSQL >
Query buffer
------------
insert into test2 (user, fullname) values ('fred','Fred O\'Niell')
[continue]
    ->
Query OK. 1 row(s) modified or retrieved.

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!