Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/BugTracker/Tests
Modified Files:
auto_increment.SF-1834820.stable.out
bat_descriptor_problem.SF-1997643.stable.out
convert_dec2varchar_crash.SF-1775550.stable.out
count_crash.SF-1918780.stable.out
full_join_crash.SF-1841754.stable.out
insert_not_exists.SF-1380287.stable.out
large_prepare_2.SF-1363729.stable.out
like_for_time_values.SF-1715659.stable.out
mdb_starts_with_sql_debug_64.SF-1999354.stable.out
orderby_in_function.SF-1892708.stable.out
proc_insert_into.SF-1958572.stable.out
rand_not_executed_for_every_row.SF-1723791.stable.out
schema_from_declared_table.SF-1983341.stable.out
select_mod.SF-1838813.stable.out
sql_prepare_prob.SF-1909638.stable.out
variable_names.SF-1838816.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 auto_increment.SF-1834820.stable.out
Index: auto_increment.SF-1834820.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/auto_increment.SF-1834820.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- auto_increment.SF-1834820.stable.out 7 Dec 2008 18:47:21 -0000
1.5
+++ auto_increment.SF-1834820.stable.out 21 Dec 2008 19:38:22 -0000
1.6
@@ -51,12 +51,12 @@
[ 1, "wendy", "Wendy\nWones" ]
[ 2, "fred", "Fred Flintstone" ]
% sys.sequences # table_name
-% L1 # name
+% L6 # name
% wrd # type
% 1 # length
[ 1 ]
% sys.sequences # table_name
-% L2 # name
+% L7 # name
% wrd # type
% 1 # length
[ 0 ]
U like_for_time_values.SF-1715659.stable.out
Index: like_for_time_values.SF-1715659.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/like_for_time_values.SF-1715659.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- like_for_time_values.SF-1715659.stable.out 7 Dec 2008 18:47:21 -0000
1.2
+++ like_for_time_values.SF-1715659.stable.out 21 Dec 2008 19:38:22 -0000
1.3
@@ -26,7 +26,7 @@
# 10:35:46 >
% . # table_name
-% single_value # name
+% current_timestamp # name
% boolean # type
% 5 # length
[ false ]
U variable_names.SF-1838816.stable.out
Index: variable_names.SF-1838816.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/variable_names.SF-1838816.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- variable_names.SF-1838816.stable.out 7 Dec 2008 18:47:21 -0000
1.3
+++ variable_names.SF-1838816.stable.out 21 Dec 2008 19:38:22 -0000
1.4
@@ -26,7 +26,7 @@
# 00:15:33 >
% . # table_name
-% single_value # name
+% foo_single_value # name
% int # type
% 1 # length
[ 2 ]
U insert_not_exists.SF-1380287.stable.out
Index: insert_not_exists.SF-1380287.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- insert_not_exists.SF-1380287.stable.out 7 Dec 2008 18:38:16 -0000
1.7
+++ insert_not_exists.SF-1380287.stable.out 21 Dec 2008 19:38:22 -0000
1.8
@@ -80,7 +80,7 @@
[ 1 ]
[ 1 ]
% sys.kwtemp # table_name
-% L1 # name
+% L5 # name
% wrd # type
% 2 # length
[ 20 ]
@@ -96,7 +96,7 @@
% 31 # length
[ "dropping kwTemp" ]
% sys.kwmtemp # table_name
-% L4 # name
+% L10 # name
% wrd # type
% 2 # length
[ 20 ]
@@ -112,12 +112,12 @@
% 27 # length
[ "dropping kwmTemp" ]
% ., sys.s4_keywords # table_name
-% single_value, L7 # name
+% single_value, L13 # name
% char, wrd # type
% 9, 2 # length
[ "expect 20", 20 ]
% ., sys.s4_kwm # table_name
-% single_value, L10 # name
+% single_value, L14 # name
% char, wrd # type
% 9, 2 # length
[ "expect 20", 20 ]
U count_crash.SF-1918780.stable.out
Index: count_crash.SF-1918780.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/count_crash.SF-1918780.stable.out,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- count_crash.SF-1918780.stable.out 7 Dec 2008 18:47:21 -0000 1.7
+++ count_crash.SF-1918780.stable.out 21 Dec 2008 19:38:22 -0000 1.8
@@ -28,7 +28,7 @@
[ 1 ]
[ 1 ]
% . # table_name
-% L1 # name
+% L2 # name
% wrd # type
% 1 # length
[ 3 ]
U full_join_crash.SF-1841754.stable.out
Index: full_join_crash.SF-1841754.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/full_join_crash.SF-1841754.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- full_join_crash.SF-1841754.stable.out 7 Dec 2008 18:47:21 -0000
1.4
+++ full_join_crash.SF-1841754.stable.out 21 Dec 2008 19:38:22 -0000
1.5
@@ -31,14 +31,14 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys.L1, sys.t1, sys.t2 # table_name
+% sys.L7, sys.t1, sys.t2 # table_name
% name, n, n # name
% clob, int, int # type
% 2, 2, 2 # length
[ "aa", 11, 12 ]
[ "bb", NULL, 22 ]
[ "dd", NULL, 42 ]
-% sys.L3, sys.t1, sys.t2, sys.t3 # table_name
+% sys.L11, sys.t1, sys.t2, sys.t3 # table_name
% name, n, n, n # name
% clob, int, int, int # type
% 2, 2, 2, 2 # length
@@ -46,7 +46,7 @@
[ "bb", NULL, 22, 23 ]
[ "dd", NULL, 42, NULL ]
[ "cc", NULL, NULL, 33 ]
-% sys.L4, sys.L4 # table_name
+% sys.L12, sys.L12 # table_name
% name, n # name
% clob, int # type
% 2, 2 # length
@@ -54,7 +54,7 @@
[ "aa", 12 ]
[ "bb", 22 ]
[ "dd", 42 ]
-% sys.L6, sys.L6 # table_name
+% sys.L14, sys.L14 # table_name
% name, n # name
% clob, int # type
% 2, 2 # length
U mdb_starts_with_sql_debug_64.SF-1999354.stable.out
Index: mdb_starts_with_sql_debug_64.SF-1999354.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- mdb_starts_with_sql_debug_64.SF-1999354.stable.out 7 Dec 2008 18:47:21
-0000 1.4
+++ mdb_starts_with_sql_debug_64.SF-1999354.stable.out 21 Dec 2008 19:38:22
-0000 1.5
@@ -13,7 +13,7 @@
# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34243/
# MonetDB/SQL module v2.24.0 loaded
% . # table_name
-% single_value # name
+% f2_single_value # name
% varchar # type
% 7 # length
[ "0004044" ]
U sql_prepare_prob.SF-1909638.stable.out
Index: sql_prepare_prob.SF-1909638.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- sql_prepare_prob.SF-1909638.stable.out 7 Dec 2008 18:47:21 -0000
1.2
+++ sql_prepare_prob.SF-1909638.stable.out 21 Dec 2008 19:38:22 -0000
1.3
@@ -25,17 +25,17 @@
# 13:44:41 >
% . # table_name
-% single_value # name
+% feq_single_value # name
% int # type
% 1 # length
[ 0 ]
% . # table_name
-% single_value # name
+% feq_single_value # name
% int # type
% 1 # length
[ 0 ]
% . # table_name
-% single_value # name
+% feq_single_value # name
% int # type
% 1 # length
[ 0 ]
U large_prepare_2.SF-1363729.stable.out
Index: large_prepare_2.SF-1363729.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/large_prepare_2.SF-1363729.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- large_prepare_2.SF-1363729.stable.out 7 Dec 2008 18:38:16 -0000
1.6
+++ large_prepare_2.SF-1363729.stable.out 21 Dec 2008 19:38:22 -0000
1.7
@@ -63,7 +63,7 @@
[ "int", 32, 0 ]
[ 1 ]
% sys.mytable # table_name
-% L1 # name
+% L47 # name
% wrd # type
% 1 # length
[ 1 ]
U schema_from_declared_table.SF-1983341.stable.out
Index: schema_from_declared_table.SF-1983341.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/schema_from_declared_table.SF-1983341.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- schema_from_declared_table.SF-1983341.stable.out 6 Jun 2008 11:54:53
-0000 1.3
+++ schema_from_declared_table.SF-1983341.stable.out 21 Dec 2008 19:38:22
-0000 1.4
@@ -24,12 +24,10 @@
# 20:40:19 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31624
# 20:40:19 >
-[ 0 ]
% .n, .n # table_name
% idd, aage # name
% int, int # type
% 1, 1 # length
-[ 0 ]
% .n, .n # table_name
% idd, aage # name
% int, int # type
U select_mod.SF-1838813.stable.out
Index: select_mod.SF-1838813.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/select_mod.SF-1838813.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- select_mod.SF-1838813.stable.out 7 Dec 2008 18:47:21 -0000 1.3
+++ select_mod.SF-1838813.stable.out 21 Dec 2008 19:38:22 -0000 1.4
@@ -25,12 +25,12 @@
# 00:15:33 >
% . # table_name
-% single_value # name
+% mod_single_value # name
% tinyint # type
% 1 # length
[ 2 ]
% . # table_name
-% single_value # name
+% mod_single_value # name
% decimal # type
% 5 # length
[ 2 ]
U proc_insert_into.SF-1958572.stable.out
Index: proc_insert_into.SF-1958572.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/proc_insert_into.SF-1958572.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- proc_insert_into.SF-1958572.stable.out 7 Dec 2008 18:47:21 -0000
1.6
+++ proc_insert_into.SF-1958572.stable.out 21 Dec 2008 19:38:22 -0000
1.7
@@ -37,10 +37,6 @@
% 1, 1, 1, 1, 1, 1, 9, 9, 1, 9,
9, 9, 1, 1, 9, 9, 9, 9, 1 # length
[ 1, 1, 1, 1, 1, 1, "first row", "first row",
1, "first row", "first row", "first row", 1, 1, "first
row", "first row", "first row", "first row", 1 ]
[ 2, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
% sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1, sys.proc_insert_into_t1,
sys.proc_insert_into_t1 # table_name
% timeid, a, b, c, d, e, f, g, h,
i, j, k, l, m, n, o, p, q, r # name
% int, int, int, int, int, int, varchar, varchar,
int, varchar, varchar, varchar, int, int,
varchar, varchar, varchar, varchar, int # type
@@ -52,7 +48,7 @@
[ 5, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ 6, 1, 1, 1, 1, 1, "first row", "first row",
1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
% sys.proc_insert_into_t1 # table_name
-% L1 # name
+% L23 # name
% wrd # type
% 1 # length
[ 6 ]
U rand_not_executed_for_every_row.SF-1723791.stable.out
Index: rand_not_executed_for_every_row.SF-1723791.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/rand_not_executed_for_every_row.SF-1723791.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- rand_not_executed_for_every_row.SF-1723791.stable.out 7 Dec 2008
18:47:21 -0000 1.4
+++ rand_not_executed_for_every_row.SF-1723791.stable.out 21 Dec 2008
19:38:22 -0000 1.5
@@ -30,7 +30,7 @@
[ 1 ]
[ 1 ]
% .a # table_name
-% L1 # name
+% L2 # name
% wrd # type
% 1 # length
[ 0 ]
U bat_descriptor_problem.SF-1997643.stable.out
Index: bat_descriptor_problem.SF-1997643.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/bat_descriptor_problem.SF-1997643.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- bat_descriptor_problem.SF-1997643.stable.out 13 Jul 2008 15:30:53
-0000 1.1
+++ bat_descriptor_problem.SF-1997643.stable.out 21 Dec 2008 19:38:22
-0000 1.2
@@ -24,7 +24,6 @@
# 17:22:53 > mclient -lsql -umonetdb -Pmonetdb --host=eir --port=33783
# 17:22:53 >
-[ 1 ]
% .n, .n # table_name
% fieldid, distance # name
% bigint, double # type
U orderby_in_function.SF-1892708.stable.out
Index: orderby_in_function.SF-1892708.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- orderby_in_function.SF-1892708.stable.out 7 Dec 2008 18:47:21 -0000
1.3
+++ orderby_in_function.SF-1892708.stable.out 21 Dec 2008 19:38:22 -0000
1.4
@@ -28,7 +28,7 @@
# 13:30:03 >
% . # table_name
-% single_value # name
+% check_video # name
% varchar # type
% 7 # length
[ "schemas" ]
U convert_dec2varchar_crash.SF-1775550.stable.out
Index: convert_dec2varchar_crash.SF-1775550.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/convert_dec2varchar_crash.SF-1775550.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- convert_dec2varchar_crash.SF-1775550.stable.out 7 Dec 2008 18:47:21
-0000 1.3
+++ convert_dec2varchar_crash.SF-1775550.stable.out 21 Dec 2008 19:38:22
-0000 1.4
@@ -31,7 +31,7 @@
% 7 # length
[ 11.456 ]
% . # table_name
-% single_value # name
+% concat_single_value # name
% char # type
% 0 # length
[ "11.456hi" ]
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
