Re: SQL query brings database server down

You are correct, when a query crashes the server in this manner it indicates a serious product defect. There are a few defects like this in the 7.10 product which have been fixed in patches, updates, and more recent releases. One of them relate to the mechanisms underlying "MATCHES", others to new features of the release. The best way to find information about this and other product defects is to use Informix's TechInfo facility, available from a top-level link at the web site at http://www.informix.com . You must have access to the facility, granted to licensed users with nearly any support or maintenance agreement and also to holders of the Informix Certified Professional (ICPP) credential. You can learn more about the ICPP under the link to "Training", then "Classroom Training" (at the moment, moving to the top level soon) from the Informix web site. The "bug search" tool has recently been greatly improved, in response to user requests, and comes heartily recommended. HTH, Clem At 11:46 AM 13-10-98 +0200, Bart Van der Cruyssen wrote: >We are working with INFORMIX Online Version 7.10. [...] Valuable detail omitted [...] >In my opinion, no possible input for a query (correct or incorrect) should >be able to bring down the database server, especially when executed from >within dbaccess (one of informix' own database tools). > >These are (some of) my questions: >- Have others experienced the same problem ? >- Is this a known bug ? (Note that the log file always refers to : >'rsdebug.c', line 3591.) >- Is this problem solved in later versions of the product ? >- Are there any workarounds, except not trying such queries ? >- Are there other "look-like" SQL-queries known to bring down the system ? > >Thanks. > >--------------------------------------------------------------- >Bart Van der Cruyssen Bart.VanderCruyssen@rug.ac.be >UNIVERSITY OF GHENT (BELGIUM) - Computer Science Laboratory >Sint-Pietersnieuwstraat 41, B-9000 GHENT, BELGIUM >tel: +32/9/264.42.23 fax: +32/9/264.42.77 _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: At the Informix office in La Grande Arche, Paris