Update of /cvsroot/monetdb/sql/src/test/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/Tests
Modified Files:
coalesce.stable.out count.stable.out marcin1.stable.out
procedure_syntax.stable.out psm.stable.out
restart-sequence.stable.out round.stable.out zones.stable.out
zones2.stable.out
Log Message:
algebra now has insert,update and delete operators.
mostly code moved from sql_updates.mx into rel_bin.mx
In the process, within functions we no longer output 'rows affected'
results of insert, update and deletes.
alter table use update instead insert now (column/idx bat with default
values is generated by the storage layer).
create user, now uses the table_funcs interface
same holds for granting and revoking privileges on tables.
This was needed to remove dependency on old insert/delete code.
U zones.stable.out
Index: zones.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/zones.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- zones.stable.out 7 Dec 2008 17:31:30 -0000 1.8
+++ zones.stable.out 21 Dec 2008 19:38:22 -0000 1.9
@@ -41,7 +41,7 @@
[ 5 ]
[ 0 ]
% .s # table_name
-% L3 # name
+% L12 # name
% wrd # type
% 1 # length
[ 3 ]
@@ -55,7 +55,7 @@
% bigint, double, double # type
% 1, 22, 22 # length
% . # table_name
-% single_value # name
+% fgetnearestobjidalleq_single_value # name
% bigint # type
% 1 # length
[ 0 ]
U marcin1.stable.out
Index: marcin1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/marcin1.stable.out,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -d -r1.22 -r1.23
--- marcin1.stable.out 9 Dec 2008 15:22:58 -0000 1.22
+++ marcin1.stable.out 21 Dec 2008 19:38:22 -0000 1.23
@@ -80,8 +80,8 @@
[ 5, 1 ]
[ 5, 2 ]
[ 5, 3 ]
-% sys.t1, sys.L3 # table_name
-% id, L3 # name
+% sys.t1, sys.L7 # table_name
+% id, L7 # name
% int, int # type
% 1, 1 # length
[ 1, 1 ]
@@ -89,8 +89,8 @@
[ 3, 3 ]
[ 4, NULL ]
[ 5, NULL ]
-% sys.t1, sys.L5 # table_name
-% id, L5 # name
+% sys.t1, sys.L11 # table_name
+% id, L11 # name
% int, int # type
% 1, 1 # length
[ 1, 3 ]
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.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- procedure_syntax.stable.out 7 Dec 2008 17:31:30 -0000 1.3
+++ procedure_syntax.stable.out 21 Dec 2008 19:38:22 -0000 1.4
@@ -61,7 +61,6 @@
% varchar # type
% 2 # length
[ "p1" ]
-[ 1 ]
% sys.t1 # table_name
% id # name
% int # type
U coalesce.stable.out
Index: coalesce.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/coalesce.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- coalesce.stable.out 7 Dec 2008 17:31:30 -0000 1.6
+++ coalesce.stable.out 21 Dec 2008 19:38:22 -0000 1.7
@@ -47,7 +47,7 @@
[ 1 ]
[ 1 ]
% sys. # table_name
-% L1 # name
+% L11 # name
% double # type
% 22 # length
[ 30.5 ]
@@ -68,7 +68,7 @@
[ 3, -1 ]
[ 4, -1 ]
% . # table_name
-% single_value # name
+% ifthenelse_not_isnull_NULL # name
% char # type
% 0 # length
[ "x" ]
U psm.stable.out
Index: psm.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/psm.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- psm.stable.out 7 Dec 2008 17:31:30 -0000 1.7
+++ psm.stable.out 21 Dec 2008 19:38:22 -0000 1.8
@@ -34,62 +34,62 @@
# 11:50:11 >
% . # table_name
-% single_value # name
+% my_abs_single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% my_abs_single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% my_abs1_single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% my_while_single_value # name
% int # type
% 2 # length
[ -5 ]
% . # table_name
-% single_value # name
+% my_declare_single_value # name
% int # type
% 3 # length
[ 105 ]
% . # table_name
-% single_value # name
+% my_complex_declare_single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% my_case_single_value # name
% int # type
% 3 # length
[ 100 ]
% . # table_name
-% single_value # name
+% my_case_single_value # name
% int # type
% 3 # length
[ 200 ]
% . # table_name
-% single_value # name
+% my_case_single_value # name
% int # type
% 2 # length
[ -1 ]
% . # table_name
-% single_value # name
+% my_searchcase_single_value # name
% int # type
% 3 # length
[ 100 ]
% . # table_name
-% single_value # name
+% my_searchcase_single_value # name
% int # type
% 3 # length
[ 200 ]
% . # table_name
-% single_value # name
+% my_searchcase_single_value # name
% int # type
% 2 # length
[ -1 ]
U count.stable.out
Index: count.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/count.stable.out,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -d -r1.16 -r1.17
--- count.stable.out 7 Dec 2008 17:31:30 -0000 1.16
+++ count.stable.out 21 Dec 2008 19:38:22 -0000 1.17
@@ -31,12 +31,12 @@
[ 1 ]
[ 1 ]
% sys.test # table_name
-% L1 # name
+% L2 # name
% wrd # type
% 1 # length
[ 6 ]
% sys.test # table_name
-% L2 # name
+% L3 # name
% wrd # type
% 1 # length
[ 5 ]
U restart-sequence.stable.out
Index: restart-sequence.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/restart-sequence.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- restart-sequence.stable.out 7 Dec 2008 17:31:30 -0000 1.9
+++ restart-sequence.stable.out 21 Dec 2008 19:38:22 -0000 1.10
@@ -36,12 +36,12 @@
% 6, 3, 1, 1, 1, 1, 1, 5 # length
[ "mytest", "sys", 1, 0, 0, 1, 1, false ]
% . # table_name
-% single_value # name
+% next_value_for_sys # name
% bigint # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% next_value_for_sys # name
% bigint # type
% 1 # length
[ 2 ]
@@ -56,12 +56,12 @@
% 6, 3, 2, 1, 1, 1, 1, 5 # length
[ "mytest", "sys", 10, 0, 0, 1, 1, false ]
% . # table_name
-% single_value # name
+% next_value_for_sys # name
% bigint # type
% 2 # length
[ 10 ]
% . # table_name
-% single_value # name
+% next_value_for_sys # name
% bigint # type
% 2 # length
[ 11 ]
U round.stable.out
Index: round.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/round.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- round.stable.out 7 Dec 2008 17:31:30 -0000 1.2
+++ round.stable.out 21 Dec 2008 19:38:22 -0000 1.3
@@ -26,27 +26,27 @@
# 15:17:09 >
% ., ., ., . # table_name
-% single_value, single_value, single_value, single_value # name
+% round_single_value, round_single_value, round_single_value,
round_single_value # name
% decimal, decimal, decimal, decimal # type
% 11, 11, 11, 11 # length
[ 750.00, 700.00, 1000.00, 0.00 ]
% ., . # table_name
-% single_value, single_value # name
+% round_single_value, round_single_value # name
% decimal, decimal # type
% 11, 11 # length
[ 123.9990, 124.0000 ]
% . # table_name
-% single_value # name
+% round_single_value # name
% decimal # type
% 11 # length
[ 123.4500 ]
% . # table_name
-% single_value # name
+% round_single_value # name
% decimal # type
% 11 # length
[ 100.00 ]
% . # table_name
-% single_value # name
+% round_single_value # name
% decimal # type
% 11 # length
[ 151.00 ]
U zones2.stable.out
Index: zones2.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/Tests/zones2.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- zones2.stable.out 7 Dec 2008 17:31:30 -0000 1.3
+++ zones2.stable.out 21 Dec 2008 19:38:22 -0000 1.4
@@ -26,12 +26,12 @@
# 20:47:05 >
% . # table_name
-% single_value # name
+% degrees_single_value # name
% double # type
% 22 # length
[ -5.7295779513082321 ]
% . # table_name
-% single_value # name
+% degrees_single_value # name
% double # type
% 22 # length
[ -5.7295779513082321 ]
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
