Mailing List Archive


Back to the month index Back to the list index
William Evans (evans@stash.cnet.navy.mil)
Mon, 6 Jan 1997 08:34:04 -0600 

Date: Mon, 6 Jan 1997 08:34:04 -0600
Message-Id: <199701061434.IAA05448@stash.cnet.navy.mil>
From: William Evans <evans@stash.cnet.navy.mil>
Subject: [mSQL] Q: parens overloading the server?

I looked through the FAQ and docs and couldn't find a reference to
this problem.

I'm running msql2 and trying the following accesses (from the msql
terminal program):

        select name
                from table1
                where (name clike '%abc%') \g

and all works fine.

I then add in some table references:

        select table1.name
                from table1,table2
                where (table1.name clike '%abc%') \g

and things thrash and die on me. I would eventually like to use a
more complicated `where' clause to search both tables, but I wouldn't
think that a simple query such as this would kill the server.

Version Details :-

        msqladmin version 2.0 Beta 1
        mSQL server version 2.0 Beta 1
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform Linux-2.0.23-i586

Configuration Details :-

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

(linux 2.0.23)

Has anybody had similar results?
Does anybody have a possible explanation/solution?

-wfe 

-- 
      __
     / /\
    / /  \  William Evans
   / / /\ \
  / / /\ \ \  wfe01@gnofn.org
 / /_/__\ \ \
/________\ \ \
\___________\/
--------------------------------------------------------------------------
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!