Mailing List Archive


Back to the month index Back to the list index
Will Brown (ewb@zns.net)
Thu, 9 Jan 1997 11:55:15 -0500 (EST) 

Date: Thu, 9 Jan 1997 11:55:15 -0500 (EST)
From: Will Brown <ewb@zns.net>
Message-Id: <199701091655.LAA07932@selway.i.com>
Subject: [mSQL] 2.0-B2, Solaris fails :(

msqladmin version 2.0 Beta 2
mSQL server version 2.0 Beta 2
mSQL protocol version 22
mSQL connection Localhost via UNIX socket
Target platform Solaris-2.4-Sparc

Compiler gcc 2.6.3
Yacc GNU Bison version 1.22
Hardware SS10 with Dual Ross HyperSPARCs

I compiled mSQL with optimization (-O) first, and it fails
utterly. Regression test 2 fails. Seems that an insert statement with
non-NULL for some field x is misinterpreted, and field x ends up NULL.
If the field is required to be non-NULL, then an error is reported.

BTW: parser.y had 9 shift/reduce conflicts (is that right?)

Re-compiled without optimization (-g). Regression tests now pass 100%,
but the www_setup lite script fails. Same problem - an insert with
'SuperUser' as a data value is accused of trying to insert NULL data
into the field.

The demo bookmarks database also ends up with NULLs where it shouldn't
have them (in the "type" field). Shows with msqldump and msqlexport.

I have three theories. Can anyone tell me which is right, or
better yet just tell me what's wrong?
(Yes, I'll be trying out these theories myself)

1. Bison 1.22 (Get 1.25 and try again, or how about byacc?)
2. Compiler. (Get gcc 2.7.2 and try again)
3. Multi-processor (Is mSQL using threads???)

Thanks for any hints you can offer, or if this is a new one, glad to
be of assistance as a Beta Tester :) 

--
Will Brown <ewb@zns.net>
--------------------------------------------------------------------------
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!