Re: Serious V4R3 SQL Error

[John Cirocco <JCirocco@xxxxxxxxxx>]

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
+---