Update of /cvsroot/monetdb/sql/src/test/ADT2006/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1170/src/test/ADT2006/Tests
Modified Files:
bram.stable.out slam.stable.out woud.stable.out
Log Message:
be more safe with unions and outer joins (ie copy also the first part
of the unions and joins, before any append)
U woud.stable.out
Index: woud.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/ADT2006/Tests/woud.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- woud.stable.out 7 Dec 2008 17:37:04 -0000 1.3
+++ woud.stable.out 30 Dec 2008 19:19:06 -0000 1.4
@@ -65,7 +65,7 @@
% substring_murderdate # name
% int # type
% 1 # length
-% sys.numbers # table_name
+% .numbers # table_name
% L5 # name
% double # type
% 22 # length
@@ -83,7 +83,7 @@
% doctor # name
% varchar # type
% 0 # length
-% sys.allnames # table_name
+% .allnames # table_name
% name # name
% varchar # type
% 0 # length
U bram.stable.out
Index: bram.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/ADT2006/Tests/bram.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- bram.stable.out 7 Dec 2008 17:37:04 -0000 1.6
+++ bram.stable.out 30 Dec 2008 19:19:06 -0000 1.7
@@ -157,7 +157,7 @@
[ 10, 1 ]
[ 11, 2 ]
[ 12, 2 ]
-% ., sys.v # table_name
+% ., .v # table_name
% mon, victim # name
% tinyint, varchar # type
% 2, 42 # length
@@ -211,7 +211,7 @@
% 6, 4 # length
[ "blonde", "5'7\"" ]
[ "brown", "5'5\"" ]
-% sys.victim # table_name
+% .victim # table_name
% victim # name
% varchar # type
% 42 # length
U slam.stable.out
Index: slam.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/ADT2006/Tests/slam.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- slam.stable.out 7 Sep 2008 14:42:36 -0000 1.7
+++ slam.stable.out 30 Dec 2008 19:19:06 -0000 1.8
@@ -190,7 +190,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.s, sys.v, sys.e, sys.e # table_name
+% .s, .v, .e, .e # table_name
% victim, location, time, text # name
% varchar, varchar, varchar, clob # type
% 42, 134, 15, 1040 # length
@@ -217,7 +217,7 @@
[ "Pinchin Street Murder, possibly Lydia Hart", "under a railway arch
in Pinchin Street", NULL, NULL ]
[ "Rose Mylett", "the yard between 184 and 186 Poplar High Street, in
Clarke's Yard", NULL, NULL ]
[ "Whitehall Mystery", "a vault soon to become a section of the cellar of New
Scotland Yard", NULL, NULL ]
-% sys.v, sys.sp, sys.sp # table_name
+% .v, .sp, .sp # table_name
% name, name, picture # name
% varchar, varchar, varchar # type
% 42, 34, 47 # length
@@ -239,7 +239,7 @@
[ "Pinchin Street Murder, possibly Lydia Hart", NULL, NULL ]
[ "Rose Mylett", NULL, NULL ]
[ "Whitehall Mystery", NULL, NULL ]
-% sys.i, sys.si # table_name
+% .i, .si # table_name
% name, times # name
% varchar, wrd # type
% 45, 1 # length
@@ -296,7 +296,7 @@
[ "hazel", 1 ]
[ "light gray", 1 ]
[ "unknown", 1 ]
-% sys.s, sys.w, sys.i, sys.d, sys.sp # table_name
+% .s, .w, .i, .d, .sp # table_name
% victim, witnesses, inspectors, doctors, suspects # name
% varchar, wrd, wrd, wrd, wrd # type
% 42, 1, 1, 1, 1 # length
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
