Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory 
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1536/src/test/BugTracker/Tests

Modified Files:
        explain.SF-1739353.stable.out.Algebra 
        explain.SF-1739353.stable.out.Five.Algebra 
Log Message:
rel optimizer detects more join indices (problem was caused by aliased columns)
Approved output after select->uselect changes


Index: explain.SF-1739353.stable.out.Algebra
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/explain.SF-1739353.stable.out.Algebra,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- explain.SF-1739353.stable.out.Algebra       28 Jan 2008 22:54:41 -0000      
1.1
+++ explain.SF-1739353.stable.out.Algebra       8 Mar 2008 07:27:04 -0000       
1.2
@@ -64,7 +64,7 @@
 | var s27 := bte("2");                                                  |
 | var s26 := sht(s27);                                                  |
 | s27 := nil;                                                           |
-| var s8 := s9.select(sht(nil), s26, FALSE, FALSE);                     |
+| var s8 := s9.uselect(sht(nil), s26, FALSE, FALSE);                     |
 | s9 := nil;                                                            |
 | s26 := nil;                                                           |
 | var s28 := oid("[EMAIL PROTECTED]");                                         
       |

Index: explain.SF-1739353.stable.out.Five.Algebra
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/explain.SF-1739353.stable.out.Five.Algebra,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- explain.SF-1739353.stable.out.Five.Algebra  25 Feb 2008 22:28:00 -0000      
1.3
+++ explain.SF-1739353.stable.out.Five.Algebra  8 Mar 2008 07:27:04 -0000       
1.4
@@ -66,7 +66,7 @@
 |     _20{rows=109:lng} := nil;                                                
|
 |     bat.append(_21,_9,true);                                                 
|
 |     _9{rows=1:lng} := nil;                                                   
|
-|     _25{rows=56:lng} := algebra.select(_21,nil:sht,2,false,false);           
|
+|     _25{rows=56:lng} := algebra.uselect(_21,nil:sht,2,false,false);          
|
 |     _21{rows=111:lng} := nil;                                                
|
 |     _29{rows=56:lng,tlb>[EMAIL PROTECTED]:oid,tub<[EMAIL PROTECTED]:oid} := 
algebra.markT(_25,[EMAIL PROTECTED]);     |
 |     _25{rows=56:lng} := nil;                                                 
|


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to