Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/BugDay_2005-12-19_2.9.3/Tests
Modified Files:
NULL_in_CASE.SF-1211335.stable.out
aggregate_functions_with_limit.SF-1367127.stable.out
delete_cascade.SF-1296395.stable.out
interval_times_int.SF-1281996.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 aggregate_functions_with_limit.SF-1367127.stable.out
Index: aggregate_functions_with_limit.SF-1367127.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- aggregate_functions_with_limit.SF-1367127.stable.out 7 Dec 2008
18:33:11 -0000 1.5
+++ aggregate_functions_with_limit.SF-1367127.stable.out 21 Dec 2008
19:38:22 -0000 1.6
@@ -75,12 +75,12 @@
[ 1 ]
[ 1 ]
% sys. # table_name
-% L1 # name
+% L4 # name
% wrd # type
% 2 # length
[ 50 ]
% sys., sys.test_aggre_limit # table_name
-% type, L2 # name
+% type, L5 # name
% varchar, wrd # type
% 3, 2 # length
[ "int", 29 ]
U interval_times_int.SF-1281996.stable.out
Index: interval_times_int.SF-1281996.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/interval_times_int.SF-1281996.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- interval_times_int.SF-1281996.stable.out 7 Dec 2008 18:33:11 -0000
1.3
+++ interval_times_int.SF-1281996.stable.out 21 Dec 2008 19:38:22 -0000
1.4
@@ -26,12 +26,12 @@
# 11:51:15 >
% . # table_name
-% single_value # name
+% sql_mul_single_value # name
% sec_interval # type
% 0 # length
[ 2 ]
% . # table_name
-% single_value # name
+% sql_mul_single_value # name
% sec_interval # type
% 0 # length
[ 2 ]
U delete_cascade.SF-1296395.stable.out
Index: delete_cascade.SF-1296395.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- delete_cascade.SF-1296395.stable.out 7 Dec 2008 18:33:11 -0000
1.6
+++ delete_cascade.SF-1296395.stable.out 21 Dec 2008 19:38:22 -0000
1.7
@@ -24,7 +24,7 @@
[ 1 ]
[ 1 ]
% sys.b1296395 # table_name
-% L1 # name
+% L3 # name
% wrd # type
% 1 # length
[ 0 ]
U NULL_in_CASE.SF-1211335.stable.out
Index: NULL_in_CASE.SF-1211335.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- NULL_in_CASE.SF-1211335.stable.out 7 Dec 2008 18:33:11 -0000 1.6
+++ NULL_in_CASE.SF-1211335.stable.out 21 Dec 2008 19:38:22 -0000 1.7
@@ -26,34 +26,34 @@
# 11:50:59 >
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% tinyint # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% tinyint # type
-% 1 # length
+% 4 # length
[ NULL ]
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% tinyint # type
% 1 # length
[ 2 ]
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% tinyint # type
-% 1 # length
+% 4 # length
[ NULL ]
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% int # type
% 1 # length
[ 3 ]
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% int # type
-% 1 # length
+% 11 # length
[ NULL ]
# 11:35:46 >
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
