Update of /cvsroot/monetdb/sql/src/test/leaks/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv1972/src/test/leaks/Tests
Modified Files:
check0.stable.out check1.stable.out check2.stable.out
check3.stable.out check4.stable.out check5.stable.out
drop3.stable.out select1.stable.out select2.stable.out
temp1.stable.out temp2.stable.out temp3.stable.out
Log Message:
A sequence of group new and derives is now closed with a group.done (does
the last step ie a group.new or derive).
This makes the code in merge table a bit cleaner (more could be done later)
sql.bind and append/update/delete now have an extra (first) argument,
making them safe to use in the dataflow (ie solved using variable dependencies)
(BREAKS octopus !)
Implemented read only tables. Use
ALTER TABLE x SET READ ONLY;
(cannot be reverted currently)
fixed bug in limit/offset handling, now we have 64 bit wrd instead of int.
The new read only required schema changes, ie backup/restore your db.
We therefor claimed some more oid's for internal functions.
Index: temp1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/temp1.stable.out,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -d -r1.18 -r1.19
--- temp1.stable.out 25 May 2009 10:39:33 -0000 1.18
+++ temp1.stable.out 27 Feb 2010 19:28:48 -0000 1.19
@@ -29,12 +29,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 175 ]
+[ "transient", 179 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:41 >
# 22:02:41 > Done.
Index: temp3.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/temp3.stable.out,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -d -r1.20 -r1.21
--- temp3.stable.out 9 Oct 2009 20:50:21 -0000 1.20
+++ temp3.stable.out 27 Feb 2010 19:28:48 -0000 1.21
@@ -29,12 +29,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 198 ]
+[ "transient", 204 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:53 >
# 22:02:53 > Done.
Index: check3.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/check3.stable.out,v
retrieving revision 1.42
retrieving revision 1.43
diff -u -d -r1.42 -r1.43
--- check3.stable.out 10 Jan 2010 15:33:37 -0000 1.42
+++ check3.stable.out 27 Feb 2010 19:28:42 -0000 1.43
@@ -31,10 +31,11 @@
% 3, 3, 4 # length
[ "int", "int", 0 ]
[ "int", "lng", 2 ]
-[ "int", "str", 119 ]
+[ "int", "str", 121 ]
[ "oid", "bit", 0 ]
[ "oid", "bit", 31 ]
-[ "oid", "bit", 178 ]
+[ "oid", "bit", 31 ]
+[ "oid", "bit", 184 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
@@ -80,11 +81,12 @@
[ "oid", "int", 27 ]
[ "oid", "int", 31 ]
[ "oid", "int", 31 ]
-[ "oid", "int", 178 ]
-[ "oid", "int", 178 ]
-[ "oid", "int", 178 ]
-[ "oid", "int", 178 ]
-[ "oid", "int", 178 ]
+[ "oid", "int", 184 ]
+[ "oid", "int", 184 ]
+[ "oid", "int", 184 ]
+[ "oid", "int", 184 ]
+[ "oid", "int", 184 ]
+[ "oid", "int", 184 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 2914 ]
@@ -148,9 +150,9 @@
[ "oid", "str", 27 ]
[ "oid", "str", 31 ]
[ "oid", "str", 31 ]
-[ "oid", "str", 178 ]
-[ "oid", "str", 178 ]
-[ "oid", "str", 178 ]
+[ "oid", "str", 184 ]
+[ "oid", "str", 184 ]
+[ "oid", "str", 184 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
@@ -160,12 +162,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 190 ]
+[ "transient", 196 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:16 >
# 22:02:16 > Done.
Index: select1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/select1.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- select1.stable.out 9 Oct 2009 20:50:21 -0000 1.10
+++ select1.stable.out 27 Feb 2010 19:28:48 -0000 1.11
@@ -34,7 +34,8 @@
% L1 # name
% wrd # type
% 3 # length
-[ 118 ]
+[ 120 ]
+#select 1;
% . # table_name
% single_value # name
% tinyint # type
@@ -44,7 +45,7 @@
% L1 # name
% wrd # type
% 3 # length
-[ 118 ]
+[ 120 ]
# 22:03:05 >
# 22:03:05 > Done.
Index: select2.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/select2.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- select2.stable.out 9 Oct 2009 20:50:21 -0000 1.10
+++ select2.stable.out 27 Feb 2010 19:28:48 -0000 1.11
@@ -34,7 +34,8 @@
% L1 # name
% wrd # type
% 3 # length
-[ 118 ]
+[ 120 ]
+#select 1;
% . # table_name
% single_value # name
% tinyint # type
@@ -44,7 +45,7 @@
% L1 # name
% wrd # type
% 3 # length
-[ 118 ]
+[ 120 ]
# 22:03:05 >
# 22:03:05 > Done.
Index: check2.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/check2.stable.out,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -d -r1.41 -r1.42
--- check2.stable.out 10 Jan 2010 15:33:37 -0000 1.41
+++ check2.stable.out 27 Feb 2010 19:28:42 -0000 1.42
@@ -31,10 +31,11 @@
% 3, 3, 4 # length
[ "int", "int", 0 ]
[ "int", "lng", 2 ]
-[ "int", "str", 119 ]
+[ "int", "str", 121 ]
[ "oid", "bit", 0 ]
[ "oid", "bit", 30 ]
-[ "oid", "bit", 176 ]
+[ "oid", "bit", 30 ]
+[ "oid", "bit", 182 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
@@ -80,11 +81,12 @@
[ "oid", "int", 27 ]
[ "oid", "int", 30 ]
[ "oid", "int", 30 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 2914 ]
@@ -148,9 +150,9 @@
[ "oid", "str", 27 ]
[ "oid", "str", 30 ]
[ "oid", "str", 30 ]
-[ "oid", "str", 176 ]
-[ "oid", "str", 176 ]
-[ "oid", "str", 176 ]
+[ "oid", "str", 182 ]
+[ "oid", "str", 182 ]
+[ "oid", "str", 182 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
@@ -160,12 +162,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 172 ]
+[ "transient", 176 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:16 >
# 22:02:16 > Done.
Index: check1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/check1.stable.out,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -d -r1.41 -r1.42
--- check1.stable.out 10 Jan 2010 15:33:37 -0000 1.41
+++ check1.stable.out 27 Feb 2010 19:28:41 -0000 1.42
@@ -31,10 +31,11 @@
% 3, 3, 4 # length
[ "int", "int", 0 ]
[ "int", "lng", 2 ]
-[ "int", "str", 119 ]
+[ "int", "str", 121 ]
[ "oid", "bit", 0 ]
[ "oid", "bit", 30 ]
-[ "oid", "bit", 176 ]
+[ "oid", "bit", 30 ]
+[ "oid", "bit", 182 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
@@ -80,11 +81,12 @@
[ "oid", "int", 27 ]
[ "oid", "int", 30 ]
[ "oid", "int", 30 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 2914 ]
@@ -148,9 +150,9 @@
[ "oid", "str", 27 ]
[ "oid", "str", 30 ]
[ "oid", "str", 30 ]
-[ "oid", "str", 176 ]
-[ "oid", "str", 176 ]
-[ "oid", "str", 176 ]
+[ "oid", "str", 182 ]
+[ "oid", "str", 182 ]
+[ "oid", "str", 182 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
@@ -160,12 +162,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 172 ]
+[ "transient", 176 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:15 >
# 22:02:15 > Done.
Index: check4.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/check4.stable.out,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -d -r1.41 -r1.42
--- check4.stable.out 10 Jan 2010 15:33:37 -0000 1.41
+++ check4.stable.out 27 Feb 2010 19:28:42 -0000 1.42
@@ -31,10 +31,11 @@
% 3, 3, 4 # length
[ "int", "int", 0 ]
[ "int", "lng", 2 ]
-[ "int", "str", 119 ]
+[ "int", "str", 121 ]
[ "oid", "bit", 0 ]
[ "oid", "bit", 32 ]
-[ "oid", "bit", 180 ]
+[ "oid", "bit", 32 ]
+[ "oid", "bit", 186 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
@@ -80,11 +81,12 @@
[ "oid", "int", 27 ]
[ "oid", "int", 32 ]
[ "oid", "int", 32 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 2914 ]
@@ -148,9 +150,9 @@
[ "oid", "str", 27 ]
[ "oid", "str", 32 ]
[ "oid", "str", 32 ]
-[ "oid", "str", 180 ]
-[ "oid", "str", 180 ]
-[ "oid", "str", 180 ]
+[ "oid", "str", 186 ]
+[ "oid", "str", 186 ]
+[ "oid", "str", 186 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
@@ -160,12 +162,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 190 ]
+[ "transient", 196 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:17 >
# 22:02:17 > Done.
Index: check0.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/check0.stable.out,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -d -r1.41 -r1.42
--- check0.stable.out 10 Jan 2010 15:33:37 -0000 1.41
+++ check0.stable.out 27 Feb 2010 19:28:39 -0000 1.42
@@ -31,10 +31,11 @@
% 3, 3, 4 # length
[ "int", "int", 0 ]
[ "int", "lng", 2 ]
-[ "int", "str", 119 ]
+[ "int", "str", 121 ]
[ "oid", "bit", 0 ]
[ "oid", "bit", 30 ]
-[ "oid", "bit", 176 ]
+[ "oid", "bit", 30 ]
+[ "oid", "bit", 182 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
@@ -80,11 +81,12 @@
[ "oid", "int", 27 ]
[ "oid", "int", 30 ]
[ "oid", "int", 30 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
-[ "oid", "int", 176 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
+[ "oid", "int", 182 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 2914 ]
@@ -148,9 +150,9 @@
[ "oid", "str", 27 ]
[ "oid", "str", 30 ]
[ "oid", "str", 30 ]
-[ "oid", "str", 176 ]
-[ "oid", "str", 176 ]
-[ "oid", "str", 176 ]
+[ "oid", "str", 182 ]
+[ "oid", "str", 182 ]
+[ "oid", "str", 182 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
@@ -160,12 +162,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 172 ]
+[ "transient", 176 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:15 >
# 22:02:15 > Done.
Index: check5.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/check5.stable.out,v
retrieving revision 1.41
retrieving revision 1.42
diff -u -d -r1.41 -r1.42
--- check5.stable.out 10 Jan 2010 15:33:37 -0000 1.41
+++ check5.stable.out 27 Feb 2010 19:28:47 -0000 1.42
@@ -31,10 +31,11 @@
% 3, 3, 4 # length
[ "int", "int", 0 ]
[ "int", "lng", 2 ]
-[ "int", "str", 119 ]
+[ "int", "str", 121 ]
[ "oid", "bit", 0 ]
[ "oid", "bit", 32 ]
-[ "oid", "bit", 180 ]
+[ "oid", "bit", 32 ]
+[ "oid", "bit", 186 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
[ "oid", "bit", 1037 ]
@@ -80,11 +81,12 @@
[ "oid", "int", 27 ]
[ "oid", "int", 32 ]
[ "oid", "int", 32 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
-[ "oid", "int", 180 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
+[ "oid", "int", 186 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 1037 ]
[ "oid", "int", 2914 ]
@@ -148,9 +150,9 @@
[ "oid", "str", 27 ]
[ "oid", "str", 32 ]
[ "oid", "str", 32 ]
-[ "oid", "str", 180 ]
-[ "oid", "str", 180 ]
-[ "oid", "str", 180 ]
+[ "oid", "str", 186 ]
+[ "oid", "str", 186 ]
+[ "oid", "str", 186 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
[ "oid", "str", 1037 ]
@@ -160,12 +162,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 190 ]
+[ "transient", 196 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:17 >
# 22:02:17 > Done.
Index: temp2.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/temp2.stable.out,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -d -r1.20 -r1.21
--- temp2.stable.out 25 May 2009 10:39:37 -0000 1.20
+++ temp2.stable.out 27 Feb 2010 19:28:48 -0000 1.21
@@ -29,12 +29,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 175 ]
+[ "transient", 179 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 127 ]
+[ "persistent", 129 ]
# 22:02:41 >
# 22:02:41 > Done.
Index: drop3.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/leaks/Tests/drop3.stable.out,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- drop3.stable.out 9 Oct 2009 20:50:21 -0000 1.19
+++ drop3.stable.out 27 Feb 2010 19:28:48 -0000 1.20
@@ -29,12 +29,13 @@
% L1, L2 # name
% char, wrd # type
% 9, 3 # length
-[ "transient", 190 ]
+[ "transient", 196 ]
+#select 'persistent', count(*) from bbp() as bbp where kind like 'pers%';
% .L3, .bbp # table_name
% L3, L4 # name
% char, wrd # type
% 10, 3 # length
-[ "persistent", 130 ]
+[ "persistent", 132 ]
# 22:02:53 >
# 22:02:53 > Done.
------------------------------------------------------------------------------
Download Intel® 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
