Update of /cvsroot/monetdb/sql/src/test/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1170/src/test/Tests
Modified Files:
50ways.stable.out function_syntax.stable.out keys.stable.out
marcin1.stable.out outerref_in_selection.stable.out
procedure_syntax.stable.out rank.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 50ways.stable.out
Index: 50ways.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/50ways.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- 50ways.stable.out 7 Dec 2008 16:39:35 -0000 1.1
+++ 50ways.stable.out 30 Dec 2008 19:19:06 -0000 1.2
@@ -152,7 +152,7 @@
% tinyint # type
% 2 # length
[ 29 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -161,7 +161,7 @@
% tinyint # type
% 2 # length
[ 30 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -170,7 +170,7 @@
% tinyint # type
% 2 # length
[ 31 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -179,7 +179,7 @@
% tinyint # type
% 2 # length
[ 32 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -188,7 +188,7 @@
% tinyint # type
% 2 # length
[ 33 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -197,7 +197,7 @@
% tinyint # type
% 2 # length
[ 34 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -206,7 +206,7 @@
% tinyint # type
% 2 # length
[ 35 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -215,7 +215,7 @@
% tinyint # type
% 2 # length
[ 36 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -224,7 +224,7 @@
% tinyint # type
% 2 # length
[ 37 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -251,7 +251,7 @@
% tinyint # type
% 2 # length
[ 41 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -260,7 +260,7 @@
% tinyint # type
% 2 # length
[ 42 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -269,7 +269,7 @@
% tinyint # type
% 2 # length
[ 44 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -278,7 +278,7 @@
% tinyint # type
% 2 # length
[ 45 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -287,7 +287,7 @@
% tinyint # type
% 2 # length
[ 47 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
@@ -296,7 +296,7 @@
% tinyint # type
% 2 # length
[ 48 ]
-% sys.s # table_name
+% .s # table_name
% sname # name
% varchar # type
% 0 # length
U marcin1.stable.out
Index: marcin1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/marcin1.stable.out,v
retrieving revision 1.23
retrieving revision 1.24
diff -u -d -r1.23 -r1.24
--- marcin1.stable.out 21 Dec 2008 19:38:22 -0000 1.23
+++ marcin1.stable.out 30 Dec 2008 19:19:06 -0000 1.24
@@ -80,7 +80,7 @@
[ 5, 1 ]
[ 5, 2 ]
[ 5, 3 ]
-% sys.t1, sys.L7 # table_name
+% .t1, .L7 # table_name
% id, L7 # name
% int, int # type
% 1, 1 # length
U procedure_syntax.stable.out
Index: procedure_syntax.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/procedure_syntax.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- procedure_syntax.stable.out 21 Dec 2008 19:38:22 -0000 1.4
+++ procedure_syntax.stable.out 30 Dec 2008 19:19:06 -0000 1.5
@@ -20,7 +20,7 @@
# 01:17:48 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34904
# 01:17:48 >
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
@@ -28,7 +28,7 @@
[ "p1" ]
[ "p2" ]
[ "p3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
@@ -36,27 +36,27 @@
[ "p1" ]
[ "p2" ]
[ "p3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p2" ]
[ "p3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p2" ]
[ "p3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "p1" ]
[ "p3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
@@ -66,11 +66,11 @@
% int # type
% 1 # length
[ 1 ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 0 # length
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
U outerref_in_selection.stable.out
Index: outerref_in_selection.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/outerref_in_selection.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- outerref_in_selection.stable.out 7 Sep 2008 20:31:38 -0000 1.4
+++ outerref_in_selection.stable.out 30 Dec 2008 19:19:06 -0000 1.5
@@ -24,7 +24,7 @@
# 11:50:11 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < outerref_in_selection.sql
# 11:50:11 >
-% sys.b, sys.a # table_name
+% .b, .a # table_name
% cape_date, numppl # name
% date, wrd # type
% 10, 1 # length
U keys.stable.out
Index: keys.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/keys.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- keys.stable.out 7 Dec 2008 17:31:30 -0000 1.9
+++ keys.stable.out 30 Dec 2008 19:19:06 -0000 1.10
@@ -29,7 +29,7 @@
# 11:50:05 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35781 < keys.sql
# 11:50:05 >
-% sys.idxs, sys.idxs, sys.keys, sys.keys # table_name
+% .idxs, .idxs, .keys, .keys # table_name
% name, type, name, type # name
% varchar, int, varchar, int # type
% 27, 1, 10, 1 # length
U rank.stable.out
Index: rank.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/rank.stable.out,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- rank.stable.out 7 Dec 2008 19:35:55 -0000 1.19
+++ rank.stable.out 30 Dec 2008 19:19:06 -0000 1.20
@@ -25,7 +25,7 @@
# 20:30:44 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=39627
# 20:30:44 >
-% sys. # table_name
+% . # table_name
% foo # name
% int # type
% 2 # length
@@ -62,7 +62,7 @@
[ 31 ]
[ 32 ]
[ 33 ]
-% ., sys.tables # table_name
+% ., .tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
@@ -99,7 +99,7 @@
[ 25, 1061 ]
[ 26, 1061 ]
[ 27, 1061 ]
-% ., sys.tables # table_name
+% ., .tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
@@ -136,7 +136,7 @@
[ 25, 1061 ]
[ 26, 1061 ]
[ 27, 1061 ]
-% ., sys.tables # table_name
+% ., .tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
@@ -173,7 +173,7 @@
[ 31, 1162 ]
[ 32, 1162 ]
[ 33, 1162 ]
-% sys. # table_name
+% . # table_name
% foo # name
% int # type
% 2 # length
@@ -210,7 +210,7 @@
[ 31 ]
[ 32 ]
[ 33 ]
-% ., sys.tables # table_name
+% ., .tables # table_name
% foo, schema_id # name
% int, int # type
% 1, 4 # length
@@ -247,7 +247,7 @@
[ 1, 1162 ]
[ 1, 1162 ]
[ 1, 1162 ]
-% ., sys.tables # table_name
+% ., .tables # table_name
% foo, schema_id # name
% int, int # type
% 1, 4 # length
@@ -284,7 +284,7 @@
[ 1, 1162 ]
[ 1, 1162 ]
[ 1, 1162 ]
-% ., sys.tables # table_name
+% ., .tables # table_name
% foo, schema_id # name
% int, int # type
% 2, 4 # length
@@ -321,7 +321,7 @@
[ 28, 1162 ]
[ 28, 1162 ]
[ 28, 1162 ]
-% sys., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 3, 14, 11 # length
@@ -547,7 +547,7 @@
[ 220, "distance", "double" ]
[ 221, "objid", "bigint" ]
[ 222, "distance", "double" ]
-% ., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 1, 14, 11 # length
@@ -773,7 +773,7 @@
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-% ., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 1, 14, 11 # length
@@ -999,7 +999,7 @@
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-% ., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 3, 14, 11 # length
@@ -1225,7 +1225,7 @@
[ 220, "x", "double" ]
[ 221, "y", "double" ]
[ 222, "z", "double" ]
-% sys., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 3, 14, 11 # length
@@ -1451,7 +1451,7 @@
[ 220, "distance", "double" ]
[ 221, "objid", "bigint" ]
[ 222, "distance", "double" ]
-% ., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 1, 14, 11 # length
@@ -1677,7 +1677,7 @@
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-% ., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 1, 14, 11 # length
@@ -1903,7 +1903,7 @@
[ 1, "mode", "tinyint" ]
[ 1, "distance", "double" ]
[ 1, "distance", "double" ]
-% ., sys.columns, sys.columns # table_name
+% ., .columns, .columns # table_name
% foo, name, type # name
% int, varchar, varchar # type
% 2, 14, 11 # length
U function_syntax.stable.out
Index: function_syntax.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/function_syntax.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- function_syntax.stable.out 7 Dec 2008 17:31:30 -0000 1.2
+++ function_syntax.stable.out 30 Dec 2008 19:19:06 -0000 1.3
@@ -20,7 +20,7 @@
# 13:04:59 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=36428
# 13:04:59 >
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
@@ -28,7 +28,7 @@
[ "f1" ]
[ "f2" ]
[ "f3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
@@ -36,32 +36,32 @@
[ "f1" ]
[ "f2" ]
[ "f3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "f1" ]
[ "f2" ]
[ "f3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "f1" ]
[ "f2" ]
[ "f3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "f1" ]
[ "f3" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 2 # length
[ "f1" ]
-% sys.functions # table_name
+% .functions # table_name
% name # name
% varchar # type
% 0 # length
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
