Mailing List Archive


Back to the month index Back to the list index
Tauren Mills (tauren@groovee.com)
Tue, 1 Apr 1997 23:51:43 -0800 

Message-Id: <01BC3EF7.AA2AB0E0@yowza.groovee.com>
From: Tauren Mills <tauren@groovee.com>
Subject: [mSQL] Crashing msql2d
Date: Tue, 1 Apr 1997 23:51:43 -0800

I have the following SQL query that will actually crash msql2d:

  select products.prod_id, transactions.prod_id, transactions.order_id from
  products, transactions where products.prod_id = transactions.prod_id
  and transactions.order_id = '%s' and products.prod_id = '%s'

I spent a bunch of time trying to isolate the problem and finally changed
the SQL query to this:

  select products.prod_id, transactions.prod_id, transactions.order_id from
  products, transactions where (products.prod_id = transactions.prod_id)
  and (transactions.order_id = '%s' and products.prod_id = '%s')

All I did was add some parenthases... Now it works. What would cause
this behavior?

Version Details :-
 
        msqladmin version 2.0 Beta 5 Pre2
        mSQL server version 2.0 Beta 5 Pre2
        mSQL protocol version 22
        mSQL connection Localhost via UNIX socket
        Target platform SunOS-4.1.4-Sparc
 
Configuration Details :-
 
        Default config file /easystreet/vdomains/es2vd136/msql2/msql.conf
        TCP socket 4333
        UNIX socket /easystreet/vdomains/es2vd136/msql2/msql2.sock
        mSQL user es2vd136
        Admin user es2vd136
        Install directory /easystreet/vdomains/es2vd136/msql2
        PID file location /easystreet/vdomains/es2vd136/msql2/msql2d.pid

Thanks,
Tauren

* Groovee Creatives * Tauren Mills *
* tauren@groovee.com * PO BOX 1072 *
* http://www.groovee.com/ * Portland, OR 97207 *
* ftp://ftp.groovee.com/pub/groovee/ * TEL: 503.768.9392 *
*CGI*Java*ActiveX*NSAPI*ISAPI*SQL*C/C++*Shockwave*XTRAs*VB*Sound* 





    

  • application/ms-tnef attachment: stored