Changeset: eb2c2e43e340 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eb2c2e43e340
Added Files:
monetdb5/tests/BugTracker/Tests/stdev.Bug-3178.malC
sql/backends/monet5/rel_bin.c
sql/backends/monet5/rel_bin.h
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_statement.h
Removed Files:
monetdb5/tests/BugTracker/Tests/stdev.Bug-3178.mal
sql/server/rel_bin.c
sql/server/rel_bin.h
sql/server/sql_rel2bin.c
sql/server/sql_rel2bin.h
sql/server/sql_statement.c
sql/server/sql_statement.h
Modified Files:
monetdb5/modules/kernel/aggr.mal
monetdb5/modules/kernel/aggr.mal.sh
monetdb5/modules/mal/pcre.c
monetdb5/tests/BugTracker/Tests/stdev.Bug-3178.stable.out
sql/backends/monet5/Makefile.ag
sql/backends/monet5/sql.mx
sql/backends/monet5/sql_gencode.c
sql/include/sql_catalog.h
sql/scripts/39_analytics.sql
sql/server/Makefile.ag
sql/server/rel_psm.c
sql/server/rel_schema.h
sql/server/rel_sequence.h
sql/server/rel_updates.h
sql/server/sql_env.h
sql/server/sql_mvc.c
sql/server/sql_parser.h
sql/server/sql_privileges.c
sql/server/sql_scan.c
sql/server/sql_semantic.c
sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.sql
sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.stable.out
sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
sql/test/Dependencies/Tests/Dependencies.stable.out
sql/test/Tests/systemfunctions.stable.out
sql/test/leaks/Tests/check0.stable.out
sql/test/leaks/Tests/check1.stable.out
sql/test/leaks/Tests/check2.stable.out
sql/test/leaks/Tests/check3.stable.out
sql/test/leaks/Tests/check4.stable.out
sql/test/leaks/Tests/check5.stable.out
sql/test/mapi/Tests/php_monetdb.stable.out
testing/Mfilter.py.in
Branch: default
Log Message:
Merge with Feb2013 branch.
diffs (truncated from 2689 to 300 lines):
diff --git a/monetdb5/modules/kernel/aggr.mal b/monetdb5/modules/kernel/aggr.mal
--- a/monetdb5/modules/kernel/aggr.mal
+++ b/monetdb5/modules/kernel/aggr.mal
@@ -19,6 +19,15 @@
module aggr;
+command sum(b:bat[:oid,:bte], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
+address AGGRsum2_dbl
+comment "Sum over grouped tail sum on bte";
+
+command sum(b:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:dbl]
+address AGGRsum3_dbl
+comment "Grouped tail sum on bte";
+
command sum(b:bat[:oid,:bte], e:bat[:oid,:any_1]) :bat[:oid,:bte]
address AGGRsum2_bte
comment "Sum over grouped tail sum on bte";
@@ -189,14 +198,48 @@ command subprod(b:bat[:oid,:bte],g:bat[:
address AGGRsubprodcand_lng
comment "Grouped product aggregate with candidates list";
-command sum(b:bat[:oid,:bte], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
+command sum(b:bat[:oid,:sht], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
address AGGRsum2_dbl
-comment "Sum over grouped tail sum on bte";
+comment "Sum over grouped tail sum on sht";
-command sum(b:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+command sum(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1])
:bat[:oid,:dbl]
address AGGRsum3_dbl
-comment "Grouped tail sum on bte";
+comment "Grouped tail sum on sht";
+
+command sum(b:bat[:oid,:sht], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRsum2_bte
+comment "Sum over grouped tail sum on sht";
+
+command sum(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:bte]
+address AGGRsum3_bte
+comment "Grouped tail sum on sht";
+
+command
subsum(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubsum_bte
+comment "Grouped sum aggregate";
+
+command
subsum(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubsumcand_bte
+comment "Grouped sum aggregate with candidates list";
+
+command product(b:bat[:oid,:sht], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRprod2_bte
+comment "Product over grouped tail product on sht";
+
+command product(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:bte]
+address AGGRprod3_bte
+comment "Grouped tail product on sht";
+
+command
subprod(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubprod_bte
+comment "Grouped product aggregate";
+
+command
subprod(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubprodcand_bte
+comment "Grouped product aggregate with candidates list";
command sum(b:bat[:oid,:sht], e:bat[:oid,:any_1]) :bat[:oid,:sht]
address AGGRsum2_sht
@@ -334,14 +377,82 @@ command subprod(b:bat[:oid,:sht],g:bat[:
address AGGRsubprodcand_lng
comment "Grouped product aggregate with candidates list";
-command sum(b:bat[:oid,:sht], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
+command sum(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
address AGGRsum2_dbl
-comment "Sum over grouped tail sum on sht";
+comment "Sum over grouped tail sum on int";
-command sum(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+command sum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1])
:bat[:oid,:dbl]
address AGGRsum3_dbl
-comment "Grouped tail sum on sht";
+comment "Grouped tail sum on int";
+
+command sum(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRsum2_bte
+comment "Sum over grouped tail sum on int";
+
+command sum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:bte]
+address AGGRsum3_bte
+comment "Grouped tail sum on int";
+
+command
subsum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubsum_bte
+comment "Grouped sum aggregate";
+
+command
subsum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubsumcand_bte
+comment "Grouped sum aggregate with candidates list";
+
+command product(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRprod2_bte
+comment "Product over grouped tail product on int";
+
+command product(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:bte]
+address AGGRprod3_bte
+comment "Grouped tail product on int";
+
+command
subprod(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubprod_bte
+comment "Grouped product aggregate";
+
+command
subprod(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubprodcand_bte
+comment "Grouped product aggregate with candidates list";
+
+command sum(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:sht]
+address AGGRsum2_sht
+comment "Sum over grouped tail sum on int";
+
+command sum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:sht]
+address AGGRsum3_sht
+comment "Grouped tail sum on int";
+
+command
subsum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubsum_sht
+comment "Grouped sum aggregate";
+
+command
subsum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubsumcand_sht
+comment "Grouped sum aggregate with candidates list";
+
+command product(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:sht]
+address AGGRprod2_sht
+comment "Product over grouped tail product on int";
+
+command product(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:sht]
+address AGGRprod3_sht
+comment "Grouped tail product on int";
+
+command
subprod(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubprod_sht
+comment "Grouped product aggregate";
+
+command
subprod(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubprodcand_sht
+comment "Grouped product aggregate with candidates list";
command sum(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:int]
address AGGRsum2_int
@@ -445,14 +556,116 @@ command subprod(b:bat[:oid,:int],g:bat[:
address AGGRsubprodcand_lng
comment "Grouped product aggregate with candidates list";
-command sum(b:bat[:oid,:int], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
+command sum(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
address AGGRsum2_dbl
-comment "Sum over grouped tail sum on int";
+comment "Sum over grouped tail sum on wrd";
-command sum(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+command sum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
:bat[:oid,:dbl]
address AGGRsum3_dbl
-comment "Grouped tail sum on int";
+comment "Grouped tail sum on wrd";
+
+command sum(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRsum2_bte
+comment "Sum over grouped tail sum on wrd";
+
+command sum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:bte]
+address AGGRsum3_bte
+comment "Grouped tail sum on wrd";
+
+command
subsum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubsum_bte
+comment "Grouped sum aggregate";
+
+command
subsum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubsumcand_bte
+comment "Grouped sum aggregate with candidates list";
+
+command product(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRprod2_bte
+comment "Product over grouped tail product on wrd";
+
+command product(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:bte]
+address AGGRprod3_bte
+comment "Grouped tail product on wrd";
+
+command
subprod(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubprod_bte
+comment "Grouped product aggregate";
+
+command
subprod(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:bte]
+address AGGRsubprodcand_bte
+comment "Grouped product aggregate with candidates list";
+
+command sum(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:sht]
+address AGGRsum2_sht
+comment "Sum over grouped tail sum on wrd";
+
+command sum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:sht]
+address AGGRsum3_sht
+comment "Grouped tail sum on wrd";
+
+command
subsum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubsum_sht
+comment "Grouped sum aggregate";
+
+command
subsum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubsumcand_sht
+comment "Grouped sum aggregate with candidates list";
+
+command product(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:sht]
+address AGGRprod2_sht
+comment "Product over grouped tail product on wrd";
+
+command product(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:sht]
+address AGGRprod3_sht
+comment "Grouped tail product on wrd";
+
+command
subprod(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubprod_sht
+comment "Grouped product aggregate";
+
+command
subprod(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:sht]
+address AGGRsubprodcand_sht
+comment "Grouped product aggregate with candidates list";
+
+command sum(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:int]
+address AGGRsum2_int
+comment "Sum over grouped tail sum on wrd";
+
+command sum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:int]
+address AGGRsum3_int
+comment "Grouped tail sum on wrd";
+
+command
subsum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:int]
+address AGGRsubsum_int
+comment "Grouped sum aggregate";
+
+command
subsum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:int]
+address AGGRsubsumcand_int
+comment "Grouped sum aggregate with candidates list";
+
+command product(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:int]
+address AGGRprod2_int
+comment "Product over grouped tail product on wrd";
+
+command product(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+ :bat[:oid,:int]
+address AGGRprod3_int
+comment "Grouped tail product on wrd";
+
+command
subprod(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],skip_nils:int,abort_on_error:int)
:bat[:oid,:int]
+address AGGRsubprod_int
+comment "Grouped product aggregate";
+
+command
subprod(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1],s:bat[:oid,:oid],skip_nils:int,abort_on_error:int)
:bat[:oid,:int]
+address AGGRsubprodcand_int
+comment "Grouped product aggregate with candidates list";
command sum(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:wrd]
address AGGRsum2_wrd
@@ -522,14 +735,150 @@ command subprod(b:bat[:oid,:wrd],g:bat[:
address AGGRsubprodcand_lng
comment "Grouped product aggregate with candidates list";
-command sum(b:bat[:oid,:wrd], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
+command sum(b:bat[:oid,:lng], e:bat[:oid,:any_1]) :bat[:oid,:dbl]
address AGGRsum2_dbl
-comment "Sum over grouped tail sum on wrd";
+comment "Sum over grouped tail sum on lng";
-command sum(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1])
+command sum(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1])
:bat[:oid,:dbl]
address AGGRsum3_dbl
-comment "Grouped tail sum on wrd";
+comment "Grouped tail sum on lng";
+
+command sum(b:bat[:oid,:lng], e:bat[:oid,:any_1]) :bat[:oid,:bte]
+address AGGRsum2_bte
+comment "Sum over grouped tail sum on lng";
_______________________________________________
checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
