Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests
In directory 
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16373/src/test/BugTracker-2008/Tests

Modified Files:
        select_between_wrong_result.SF-2080189.stable.out 
        sql_command_kills_db.SF-2233677.stable.err 
Log Message:
handle topn a bit earlier (before the projection join) 

In union distinct we use TID's where possible


U select_between_wrong_result.SF-2080189.stable.out
Index: select_between_wrong_result.SF-2080189.stable.out
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- select_between_wrong_result.SF-2080189.stable.out   27 Dec 2008 19:34:06 
-0000      1.6
+++ select_between_wrong_result.SF-2080189.stable.out   29 Dec 2008 21:30:08 
-0000      1.7
@@ -29,7 +29,7 @@
 [ 1    ]
 [ 1    ]
 % sys.a # table_name
-% L3 # name
+% L2 # name
 % wrd # type
 % 1 # length
 [ 3    ]

U sql_command_kills_db.SF-2233677.stable.err
Index: sql_command_kills_db.SF-2233677.stable.err
===================================================================
RCS file: 
/cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- sql_command_kills_db.SF-2233677.stable.err  28 Dec 2008 19:05:12 -0000      
1.4
+++ sql_command_kills_db.SF-2233677.stable.err  29 Dec 2008 21:30:08 -0000      
1.5
@@ -84,7 +84,7 @@
 
 MAPI  = mone...@eir:36862
 QUERY = insert into t1 values ((select id, name from tables));
-ERROR = !SQLException:zero_or_one:cardinality violation (28>1)
+ERROR = !SQLException:zero_or_one:cardinality violation (27>1)
 
 # 16:15:09 >  
 # 16:15:09 >  Done.


------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to