Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/BugDay_2005-11-09_2.9.3/Tests
Modified Files:
date_functions.SF-967145.stable.out
interval_on_time_stamp.SF-1080488.stable.out
like_doesnot_like_strings.SF-1076605.stable.out
sql_server_abort.SF-1080025.stable.out
sql_server_crash.SF-1080024.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 date_functions.SF-967145.stable.out
Index: date_functions.SF-967145.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- date_functions.SF-967145.stable.out 7 Dec 2008 18:30:28 -0000 1.4
+++ date_functions.SF-967145.stable.out 21 Dec 2008 19:38:22 -0000 1.5
@@ -26,12 +26,12 @@
# 11:50:50 >
% . # table_name
-% single_value # name
+% sql_sub_current_date # name
% int # type
% 1 # length
[ 0 ]
% . # table_name
-% single_value # name
+% sql_sub_current_date # name
% int # type
% 1 # length
[ 0 ]
U like_doesnot_like_strings.SF-1076605.stable.out
Index: like_doesnot_like_strings.SF-1076605.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- like_doesnot_like_strings.SF-1076605.stable.out 7 Dec 2008 18:30:29
-0000 1.6
+++ like_doesnot_like_strings.SF-1076605.stable.out 21 Dec 2008 19:38:22
-0000 1.7
@@ -28,7 +28,7 @@
# 11:50:53 >
% . # table_name
-% single_value # name
+% like_single_value # name
% boolean # type
% 5 # length
[ true ]
U sql_server_abort.SF-1080025.stable.out
Index: sql_server_abort.SF-1080025.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- sql_server_abort.SF-1080025.stable.out 7 Dec 2008 18:30:29 -0000
1.4
+++ sql_server_abort.SF-1080025.stable.out 21 Dec 2008 19:38:22 -0000
1.5
@@ -28,7 +28,7 @@
# 11:50:54 >
% . # table_name
-% single_value # name
+% or_<_single_value # name
% boolean # type
% 5 # length
[ false ]
U sql_server_crash.SF-1080024.stable.out
Index: sql_server_crash.SF-1080024.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- sql_server_crash.SF-1080024.stable.out 7 Dec 2008 18:30:29 -0000
1.4
+++ sql_server_crash.SF-1080024.stable.out 21 Dec 2008 19:38:22 -0000
1.5
@@ -26,7 +26,7 @@
# 11:50:54 >
% . # table_name
-% single_value # name
+% ifthenelse_=_single_value # name
% char # type
% 0 # length
[ NULL ]
U interval_on_time_stamp.SF-1080488.stable.out
Index: interval_on_time_stamp.SF-1080488.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- interval_on_time_stamp.SF-1080488.stable.out 7 Dec 2008 18:30:29
-0000 1.9
+++ interval_on_time_stamp.SF-1080488.stable.out 21 Dec 2008 19:38:22
-0000 1.10
@@ -25,42 +25,42 @@
# 11:50:55 >
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% date # type
% 10 # length
[ 1997-08-31 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% date # type
% 10 # length
[ 1997-12-01 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% timestamp # type
% 26 # length
[ 1997-07-16 04:00:00.000000 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% time # type
% 15 # length
[ 04:00:00.000000 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% date # type
% 10 # length
[ 1997-07-31 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% month_interval # type
% 0 # length
[ 0 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% sec_interval # type
% 0 # length
[ 0 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% sec_interval # type
% 0 # length
[ 11640 ]
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
