Changeset: 89db305444ed for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=89db305444ed Modified Files: clients/Tests/MAL-signatures_all.stable.out clients/Tests/MAL-signatures_fits_geom.stable.out clients/Tests/MAL-signatures_fits_geom.stable.out.int128 clients/Tests/MAL-signatures_geom.stable.out clients/Tests/MAL-signatures_geom.stable.out.int128 clients/Tests/MAL-signatures_none.stable.out clients/Tests/MAL-signatures_none.stable.out.int128 clients/Tests/SQL-dump_all.stable.out clients/Tests/SQL-dump_all.stable.out.oid32 clients/Tests/SQL-dump_all.stable.out.oid32.int128 clients/Tests/SQL-dump_geom.stable.out clients/Tests/SQL-dump_geom.stable.out.32bit clients/Tests/SQL-dump_geom.stable.out.64bit.oid32 clients/Tests/SQL-dump_geom.stable.out.int128 clients/Tests/SQL-dump_geom.stable.out.oid32.int128 clients/Tests/SQL-dump_none.stable.out clients/Tests/SQL-dump_none.stable.out.int128 Branch: default Log Message:
Approvals. diffs (truncated from 54414 to 300 lines): diff --git a/clients/Tests/MAL-signatures_all.stable.out b/clients/Tests/MAL-signatures_all.stable.out --- a/clients/Tests/MAL-signatures_all.stable.out +++ b/clients/Tests/MAL-signatures_all.stable.out @@ -37888,10 +37888,6 @@ pattern fits.listdir(dirname:str):void address FITSdir; comment Attach all FITS files in the directory -pattern generator.join(b:bat[:oid,:hge],gen:bat[:oid,:hge]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) -address VLTgenerator_join; -comment Overloaded join operation - pattern generator.join(gen:bat[:oid,:dbl],low:bat[:oid,:dbl],hgh:bat[:oid,:dbl],li:bit,ri:bit) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address VLTgenerator_rangejoin; comment Overloaded range join operation diff --git a/clients/Tests/MAL-signatures_fits_geom.stable.out b/clients/Tests/MAL-signatures_fits_geom.stable.out --- a/clients/Tests/MAL-signatures_fits_geom.stable.out +++ b/clients/Tests/MAL-signatures_fits_geom.stable.out @@ -39479,6 +39479,10 @@ command mtime.date_add_month_interval(t: address MTIMEdate_addmonths; comment Add months to a date +command mtime.diff(val1:daytime,val2:daytime):lng +address MTIMEdaytime_diff; +comment returns the number of msec between 'val1' and 'val2'. + command mtime.date_add_msec_interval(t:date,ms:lng):date address MTIMEdate_add_msec_interval_lng_wrap; command mtime.date_add_sec_interval(t:date,s:int):date diff --git a/clients/Tests/MAL-signatures_fits_geom.stable.out.int128 b/clients/Tests/MAL-signatures_fits_geom.stable.out.int128 --- a/clients/Tests/MAL-signatures_fits_geom.stable.out.int128 +++ b/clients/Tests/MAL-signatures_fits_geom.stable.out.int128 @@ -48697,6 +48697,10 @@ pattern fits.listdir(dirname:str):void address FITSdir; comment Attach all FITS files in the directory +pattern generator.join(b:bat[:oid,:hge],gen:bat[:oid,:hge]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) +address VLTgenerator_join; +comment Overloaded join operation + pattern generator.join(gen:bat[:oid,:dbl],low:bat[:oid,:dbl],hgh:bat[:oid,:dbl],li:bit,ri:bit) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address VLTgenerator_rangejoin; comment Overloaded range join operation @@ -48725,9 +48729,9 @@ pattern generator.join(b:bat[:oid,:sht], address VLTgenerator_join; pattern generator.join(b:bat[:oid,:bte],gen:bat[:oid,:bte]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address VLTgenerator_join; -pattern generator.join(b:bat[:oid,:hge],gen:bat[:oid,:hge]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) -address VLTgenerator_join; -comment Overloaded join operation +pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:hge]):bat[:oid,:hge] +address VLTgenerator_leftfetchjoin; +comment Overloaded leftfetchjoin operation pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:timestamp]):bat[:oid,:timestamp] address VLTgenerator_leftfetchjoin; @@ -48745,9 +48749,11 @@ pattern generator.leftfetchjoin(b:bat[:o address VLTgenerator_leftfetchjoin; pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:bte]):bat[:oid,:bte] address VLTgenerator_leftfetchjoin; -pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:hge]):bat[:oid,:hge] -address VLTgenerator_leftfetchjoin; -comment Overloaded leftfetchjoin operation +pattern generator.parameters(first:hge,last:hge):bat[:oid,:hge] +address VLTgenerator_noop; +pattern generator.parameters(first:hge,last:hge,step:hge):bat[:oid,:hge] +address VLTgenerator_noop; +comment Retain the table definition, but don't materialize pattern generator.parameters(first:dbl,last:dbl):bat[:oid,:dbl] address VLTgenerator_noop; @@ -48777,12 +48783,20 @@ pattern generator.parameters(first:sht,l address VLTgenerator_noop; pattern generator.parameters(first:bte,last:bte,step:bte):bat[:oid,:bte] address VLTgenerator_noop; -pattern generator.parameters(first:hge,last:hge):bat[:oid,:hge] -address VLTgenerator_noop; -pattern generator.parameters(first:hge,last:hge,step:hge):bat[:oid,:hge] -address VLTgenerator_noop; -comment Retain the table definition, but don't materialize - +pattern generator.subselect(b:bat[:oid,:hge],cand:bat[:oid,:oid],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] +address VLTgenerator_subselect; +comment Overloaded selection routine + +pattern generator.subselect(b:bat[:oid,:hge],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] +address VLTgenerator_subselect; +comment Overloaded selection routine + +pattern generator.series(first:hge,last:hge,step:hge):bat[:oid,:hge] +address VLTgenerator_table; +comment Create and materialize a generator table + +pattern generator.series(first:hge,last:hge):bat[:oid,:hge] +address VLTgenerator_table; pattern generator.subselect(b:bat[:oid,:timestamp],cand:bat[:oid,:oid],low:timestamp,high:timestamp,li:bit,hi:bit,anti:bit):bat[:oid,:oid] address VLTgenerator_subselect; comment Overloaded selection routine @@ -48843,20 +48857,14 @@ pattern generator.series(first:sht,last: address VLTgenerator_table; pattern generator.series(first:bte,last:bte):bat[:oid,:bte] address VLTgenerator_table; -pattern generator.subselect(b:bat[:oid,:hge],cand:bat[:oid,:oid],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] -address VLTgenerator_subselect; +pattern generator.thetasubselect(b:bat[:oid,:hge],cnd:bat[:oid,:oid],low:hge,oper:str):bat[:oid,:oid] +address VLTgenerator_thetasubselect; comment Overloaded selection routine -pattern generator.subselect(b:bat[:oid,:hge],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] -address VLTgenerator_subselect; +pattern generator.thetasubselect(b:bat[:oid,:hge],low:hge,oper:str):bat[:oid,:oid] +address VLTgenerator_thetasubselect; comment Overloaded selection routine -pattern generator.series(first:hge,last:hge,step:hge):bat[:oid,:hge] -address VLTgenerator_table; -comment Create and materialize a generator table - -pattern generator.series(first:hge,last:hge):bat[:oid,:hge] -address VLTgenerator_table; pattern generator.thetasubselect(b:bat[:oid,:timestamp],cnd:bat[:oid,:oid],low:timestamp,oper:str):bat[:oid,:oid] address VLTgenerator_thetasubselect; comment Overloaded selection routine @@ -48889,14 +48897,6 @@ pattern generator.thetasubselect(b:bat[: address VLTgenerator_thetasubselect; pattern generator.thetasubselect(b:bat[:oid,:bte],low:bte,oper:str):bat[:oid,:oid] address VLTgenerator_thetasubselect; -pattern generator.thetasubselect(b:bat[:oid,:hge],cnd:bat[:oid,:oid],low:hge,oper:str):bat[:oid,:oid] -address VLTgenerator_thetasubselect; -comment Overloaded selection routine - -pattern generator.thetasubselect(b:bat[:oid,:hge],low:hge,oper:str):bat[:oid,:oid] -address VLTgenerator_thetasubselect; -comment Overloaded selection routine - command geom.Area(g:wkb):dbl address wkbArea; comment Returns the area of the geometry. @@ -50419,6 +50419,10 @@ command mtime.date_add_month_interval(t: address MTIMEdate_addmonths; comment Add months to a date +command mtime.diff(val1:daytime,val2:daytime):lng +address MTIMEdaytime_diff; +comment returns the number of msec between 'val1' and 'val2'. + command mtime.date_add_msec_interval(t:date,ms:lng):date address MTIMEdate_add_msec_interval_lng_wrap; command mtime.date_add_sec_interval(t:date,s:int):date diff --git a/clients/Tests/MAL-signatures_geom.stable.out b/clients/Tests/MAL-signatures_geom.stable.out --- a/clients/Tests/MAL-signatures_geom.stable.out +++ b/clients/Tests/MAL-signatures_geom.stable.out @@ -39455,6 +39455,10 @@ command mtime.date_add_month_interval(t: address MTIMEdate_addmonths; comment Add months to a date +command mtime.diff(val1:daytime,val2:daytime):lng +address MTIMEdaytime_diff; +comment returns the number of msec between 'val1' and 'val2'. + command mtime.date_add_msec_interval(t:date,ms:lng):date address MTIMEdate_add_msec_interval_lng_wrap; command mtime.date_add_sec_interval(t:date,s:int):date diff --git a/clients/Tests/MAL-signatures_geom.stable.out.int128 b/clients/Tests/MAL-signatures_geom.stable.out.int128 --- a/clients/Tests/MAL-signatures_geom.stable.out.int128 +++ b/clients/Tests/MAL-signatures_geom.stable.out.int128 @@ -48673,6 +48673,10 @@ pattern factories.shutdown(m:str,f:str): address FCTshutdown; comment Close a factory. +pattern generator.join(b:bat[:oid,:hge],gen:bat[:oid,:hge]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) +address VLTgenerator_join; +comment Overloaded join operation + pattern generator.join(gen:bat[:oid,:dbl],low:bat[:oid,:dbl],hgh:bat[:oid,:dbl],li:bit,ri:bit) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address VLTgenerator_rangejoin; comment Overloaded range join operation @@ -48701,9 +48705,9 @@ pattern generator.join(b:bat[:oid,:sht], address VLTgenerator_join; pattern generator.join(b:bat[:oid,:bte],gen:bat[:oid,:bte]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address VLTgenerator_join; -pattern generator.join(b:bat[:oid,:hge],gen:bat[:oid,:hge]) (l:bat[:oid,:oid],r:bat[:oid,:oid]) -address VLTgenerator_join; -comment Overloaded join operation +pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:hge]):bat[:oid,:hge] +address VLTgenerator_leftfetchjoin; +comment Overloaded leftfetchjoin operation pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:timestamp]):bat[:oid,:timestamp] address VLTgenerator_leftfetchjoin; @@ -48721,9 +48725,11 @@ pattern generator.leftfetchjoin(b:bat[:o address VLTgenerator_leftfetchjoin; pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:bte]):bat[:oid,:bte] address VLTgenerator_leftfetchjoin; -pattern generator.leftfetchjoin(b:bat[:oid,:oid],cand:bat[:oid,:hge]):bat[:oid,:hge] -address VLTgenerator_leftfetchjoin; -comment Overloaded leftfetchjoin operation +pattern generator.parameters(first:hge,last:hge):bat[:oid,:hge] +address VLTgenerator_noop; +pattern generator.parameters(first:hge,last:hge,step:hge):bat[:oid,:hge] +address VLTgenerator_noop; +comment Retain the table definition, but don't materialize pattern generator.parameters(first:dbl,last:dbl):bat[:oid,:dbl] address VLTgenerator_noop; @@ -48753,12 +48759,20 @@ pattern generator.parameters(first:sht,l address VLTgenerator_noop; pattern generator.parameters(first:bte,last:bte,step:bte):bat[:oid,:bte] address VLTgenerator_noop; -pattern generator.parameters(first:hge,last:hge):bat[:oid,:hge] -address VLTgenerator_noop; -pattern generator.parameters(first:hge,last:hge,step:hge):bat[:oid,:hge] -address VLTgenerator_noop; -comment Retain the table definition, but don't materialize - +pattern generator.subselect(b:bat[:oid,:hge],cand:bat[:oid,:oid],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] +address VLTgenerator_subselect; +comment Overloaded selection routine + +pattern generator.subselect(b:bat[:oid,:hge],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] +address VLTgenerator_subselect; +comment Overloaded selection routine + +pattern generator.series(first:hge,last:hge,step:hge):bat[:oid,:hge] +address VLTgenerator_table; +comment Create and materialize a generator table + +pattern generator.series(first:hge,last:hge):bat[:oid,:hge] +address VLTgenerator_table; pattern generator.subselect(b:bat[:oid,:timestamp],cand:bat[:oid,:oid],low:timestamp,high:timestamp,li:bit,hi:bit,anti:bit):bat[:oid,:oid] address VLTgenerator_subselect; comment Overloaded selection routine @@ -48819,20 +48833,14 @@ pattern generator.series(first:sht,last: address VLTgenerator_table; pattern generator.series(first:bte,last:bte):bat[:oid,:bte] address VLTgenerator_table; -pattern generator.subselect(b:bat[:oid,:hge],cand:bat[:oid,:oid],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] -address VLTgenerator_subselect; +pattern generator.thetasubselect(b:bat[:oid,:hge],cnd:bat[:oid,:oid],low:hge,oper:str):bat[:oid,:oid] +address VLTgenerator_thetasubselect; comment Overloaded selection routine -pattern generator.subselect(b:bat[:oid,:hge],low:hge,high:hge,li:bit,hi:bit,anti:bit):bat[:oid,:oid] -address VLTgenerator_subselect; +pattern generator.thetasubselect(b:bat[:oid,:hge],low:hge,oper:str):bat[:oid,:oid] +address VLTgenerator_thetasubselect; comment Overloaded selection routine -pattern generator.series(first:hge,last:hge,step:hge):bat[:oid,:hge] -address VLTgenerator_table; -comment Create and materialize a generator table - -pattern generator.series(first:hge,last:hge):bat[:oid,:hge] -address VLTgenerator_table; pattern generator.thetasubselect(b:bat[:oid,:timestamp],cnd:bat[:oid,:oid],low:timestamp,oper:str):bat[:oid,:oid] address VLTgenerator_thetasubselect; comment Overloaded selection routine @@ -48865,14 +48873,6 @@ pattern generator.thetasubselect(b:bat[: address VLTgenerator_thetasubselect; pattern generator.thetasubselect(b:bat[:oid,:bte],low:bte,oper:str):bat[:oid,:oid] address VLTgenerator_thetasubselect; -pattern generator.thetasubselect(b:bat[:oid,:hge],cnd:bat[:oid,:oid],low:hge,oper:str):bat[:oid,:oid] -address VLTgenerator_thetasubselect; -comment Overloaded selection routine - -pattern generator.thetasubselect(b:bat[:oid,:hge],low:hge,oper:str):bat[:oid,:oid] -address VLTgenerator_thetasubselect; -comment Overloaded selection routine - command geom.Area(g:wkb):dbl address wkbArea; comment Returns the area of the geometry. @@ -50395,6 +50395,10 @@ command mtime.date_add_month_interval(t: address MTIMEdate_addmonths; comment Add months to a date +command mtime.diff(val1:daytime,val2:daytime):lng +address MTIMEdaytime_diff; +comment returns the number of msec between 'val1' and 'val2'. + command mtime.date_add_msec_interval(t:date,ms:lng):date address MTIMEdate_add_msec_interval_lng_wrap; command mtime.date_add_sec_interval(t:date,s:int):date diff --git a/clients/Tests/MAL-signatures_none.stable.out b/clients/Tests/MAL-signatures_none.stable.out --- a/clients/Tests/MAL-signatures_none.stable.out +++ b/clients/Tests/MAL-signatures_none.stable.out @@ -39272,6 +39272,10 @@ command mtime.date_add_month_interval(t: address MTIMEdate_addmonths; comment Add months to a date +command mtime.diff(val1:daytime,val2:daytime):lng +address MTIMEdaytime_diff; +comment returns the number of msec between 'val1' and 'val2'. + command mtime.date_add_msec_interval(t:date,ms:lng):date address MTIMEdate_add_msec_interval_lng_wrap; command mtime.date_add_sec_interval(t:date,s:int):date diff --git a/clients/Tests/MAL-signatures_none.stable.out.int128 b/clients/Tests/MAL-signatures_none.stable.out.int128 --- a/clients/Tests/MAL-signatures_none.stable.out.int128 +++ b/clients/Tests/MAL-signatures_none.stable.out.int128 @@ -48647,6 +48647,10 @@ pattern factories.shutdown(m:str,f:str): _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list