'[Monetdb-sql-checkins] sql/src/test/BugTracker-2009/Tests'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-sql-checkins
Subject:    [Monetdb-sql-checkins] sql/src/test/BugTracker-2009/Tests
From:       Martin Kersten <mlkersten () users ! sourceforge ! net>
Date:       2010-03-14 8:27:25
Message-ID: E1NqjAW-0000TD-6P () sfp-cvsdas-1 ! v30 ! ch3 ! sourceforge ! com
[Download RAW message or body]

Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1562/test/BugTracker-2009/Tests


Modified Files:
	POWER_vs_prod.SF-2596114.stable.out reorder.SF-2770608.sql 
	table-leftovers.SF-2779462.sql union_leak.SF-2540169.2.mal 
Log Message:
The garbage collection administration has been changed. Every variable record
now comes with an end-of-life field (eolife), which denotes the instruction \
whereafter the BAT variable reference counter can be decremented. The garbage \
collector is never called automagically on MAL functions, because there may be other
pressing needs to retain them. This means that MAL functions defined and
used in the context of SQL, and which are not inlined, may cause a leakage.
The garbage collection has become part of each interpreter step.
The new approach makes the SQL/MAL plans half te size as before.


Index: table-leftovers.SF-2779462.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql,v
 retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- table-leftovers.SF-2779462.sql	11 Aug 2009 07:18:45 -0000	1.2
+++ table-leftovers.SF-2779462.sql	14 Mar 2010 08:27:23 -0000	1.3
@@ -1,6 +1,6 @@
 start transaction;
 
-set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable, \
deadcode,constants,commonTerms,reorder,joinPath,deadcode,recycle,reduce,garbageCollector,dataflow,history,multiplex';
 +set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable \
,deadcode,constants,commonTerms,reorder,joinPath,deadcode,recycle,reduce,dataflow,history,multiplex,garbageCollector';
  
 CREATE TABLE y (x int);
 INSERT INTO y VALUES (10);

Index: POWER_vs_prod.SF-2596114.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out,v
 retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- POWER_vs_prod.SF-2596114.stable.out	27 Feb 2010 19:28:26 -0000	1.11
+++ POWER_vs_prod.SF-2596114.stable.out	14 Mar 2010 08:27:22 -0000	1.12
@@ -31,30 +31,20 @@
 % 0 # length
 function user.s0_1{autoCommit=true}():void;
     _2 := sql.mvc();
-barrier _47 := language.dataflow();
+barrier _36 := language.dataflow();
     _3:bat[:oid,:dbl]  := sql.bind(_2,"sys","sf_2596114","x",0);
     _8:bat[:oid,:dbl]  := sql.bind(_2,"sys","sf_2596114","x",2);
     _10 := algebra.kdifference(_3,_8);
-    _3:bat[:oid,:dbl]  := nil:BAT;
     _11 := algebra.kunion(_10,_8);
-    _10 := nil:BAT;
-    _8:bat[:oid,:dbl]  := nil:BAT;
     _12:bat[:oid,:dbl]  := sql.bind(_2,"sys","sf_2596114","x",1);
     _14 := algebra.kunion(_11,_12);
-    _11 := nil:BAT;
-    _12:bat[:oid,:dbl]  := nil:BAT;
     _15:bat[:oid,:oid]  := sql.bind_dbat(_2,"sys","sf_2596114",1);
     _16 := bat.reverse(_15);
-    _15:bat[:oid,:oid]  := nil:BAT;
     _17 := algebra.kdifference(_14,_16);
-    _14 := nil:BAT;
-    _16 := nil:BAT;
     _18:bat[:oid,:dbl]  := batmmath.pow(_17,2);
-    _17 := nil:BAT;
-exit _47;
+exit _36;
     _19 := sql.resultSet(1,1,_18);
     sql.rsColumn(_19,"sys.","power_x","double",53,0,_18);
-    _18:bat[:oid,:dbl]  := nil:BAT;
     _25 := io.stdout();
     sql.exportResult(_25,_19);
 end s0_1;
@@ -64,30 +54,20 @@
 % 0 # length
 function user.s1_1{autoCommit=true}():void;
     _2 := sql.mvc();
-barrier _46 := language.dataflow();
+barrier _35 := language.dataflow();
     _3:bat[:oid,:dbl]  := sql.bind(_2,"sys","sf_2596114","x",0);
     _8:bat[:oid,:dbl]  := sql.bind(_2,"sys","sf_2596114","x",2);
     _10 := algebra.kdifference(_3,_8);
-    _3:bat[:oid,:dbl]  := nil:BAT;
     _11 := algebra.kunion(_10,_8);
-    _10 := nil:BAT;
-    _8:bat[:oid,:dbl]  := nil:BAT;
     _12:bat[:oid,:dbl]  := sql.bind(_2,"sys","sf_2596114","x",1);
     _14 := algebra.kunion(_11,_12);
-    _11 := nil:BAT;
-    _12:bat[:oid,:dbl]  := nil:BAT;
     _15:bat[:oid,:oid]  := sql.bind_dbat(_2,"sys","sf_2596114",1);
     _16 := bat.reverse(_15);
-    _15:bat[:oid,:oid]  := nil:BAT;
     _17 := algebra.kdifference(_14,_16);
-    _14 := nil:BAT;
-    _16 := nil:BAT;
     _18:bat[:oid,:dbl]  := batcalc.*(_17,_17);
-    _17 := nil:BAT;
-exit _46;
+exit _35;
     _19 := sql.resultSet(1,1,_18);
     sql.rsColumn(_19,"sys.","sql_mul_x","double",53,0,_18);
-    _18:bat[:oid,:dbl]  := nil:BAT;
     _25 := io.stdout();
     sql.exportResult(_25,_19);
 end s1_1;

Index: reorder.SF-2770608.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/reorder.SF-2770608.sql,v
 retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- reorder.SF-2770608.sql	20 Jul 2009 19:03:47 -0000	1.1
+++ reorder.SF-2770608.sql	14 Mar 2010 08:27:23 -0000	1.2
@@ -1,3 +1,3 @@
 -- query causes problems in specific pipeline
-set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,mer \
getable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex';
 +set optimizer='inline,remap,evaluate,costModel,coercions,emptySet,mitosis,aliases,me \
rgetable,deadcode,constants,commonTerms,joinPath,reorder,deadcode,reduce,dataflow,history,multiplex,garbageCollector';
  select * from types t1, types t2 where t1.id = t2.id;

Index: union_leak.SF-2540169.2.mal
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/union_leak.SF-2540169.2.mal,v
 retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- union_leak.SF-2540169.2.mal	1 Feb 2009 23:40:47 -0000	1.2
+++ union_leak.SF-2540169.2.mal	14 Mar 2010 08:27:23 -0000	1.3
@@ -4,3 +4,4 @@
 v4:=bat.reverse(v3);
 v5:=algebra.kdifference(v1,v4);
 io.print(v5);
+v5:= nil:bat;


------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
Monetdb-sql-checkins@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins


[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic