Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/test/bugs/Tests
Modified Files:
arith-bug-sf-949228.stable.out
create_insert_select_aggr-bug-00001.stable.out
date_parsing-bug-sf-960166.stable.out
dbl_sht_cast_bug.stable.out distinct_count.stable.out
div_zero_bug.stable.out escape_quote-bug-sf-1006469.stable.out
extract_interval_bug-sf-1274088.stable.out
float2dec.stable.out
float_arith_cast2int-bug-sf-949255.stable.out
floor-bug-sf-967066.stable.out
innerjoin_between-bug-sf-960672.stable.out
interval_data_commutative_add_bug-sf-1263928.stable.out
seconds2timestamp.stable.out
select_constant_from_where_1=1-bug-sf-1019529.stable.out
select_into.stable.out
timestamp_comparison-bug-sf-1158581.stable.out
zero_or_one_bug.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_parsing-bug-sf-960166.stable.out
Index: date_parsing-bug-sf-960166.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/date_parsing-bug-sf-960166.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- date_parsing-bug-sf-960166.stable.out 7 Dec 2008 19:27:22 -0000
1.4
+++ date_parsing-bug-sf-960166.stable.out 21 Dec 2008 19:38:23 -0000
1.5
@@ -26,12 +26,12 @@
# 11:55:35 >
% . # table_name
-% single_value # name
+% =_current_date # name
% boolean # type
% 5 # length
[ false ]
% . # table_name
-% single_value # name
+% =_current_date # name
% boolean # type
% 5 # length
[ false ]
U float_arith_cast2int-bug-sf-949255.stable.out
Index: float_arith_cast2int-bug-sf-949255.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/float_arith_cast2int-bug-sf-949255.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- float_arith_cast2int-bug-sf-949255.stable.out 7 Dec 2008 19:27:22
-0000 1.4
+++ float_arith_cast2int-bug-sf-949255.stable.out 21 Dec 2008 19:38:23
-0000 1.5
@@ -35,7 +35,7 @@
% 22 # length
[ 1 ]
% . # table_name
-% single_value # name
+% sql_div_single_value # name
% int # type
% 1 # length
[ 1 ]
U distinct_count.stable.out
Index: distinct_count.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/distinct_count.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- distinct_count.stable.out 7 Dec 2008 19:27:22 -0000 1.5
+++ distinct_count.stable.out 21 Dec 2008 19:38:23 -0000 1.6
@@ -28,7 +28,7 @@
[ 1 ]
[ 1 ]
% sys.tabool # table_name
-% L1 # name
+% L5 # name
% wrd # type
% 1 # length
[ 3 ]
U innerjoin_between-bug-sf-960672.stable.out
Index: innerjoin_between-bug-sf-960672.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/innerjoin_between-bug-sf-960672.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- innerjoin_between-bug-sf-960672.stable.out 7 Dec 2008 19:27:22 -0000
1.5
+++ innerjoin_between-bug-sf-960672.stable.out 21 Dec 2008 19:38:23 -0000
1.6
@@ -31,13 +31,13 @@
[ 1 ]
[ 1 ]
% sys.h, sys.h, sys.h # table_name
-% a, b, L1 # name
+% a, b, L4 # name
% int, int, wrd # type
% 2, 2, 1 # length
[ 0, 10, 2 ]
[ 10, 20, 1 ]
% sys.h, sys.h, sys.h # table_name
-% a, b, L2 # name
+% a, b, L5 # name
% int, int, wrd # type
% 2, 2, 1 # length
[ 0, 10, 2 ]
U interval_data_commutative_add_bug-sf-1263928.stable.out
Index: interval_data_commutative_add_bug-sf-1263928.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/interval_data_commutative_add_bug-sf-1263928.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- interval_data_commutative_add_bug-sf-1263928.stable.out 7 Dec 2008
19:27:22 -0000 1.4
+++ interval_data_commutative_add_bug-sf-1263928.stable.out 21 Dec 2008
19:38:23 -0000 1.5
@@ -26,12 +26,12 @@
# 11:55:47 >
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% date # type
% 10 # length
[ 2005-08-20 ]
% . # table_name
-% single_value # name
+% sql_add_single_value # name
% date # type
% 10 # length
[ 2005-08-20 ]
U select_constant_from_where_1=1-bug-sf-1019529.stable.out
Index: select_constant_from_where_1=1-bug-sf-1019529.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/select_constant_from_where_1=1-bug-sf-1019529.stable.out,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -d -r1.16 -r1.17
--- select_constant_from_where_1=1-bug-sf-1019529.stable.out 7 Dec 2008
19:27:22 -0000 1.16
+++ select_constant_from_where_1=1-bug-sf-1019529.stable.out 21 Dec 2008
19:38:23 -0000 1.17
@@ -61,17 +61,17 @@
% 1 # length
[ 1 ]
% ., sys.t1019529 # table_name
-% single_value, L1 # name
+% single_value, L4 # name
% tinyint, wrd # type
% 1, 1 # length
[ 1, 3 ]
% ., sys.t1019529 # table_name
-% single_value, L2 # name
+% single_value, L5 # name
% tinyint, wrd # type
% 1, 1 # length
[ 1, 0 ]
% ., . # table_name
-% single_value, L3 # name
+% single_value, L6 # name
% tinyint, wrd # type
% 1, 1 # length
[ 1, 0 ]
U extract_interval_bug-sf-1274088.stable.out
Index: extract_interval_bug-sf-1274088.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/extract_interval_bug-sf-1274088.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- extract_interval_bug-sf-1274088.stable.out 7 Dec 2008 19:27:22 -0000
1.4
+++ extract_interval_bug-sf-1274088.stable.out 21 Dec 2008 19:38:23 -0000
1.5
@@ -26,22 +26,22 @@
# 11:55:48 >
% . # table_name
-% single_value # name
+% year_single_value # name
% int # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% day_single_value # name
% bigint # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% day_single_value # name
% bigint # type
% 1 # length
[ 1 ]
% . # table_name
-% single_value # name
+% hour_single_value # name
% int # type
% 1 # length
[ 1 ]
U zero_or_one_bug.stable.out
Index: zero_or_one_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/zero_or_one_bug.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- zero_or_one_bug.stable.out 7 Dec 2008 19:27:22 -0000 1.3
+++ zero_or_one_bug.stable.out 21 Dec 2008 19:38:23 -0000 1.4
@@ -33,8 +33,8 @@
[ 1 ]
[ 1 ]
[ 1 ]
-% sys., sys.L2 # table_name
-% ifthenelse_not_isnull_id1, L2 # name
+% sys., sys.L5 # table_name
+% ifthenelse_not_isnull_id1, L5 # name
% int, varchar # type
% 1, 1 # length
[ 1, NULL ]
@@ -46,7 +46,7 @@
[ 7, NULL ]
[ 8, NULL ]
[ 9, NULL ]
-% sys., sys.L4 # table_name
+% sys., sys.L7 # table_name
% ifthenelse_not_isnull_id1, my_col1 # name
% int, varchar # type
% 1, 1 # length
U escape_quote-bug-sf-1006469.stable.out
Index: escape_quote-bug-sf-1006469.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/escape_quote-bug-sf-1006469.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- escape_quote-bug-sf-1006469.stable.out 7 Dec 2008 19:27:22 -0000
1.5
+++ escape_quote-bug-sf-1006469.stable.out 21 Dec 2008 19:38:23 -0000
1.6
@@ -29,7 +29,7 @@
# 11:55:41 >
% . # table_name
-% single_value # name
+% char_length_single_value # name
% int # type
% 1 # length
[ 1 ]
U seconds2timestamp.stable.out
Index: seconds2timestamp.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/seconds2timestamp.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- seconds2timestamp.stable.out 7 Dec 2008 19:27:22 -0000 1.4
+++ seconds2timestamp.stable.out 21 Dec 2008 19:38:23 -0000 1.5
@@ -28,17 +28,17 @@
# 22:40:46 >
% . # table_name
-% single_value # name
+% epoch_single_value # name
% timestamp # type
% 26 # length
[ 2004-06-17 16:00:00.000000 ]
% . # table_name
-% single_value # name
+% epoch_single_value # name
% int # type
% 10 # length
[ 1087488000 ]
% . # table_name
-% single_value # name
+% epoch_single_value # name
% int # type
% 10 # length
[ 1203170400 ]
@@ -49,7 +49,7 @@
% 10, 26 # length
[ 1202900916, 2008-02-13 11:08:06.000000 ]
% . # table_name
-% single_value # name
+% epoch_single_value # name
% timestamp # type
% 26 # length
[ 2008-02-16 14:00:00.000000 ]
U dbl_sht_cast_bug.stable.out
Index: dbl_sht_cast_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/dbl_sht_cast_bug.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- dbl_sht_cast_bug.stable.out 7 Dec 2008 19:27:22 -0000 1.4
+++ dbl_sht_cast_bug.stable.out 21 Dec 2008 19:38:23 -0000 1.5
@@ -26,7 +26,7 @@
[ 1 ]
% sys.dbl_sht_cast_bug # table_name
-% L1 # name
+% L4 # name
% wrd # type
% 1 # length
[ 0 ]
U div_zero_bug.stable.out
Index: div_zero_bug.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/div_zero_bug.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- div_zero_bug.stable.out 7 Dec 2008 19:27:22 -0000 1.3
+++ div_zero_bug.stable.out 21 Dec 2008 19:38:23 -0000 1.4
@@ -29,7 +29,7 @@
[ 1 ]
[ 1 ]
% sys.div_zero_bug, sys.div_zero_bug # table_name
-% grp, L1 # name
+% grp, L3 # name
% int, double # type
% 1, 22 # length
[ NULL, 1 ]
U timestamp_comparison-bug-sf-1158581.stable.out
Index: timestamp_comparison-bug-sf-1158581.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/timestamp_comparison-bug-sf-1158581.stable.out,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- timestamp_comparison-bug-sf-1158581.stable.out 7 Dec 2008 19:27:22
-0000 1.6
+++ timestamp_comparison-bug-sf-1158581.stable.out 21 Dec 2008 19:38:23
-0000 1.7
@@ -41,7 +41,7 @@
% 26, 26 # length
[ 2004-12-27 16:29:57.409000, 9999-12-31 00:00:00.000000 ]
% sys.datetest, sys. # table_name
-% L1, L2 # name
+% L3, L4 # name
% timestamp, timestamp # type
% 26, 20 # length
[ 2004-12-27 16:29:57.409000, 2004-12-27 16:29:57 ]
U float2dec.stable.out
Index: float2dec.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/float2dec.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- float2dec.stable.out 7 Dec 2008 19:27:22 -0000 1.3
+++ float2dec.stable.out 21 Dec 2008 19:38:23 -0000 1.4
@@ -21,7 +21,7 @@
[ 1 ]
% sys. # table_name
-% L1 # name
+% L2 # name
% decimal # type
% 6 # length
[ 74.95 ]
U create_insert_select_aggr-bug-00001.stable.out
Index: create_insert_select_aggr-bug-00001.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.out,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -d -r1.17 -r1.18
--- create_insert_select_aggr-bug-00001.stable.out 7 Dec 2008 18:53:30
-0000 1.17
+++ create_insert_select_aggr-bug-00001.stable.out 21 Dec 2008 19:38:23
-0000 1.18
@@ -68,7 +68,7 @@
[ 1, "Tim" ]
[ 2, "Jochem" ]
% . # table_name
-% single_value # name
+% sql_sub_single_value # name
% smallint # type
% 2 # length
[ 15 ]
U arith-bug-sf-949228.stable.out
Index: arith-bug-sf-949228.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/arith-bug-sf-949228.stable.out,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- arith-bug-sf-949228.stable.out 7 Dec 2008 19:27:22 -0000 1.5
+++ arith-bug-sf-949228.stable.out 21 Dec 2008 19:38:23 -0000 1.6
@@ -26,27 +26,27 @@
# 11:55:32 >
% . # table_name
-% single_value # name
+% sql_div_single_value # name
% decimal # type
% 11 # length
[ 1.0000 ]
% . # table_name
-% single_value # name
+% sql_div_single_value # name
% decimal # type
% 11 # length
[ 0.9999 ]
% . # table_name
-% single_value # name
+% sql_div_single_value # name
% decimal # type
% 13 # length
[ 1.00000 ]
% . # table_name
-% single_value # name
+% sql_div_single_value # name
% decimal # type
% 3 # length
[ 10 ]
% . # table_name
-% single_value # name
+% sql_mul_single_value # name
% int # type
% 7 # length
[ 1000000 ]
U select_into.stable.out
Index: select_into.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/bugs/Tests/select_into.stable.out,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- select_into.stable.out 7 Dec 2008 19:27:22 -0000 1.3
+++ select_into.stable.out 21 Dec 2008 19:38:23 -0000 1.4
@@ -26,7 +26,7 @@
[ 1 ]
% . # table_name
-% single_value # name
+% test5 # name
% int # type
% 1 # length
[ 5 ]
U floor-bug-sf-967066.stable.out
Index: floor-bug-sf-967066.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/bugs/Tests/floor-bug-sf-967066.stable.out,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- floor-bug-sf-967066.stable.out 7 Dec 2008 19:27:22 -0000 1.4
+++ floor-bug-sf-967066.stable.out 21 Dec 2008 19:38:23 -0000 1.5
@@ -26,7 +26,7 @@
# 11:55:37 >
% . # table_name
-% single_value # name
+% floor_single_value # name
% real # type
% 13 # length
[ 3 ]
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
