Changeset: dc0a27a37794 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dc0a27a37794 Added Files: clients/Tests/MAL-signatures.sql Removed Files: clients/Tests/MAL-signatures.malC Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 monetdb5/mal/mal_profiler.c monetdb5/modules/mal/tablet.c sql/backends/monet5/sql.c sql/backends/monet5/sql.mal sql/backends/monet5/sql_result.c sql/backends/monet5/sql_upgrades.c sql/scripts/75_storagemodel.sql sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/check.stable.out sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128 sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade/Tests/check.stable.out sql/test/emptydb-upgrade/Tests/check.stable.out.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.int128 sql/test/leaks/Tests/check0.stable.out sql/test/leaks/Tests/check0.stable.out.int128 sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5.stable.out.int128 sql/test/leaks/Tests/drop3.stable.out sql/test/leaks/Tests/drop3.stable.out.int128 sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select1.stable.out.int128 sql/test/leaks/Tests/select2.stable.out sql/test/leaks/Tests/select2.stable.out.int128 sql/test/leaks/Tests/temp1.stable.out sql/test/leaks/Tests/temp1.stable.out.int128 sql/test/leaks/Tests/temp2.stable.out sql/test/leaks/Tests/temp2.stable.out.int128 sql/test/leaks/Tests/temp3.stable.out sql/test/leaks/Tests/temp3.stable.out.int128 sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 tools/mserver/mserver5.c Branch: jit Log Message:
Merge with default diffs (truncated from 99801 to 300 lines): diff --git a/clients/Tests/MAL-signatures.malC b/clients/Tests/MAL-signatures.malC deleted file mode 100644 --- a/clients/Tests/MAL-signatures.malC +++ /dev/null @@ -1,1 +0,0 @@ -?*) diff --git a/clients/Tests/MAL-signatures.sql b/clients/Tests/MAL-signatures.sql new file mode 100644 --- /dev/null +++ b/clients/Tests/MAL-signatures.sql @@ -0,0 +1,1 @@ +select * from sys.malfunctions() order by module, "function", address, signature, comment; diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -15,32174 +15,8700 @@ stdout of test 'MAL-signatures` in direc # Visit http://www.monetdb.org/ for further information Ready. +# SQL catalog created, loading sql scripts once +# loading sql script: 09_like.sql +# loading sql script: 10_math.sql +# loading sql script: 11_times.sql +# loading sql script: 12_url.sql +# loading sql script: 13_date.sql +# loading sql script: 14_inet.sql +# loading sql script: 15_querylog.sql +# loading sql script: 16_tracelog.sql +# loading sql script: 17_temporal.sql +# loading sql script: 18_index.sql +# loading sql script: 20_vacuum.sql +# loading sql script: 21_dependency_functions.sql +# loading sql script: 22_clients.sql +# loading sql script: 23_skyserver.sql +# loading sql script: 24_zorder.sql +# loading sql script: 25_debug.sql +# loading sql script: 26_sysmon.sql +# loading sql script: 27_rejects.sql +# loading sql script: 39_analytics.sql +# loading sql script: 40_geom.sql +# loading sql script: 40_json.sql +# loading sql script: 41_md5sum.sql +# loading sql script: 45_uuid.sql +# loading sql script: 46_gsl.sql +# loading sql script: 46_profiler.sql +# loading sql script: 51_sys_schema_extension.sql +# loading sql script: 72_fits.sql +# loading sql script: 74_netcdf.sql +# loading sql script: 75_shp.sql +# loading sql script: 75_storagemodel.sql +# loading sql script: 80_statistics.sql +# loading sql script: 80_udf.sql +# loading sql script: 85_bam.sql +# loading sql script: 90_generator.sql +# loading sql script: 99_system.sql -# 17:25:33 > -# 17:25:33 > "mclient" "-lmal" "-ftest" "-Eutf-8" "--host=/var/tmp/mtest-25210" "--port=34276" -# 17:25:33 > +# 14:39:22 > +# 14:39:22 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-23085" "--port=30158" +# 14:39:22 > -command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) -address AGGRavg23_dbl; -comment Grouped tail average on dbl, also returns count - -command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]):bat[:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on dbl - -command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) -address AGGRavg23_dbl; -comment Grouped tail average on flt, also returns count - -command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on flt - -command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) -address AGGRavg23_dbl; -comment Grouped tail average on lng, also returns count - -command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]):bat[:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on lng - -command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) -address AGGRavg23_dbl; -comment Grouped tail average on int, also returns count - -command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on int - -command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) -address AGGRavg23_dbl; -comment Grouped tail average on sht, also returns count - -command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on sht - -command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]) (X_0:bat[:dbl],X_1:bat[:lng]) -address AGGRavg23_dbl; -comment Grouped tail average on bte, also returns count - -command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:dbl] -address AGGRavg13_dbl; -comment Grouped tail average on bte - -pattern aggr.avg(b:bat[:any_2]):dbl -address CMDcalcavg; -comment Gives the avg of all tail values - -function aggr.corr(e1:bat[:dbl],e2:bat[:dbl]):dbl; -function aggr.covar(e1:bat[:dbl],e2:bat[:dbl]):dbl; -function aggr.corr(e1:bat[:flt],e2:bat[:flt]):flt; -function aggr.covar(e1:bat[:flt],e2:bat[:flt]):flt; -function aggr.corr(e1:bat[:lng],e2:bat[:lng]):lng; -function aggr.covar(e1:bat[:lng],e2:bat[:lng]):lng; -function aggr.corr(e1:bat[:int],e2:bat[:int]):int; -function aggr.covar(e1:bat[:int],e2:bat[:int]):int; -function aggr.corr(e1:bat[:sht],e2:bat[:sht]):sht; -function aggr.covar(e1:bat[:sht],e2:bat[:sht]):sht; -function aggr.corr(e1:bat[:bte],e2:bat[:bte]):bte; -function aggr.covar(e1:bat[:bte],e2:bat[:bte]):bte; -command aggr.count_no_nil(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:lng] -address AGGRcount3nonils; -command aggr.count(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:lng] -address AGGRcount3nils; -comment Grouped count - -command aggr.count(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],ignorenils:bit):bat[:lng] -address AGGRcount3; -command aggr.cardinality(b:bat[:any_2]):lng -address ALGcard; -comment Return the cardinality of the BAT tail values. - -command aggr.count_no_nil(b:bat[:any_2]):lng -address ALGcount_no_nil; -comment Return the number of elements currently in a BAT ignoring BUNs with nil-tail - -command aggr.count(b:bat[:any],ignore_nils:bit):lng -address ALGcount_nil; -comment Return the number of elements currently in a BAT ignores BUNs with nil-tail iff ignore_nils==TRUE. - -command aggr.count(b:bat[:any]):lng -address ALGcount_bat; -comment Return the current size (in number of elements) in a BAT. - -command aggr.exist(b:bat[:any_2],h:any_1):bit -address ALGexist; -command aggr.jsonaggr(val:bat[:dbl]):str -address JSONgroupStr; -comment Aggregate the double values to array. - -command aggr.jsonaggr(val:bat[:str]):str -address JSONgroupStr; -comment Aggregate the string values to array. - -function aggr.median(b:bat[:any_1]):any_1; -command aggr.median(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:any_1] -address AGGRmedian3; -comment Grouped median aggregate - -command aggr.max(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:any_1] -address AGGRmax3; -command aggr.min(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:any_1] -address AGGRmin3; -command aggr.max(b:bat[:any_2]):any_2 -address ALGmaxany; -comment Return the highest tail value or nil. - -command aggr.min(b:bat[:any_2]):any_2 -address ALGminany; -comment Return the lowest tail value or nil. - -pattern aggr.prod(b:bat[:dbl],s:bat[:oid],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:dbl],s:bat[:oid]):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:dbl],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:dbl]):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:flt],s:bat[:oid],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:flt],s:bat[:oid]):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:flt],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:flt]):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:flt],s:bat[:oid],nil_if_empty:bit):flt -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:flt],s:bat[:oid]):flt -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:flt],nil_if_empty:bit):flt -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:flt]):flt -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:lng],s:bat[:oid],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:lng],s:bat[:oid]):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:lng],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:lng]):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:lng],s:bat[:oid],nil_if_empty:bit):lng -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:lng],s:bat[:oid]):lng -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:lng],nil_if_empty:bit):lng -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:lng]):lng -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:int],s:bat[:oid]):dbl -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:int],nil_if_empty:bit):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:int]):dbl -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):lng -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:int],s:bat[:oid]):lng -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:int],nil_if_empty:bit):lng -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:int]):lng -address CMDBATprod; -comment Calculate aggregate product of B. - -pattern aggr.prod(b:bat[:int],s:bat[:oid],nil_if_empty:bit):int -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:int],s:bat[:oid]):int -address CMDBATprod; -comment Calculate aggregate product of B with candidate list. - -pattern aggr.prod(b:bat[:int],nil_if_empty:bit):int -address CMDBATprod; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
