MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 1999

Re: Serious V4R3 SQL Error


  • Subject: Re: Serious V4R3 SQL Error
  • From: John Cirocco <JCirocco@xxxxxxxxxx>
  • Date: Tue, 11 May 1999 13:19:42 -0400

fixed

Walden,

We just did the V3R7 to V4R3 move on April 17th.  Since then I have had 4 sev1 
problems with SQL and query manager.  I still have an open one today.  MAJOR 
problems.  Some fixed by the database service pack but a few that arn't.  Also 
some still run fine except a 5 minute QMQuery takes over an hour...  Bummer.

Good luck.
John


John W. Cirocco
Manager, Operations
Computer Task Group, Inc.
(716) 888-3566

>>> Walden Leverich <walden@techsoftinc.com> 05/11 12:08 PM >>>
Folks, 
 
Here is a new one for you all. It appears that at some PTF levels of V4R3
there is a bug in SQL where access plans are not re-evaluated after changing
your library list.
 
To recreate:
 
1) Log-on
2) Pick a file that exists in two (or more) libraries, Lib1 and Lib2
3) Add Lib1 to the top of your library list
3) strsql
4) select * from file where field = 'a' 
5) remember results
6) exit sql
7) add Lib2 to your library list higher than Lib1
8) strsql
9) rerun select statement (WITHOUT changing the case of anything)
10) You will get your old results (SQL run over file in Lib 1)
11) Change the case of anything ('from' to 'FROM' or 'froM' or 'From' ...)
12) rerun query and you will get new (correct) results.
 
I'll keep you informed as I get more info.
 
-Walden
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com 
+---
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
       
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact