Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/BugDay_2005-10-06_2.9.3/Tests
Modified Files:
basic_arithmetics.SF-922252.stable.out
bool_boolean.SF-935601.stable.out
cross_product.SF-1122802.stable.out
max_min_sum_null.SF-1123132.stable.out
multiple_select_on_view.SF-935639.stable.out
select_not_true.SF-1314945.stable.out
singleton_view.SF-933573.stable.out
slow_counting_1.SF-923709.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 bool_boolean.SF-935601.stable.out
Index: bool_boolean.SF-935601.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/bool_boolean.SF-935601.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- bool_boolean.SF-935601.stable.out 7 Dec 2008 17:45:46 -0000 1.4
+++ bool_boolean.SF-935601.stable.out 21 Dec 2008 19:38:22 -0000 1.5
@@ -26,17 +26,17 @@
# 11:50:34 >
% . # table_name
-% single_value # name
+% isnull_single_value # name
% boolean # type
% 5 # length
[ false ]
% . # table_name
-% single_value # name
+% isnull_single_value # name
% boolean # type
% 5 # length
[ true ]
% . # table_name
-% single_value # name
+% =_=_single_value # name
% boolean # type
% 5 # length
[ true ]
U slow_counting_1.SF-923709.stable.out
Index: slow_counting_1.SF-923709.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- slow_counting_1.SF-923709.stable.out 7 Dec 2008 17:45:47 -0000
1.6
+++ slow_counting_1.SF-923709.stable.out 21 Dec 2008 19:38:22 -0000
1.7
@@ -20,30 +20,13 @@
# 19:05:32 >
[ 1 ]
-[ 1 ]
-[ 2 ]
-[ 4 ]
-[ 8 ]
-[ 16 ]
-[ 32 ]
-[ 64 ]
-[ 128 ]
-[ 256 ]
-[ 512 ]
-[ 1024 ]
-[ 2048 ]
-[ 4096 ]
-[ 8192 ]
-[ 16384 ]
-[ 32768 ]
-[ 65536 ]
% . # table_name
-% single_value # name
+% gen_insert_single_value # name
% int # type
% 1 # length
[ 0 ]
% sys.slow_count # table_name
-% L1 # name
+% L2 # name
% wrd # type
% 6 # length
[ 131072 ]
U select_not_true.SF-1314945.stable.out
Index: select_not_true.SF-1314945.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/select_not_true.SF-1314945.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- select_not_true.SF-1314945.stable.out 7 Dec 2008 17:45:47 -0000
1.4
+++ select_not_true.SF-1314945.stable.out 21 Dec 2008 19:38:22 -0000
1.5
@@ -31,7 +31,7 @@
% 5 # length
[ false ]
% . # table_name
-% single_value # name
+% not_single_value # name
% boolean # type
% 5 # length
[ false ]
U singleton_view.SF-933573.stable.out
Index: singleton_view.SF-933573.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/singleton_view.SF-933573.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- singleton_view.SF-933573.stable.out 7 Dec 2008 17:45:47 -0000 1.5
+++ singleton_view.SF-933573.stable.out 21 Dec 2008 19:38:22 -0000 1.6
@@ -26,7 +26,7 @@
[ 4 ]
% sys.v_sv # table_name
-% L1 # name
+% L5 # name
% wrd # type
% 1 # length
[ 4 ]
U basic_arithmetics.SF-922252.stable.out
Index: basic_arithmetics.SF-922252.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/basic_arithmetics.SF-922252.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- basic_arithmetics.SF-922252.stable.out 7 Dec 2008 17:45:46 -0000
1.5
+++ basic_arithmetics.SF-922252.stable.out 21 Dec 2008 19:38:22 -0000
1.6
@@ -39,12 +39,12 @@
[ 2 ]
[ 3 ]
% . # table_name
-% single_value # name
+% <_single_value # name
% boolean # type
% 5 # length
[ true ]
% . # table_name
-% single_value # name
+% =_single_value # name
% boolean # type
% 5 # length
[ false ]
U multiple_select_on_view.SF-935639.stable.out
Index: multiple_select_on_view.SF-935639.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/multiple_select_on_view.SF-935639.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- multiple_select_on_view.SF-935639.stable.out 7 Dec 2008 17:45:47
-0000 1.6
+++ multiple_select_on_view.SF-935639.stable.out 21 Dec 2008 19:38:22
-0000 1.7
@@ -27,12 +27,12 @@
[ 1 ]
[ 1 ]
% sys.c # table_name
-% L1 # name
+% L2 # name
% wrd # type
% 1 # length
[ 2 ]
% sys.c # table_name
-% L2 # name
+% L3 # name
% wrd # type
% 1 # length
[ 2 ]
U cross_product.SF-1122802.stable.out
Index: cross_product.SF-1122802.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/cross_product.SF-1122802.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- cross_product.SF-1122802.stable.out 7 Dec 2008 17:45:46 -0000 1.6
+++ cross_product.SF-1122802.stable.out 21 Dec 2008 19:38:22 -0000 1.7
@@ -27,17 +27,17 @@
[ 20 ]
[ 20 ]
% sys.t1 # table_name
-% L1 # name
+% L51 # name
% wrd # type
% 2 # length
[ 20 ]
% sys.t2 # table_name
-% L2 # name
+% L52 # name
% wrd # type
% 2 # length
[ 20 ]
% sys.t1 # table_name
-% L3 # name
+% L53 # name
% wrd # type
% 3 # length
[ 400 ]
U max_min_sum_null.SF-1123132.stable.out
Index: max_min_sum_null.SF-1123132.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- max_min_sum_null.SF-1123132.stable.out 7 Dec 2008 17:45:47 -0000
1.7
+++ max_min_sum_null.SF-1123132.stable.out 21 Dec 2008 19:38:22 -0000
1.8
@@ -26,7 +26,7 @@
[ 3 ]
% sys.t1123132, sys.t1123132, sys.t1123132 # table_name
-% L1, L2, L3 # name
+% L4, L5, L6 # name
% int, int, wrd # type
% 1, 1, 1 # length
[ 1, 2, 3 ]
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
