Changeset: c4d0f4161950 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c4d0f4161950 Modified Files: clients/Tests/MAL-signatures_all.stable.out clients/Tests/MAL-signatures_all.stable.out.int128 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 Branch: default Log Message:
Approved output. diffs (truncated from 2169 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 @@ -2338,6 +2338,10 @@ command algebra.ilikesubselect(s:bat[:oi address PCREilike_join_pcre; function algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; function algebra.ilikesubselect(b:bat[:oid,:str],pat:str,esc:str,anti:bit):bat[:oid,:oid]; +command algebra.ilike(s:str,pat:str):bit +address PCREilike2; +command algebra.ilike(s:str,pat:str,esc:str):bit +address PCREilike3; command algebra.indexjoin(left:bat[:any_1,:any_2],right:bat[:any_2,:any_3]):bat[:any_1,:any_3] address ALGindexjoin; comment Hook directly into the index implementation of the join. @@ -2401,6 +2405,10 @@ command algebra.likesubselect(b:bat[:oid address PCRElikesubselect1; comment Select all head values for which the tail value is "like" the given (SQL-style) pattern. Input is a dense-headed BAT, output is a dense-headed BAT with in the tail the head value of the input BAT for which the relationship holds. The output BAT is sorted on the tail value. +command algebra.like(s:str,pat:str):bit +address PCRElike2; +command algebra.like(s:str,pat:str,esc:str):bit +address PCRElike3; command algebra.leftfetchjoin(left:bat[:oid,:oid],right:bat[:oid,:any_3]):bat[:oid,:any_3] address ALGleftfetchjoin; comment Hook directly into the left fetch join implementation. @@ -2449,6 +2457,14 @@ command algebra.markT(b:bat[:any_1,:any_ address ALGtmark; comment Produces a BAT with fresh unique dense sequense of OIDs in the tail that starts at base (i.e. [base,..base+b.count()-1] ). +command algebra.not_ilike(s:str,pat:str):bit +address PCREnotilike2; +command algebra.not_ilike(s:str,pat:str,esc:str):bit +address PCREnotilike3; +command algebra.not_like(s:str,pat:str):bit +address PCREnotlike2; +command algebra.not_like(s:str,pat:str,esc:str):bit +address PCREnotlike3; command algebra.outerjoin(outer:bat[:any_1,:any_2],inner:bat[:any_2,:any_3],estimate:lng):bat[:any_1,:any_3] address ALGouterjoinestimate; command algebra.outerjoin(outer:bat[:any_1,:oid],inner:bat[:oid,:any_3]):bat[:any_1,:any_3] @@ -2869,6 +2885,22 @@ command batgeom.point(x:bat[:oid,:dbl],y address wkbcreatepoint_bat; comment Construct a point-BAT from two geometry-BATs +command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCREilike2; +command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCREilike; +command batalgebra.like(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCRElike2; +command batalgebra.like(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCRElike; +command batalgebra.not_ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCREnotliike2; +command batalgebra.not_ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCREnotilike; +command batalgebra.not_like(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCREnotlike2; +command batalgebra.not_like(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCREnotlike; command batcolor.blue(c:bat[:oid,:color]):bat[:oid,:int] address CLRbatBlue; comment Extracts blue component from a color atom diff --git a/clients/Tests/MAL-signatures_all.stable.out.int128 b/clients/Tests/MAL-signatures_all.stable.out.int128 --- a/clients/Tests/MAL-signatures_all.stable.out.int128 +++ b/clients/Tests/MAL-signatures_all.stable.out.int128 @@ -2855,6 +2855,10 @@ command algebra.ilikesubselect(s:bat[:oi address PCREilike_join_pcre; function algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; function algebra.ilikesubselect(b:bat[:oid,:str],pat:str,esc:str,anti:bit):bat[:oid,:oid]; +command algebra.ilike(s:str,pat:str):bit +address PCREilike2; +command algebra.ilike(s:str,pat:str,esc:str):bit +address PCREilike3; command algebra.indexjoin(left:bat[:any_1,:any_2],right:bat[:any_2,:any_3]):bat[:any_1,:any_3] address ALGindexjoin; comment Hook directly into the index implementation of the join. @@ -2918,6 +2922,10 @@ command algebra.likesubselect(b:bat[:oid address PCRElikesubselect1; comment Select all head values for which the tail value is "like" the given (SQL-style) pattern. Input is a dense-headed BAT, output is a dense-headed BAT with in the tail the head value of the input BAT for which the relationship holds. The output BAT is sorted on the tail value. +command algebra.like(s:str,pat:str):bit +address PCRElike2; +command algebra.like(s:str,pat:str,esc:str):bit +address PCRElike3; command algebra.leftfetchjoin(left:bat[:oid,:oid],right:bat[:oid,:any_3]):bat[:oid,:any_3] address ALGleftfetchjoin; comment Hook directly into the left fetch join implementation. @@ -2966,6 +2974,14 @@ command algebra.markT(b:bat[:any_1,:any_ address ALGtmark; comment Produces a BAT with fresh unique dense sequense of OIDs in the tail that starts at base (i.e. [base,..base+b.count()-1] ). +command algebra.not_ilike(s:str,pat:str):bit +address PCREnotilike2; +command algebra.not_ilike(s:str,pat:str,esc:str):bit +address PCREnotilike3; +command algebra.not_like(s:str,pat:str):bit +address PCREnotlike2; +command algebra.not_like(s:str,pat:str,esc:str):bit +address PCREnotlike3; command algebra.outerjoin(outer:bat[:any_1,:any_2],inner:bat[:any_2,:any_3],estimate:lng):bat[:any_1,:any_3] address ALGouterjoinestimate; command algebra.outerjoin(outer:bat[:any_1,:oid],inner:bat[:oid,:any_3]):bat[:any_1,:any_3] @@ -3398,6 +3414,22 @@ command batgeom.point(x:bat[:oid,:dbl],y address wkbcreatepoint_bat; comment Construct a point-BAT from two geometry-BATs +command batalgebra.ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCREilike2; +command batalgebra.ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCREilike; +command batalgebra.like(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCRElike2; +command batalgebra.like(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCRElike; +command batalgebra.not_ilike(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCREnotliike2; +command batalgebra.not_ilike(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCREnotilike; +command batalgebra.not_like(s:bat[:oid,:str],pat:str):bat[:oid,:bit] +address BATPCREnotlike2; +command batalgebra.not_like(s:bat[:oid,:str],pat:str,esc:str):bat[:oid,:bit] +address BATPCREnotlike; command batcolor.blue(c:bat[:oid,:color]):bat[:oid,:int] address CLRbatBlue; comment Extracts blue component from a color atom @@ -27430,11 +27462,11 @@ command batcalc.bte(v:bat[:oid,:str],dig address batstr_2num_bte; comment cast to bte and check for overflow -command batcalc.bte(v:bat[:oid,:void],digits:int,scale:int):bat[:oid,:bte] +command batcalc.bte(v:bat[:oid,:oid],digits:int,scale:int):bat[:oid,:bte] address batnil_2dec_bte; comment cast to dec(bte) and check for overflow -command batcalc.bte(v:bat[:oid,:void],digits:int):bat[:oid,:bte] +command batcalc.bte(v:bat[:oid,:oid],digits:int):bat[:oid,:bte] address batnil_2num_bte; comment cast to bte and check for overflow @@ -27598,19 +27630,19 @@ pattern batcalc.bte(b:bat[:oid,:bit]):ba address CMDconvertsignal_bte; comment cast from bit to bte, signal error on overflow -pattern batcalc.bte_noerror(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:bte] +pattern batcalc.bte_noerror(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:bte] address CMDconvert_bte; comment cast from void to bte with candidates list -pattern batcalc.bte_noerror(b:bat[:oid,:void]):bat[:oid,:bte] +pattern batcalc.bte_noerror(b:bat[:oid,:oid]):bat[:oid,:bte] address CMDconvert_bte; comment cast from void to bte -pattern batcalc.bte(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:bte] +pattern batcalc.bte(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:bte] address CMDconvertsignal_bte; comment cast from void to bte with candidates list, signal error on overflow -pattern batcalc.bte(b:bat[:oid,:void]):bat[:oid,:bte] +pattern batcalc.bte(b:bat[:oid,:oid]):bat[:oid,:bte] address CMDconvertsignal_bte; comment cast from void to bte, signal error on overflow @@ -27774,19 +27806,19 @@ pattern batcalc.bit(b:bat[:oid,:bit]):ba address CMDconvertsignal_bit; comment cast from bit to bit, signal error on overflow -pattern batcalc.bit_noerror(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:bit] +pattern batcalc.bit_noerror(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:bit] address CMDconvert_bit; comment cast from void to bit with candidates list -pattern batcalc.bit_noerror(b:bat[:oid,:void]):bat[:oid,:bit] +pattern batcalc.bit_noerror(b:bat[:oid,:oid]):bat[:oid,:bit] address CMDconvert_bit; comment cast from void to bit -pattern batcalc.bit(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:bit] +pattern batcalc.bit(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:bit] address CMDconvertsignal_bit; comment cast from void to bit with candidates list, signal error on overflow -pattern batcalc.bit(b:bat[:oid,:void]):bat[:oid,:bit] +pattern batcalc.bit(b:bat[:oid,:oid]):bat[:oid,:bit] address CMDconvertsignal_bit; comment cast from void to bit, signal error on overflow @@ -29605,7 +29637,7 @@ command batcalc.date(v:bat[:oid,:str]):b address batstr_2_date; comment cast to date -command batcalc.date(v:bat[:oid,:void]):bat[:oid,:date] +command batcalc.date(v:bat[:oid,:oid]):bat[:oid,:date] address batnil_2_date; comment cast to date @@ -29621,11 +29653,11 @@ command batcalc.daytime(v:bat[:oid,:str] address batstr_2_daytime; comment Cast to daytime -command batcalc.daytime(v:bat[:oid,:void],digits:int):bat[:oid,:daytime] +command batcalc.daytime(v:bat[:oid,:oid],digits:int):bat[:oid,:daytime] address batnil_2time_daytime; comment cast to daytime and check for overflow -command batcalc.daytime(v:bat[:oid,:void]):bat[:oid,:daytime] +command batcalc.daytime(v:bat[:oid,:oid]):bat[:oid,:daytime] address batnil_2_daytime; comment Cast to daytime @@ -29789,19 +29821,19 @@ pattern batcalc.dbl(b:bat[:oid,:bit]):ba address CMDconvertsignal_dbl; comment cast from bit to dbl, signal error on overflow -pattern batcalc.dbl_noerror(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:dbl] +pattern batcalc.dbl_noerror(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:dbl] address CMDconvert_dbl; comment cast from void to dbl with candidates list -pattern batcalc.dbl_noerror(b:bat[:oid,:void]):bat[:oid,:dbl] +pattern batcalc.dbl_noerror(b:bat[:oid,:oid]):bat[:oid,:dbl] address CMDconvert_dbl; comment cast from void to dbl -pattern batcalc.dbl(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:dbl] +pattern batcalc.dbl(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:dbl] address CMDconvertsignal_dbl; comment cast from void to dbl with candidates list, signal error on overflow -pattern batcalc.dbl(b:bat[:oid,:void]):bat[:oid,:dbl] +pattern batcalc.dbl(b:bat[:oid,:oid]):bat[:oid,:dbl] address CMDconvertsignal_dbl; comment cast from void to dbl, signal error on overflow @@ -31595,19 +31627,19 @@ pattern batcalc.flt(b:bat[:oid,:bit]):ba address CMDconvertsignal_flt; comment cast from bit to flt, signal error on overflow -pattern batcalc.flt_noerror(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:flt] +pattern batcalc.flt_noerror(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:flt] address CMDconvert_flt; comment cast from void to flt with candidates list -pattern batcalc.flt_noerror(b:bat[:oid,:void]):bat[:oid,:flt] +pattern batcalc.flt_noerror(b:bat[:oid,:oid]):bat[:oid,:flt] address CMDconvert_flt; comment cast from void to flt -pattern batcalc.flt(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:flt] +pattern batcalc.flt(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:flt] address CMDconvertsignal_flt; comment cast from void to flt with candidates list, signal error on overflow -pattern batcalc.flt(b:bat[:oid,:void]):bat[:oid,:flt] +pattern batcalc.flt(b:bat[:oid,:oid]):bat[:oid,:flt] address CMDconvertsignal_flt; comment cast from void to flt, signal error on overflow @@ -32035,11 +32067,11 @@ command batcalc.int(v:bat[:oid,:str],dig address batstr_2num_int; comment cast to int and check for overflow -command batcalc.int(v:bat[:oid,:void],digits:int,scale:int):bat[:oid,:int] +command batcalc.int(v:bat[:oid,:oid],digits:int,scale:int):bat[:oid,:int] address batnil_2dec_int; comment cast to dec(int) and check for overflow -command batcalc.int(v:bat[:oid,:void],digits:int):bat[:oid,:int] +command batcalc.int(v:bat[:oid,:oid],digits:int):bat[:oid,:int] address batnil_2num_int; comment cast to int and check for overflow @@ -32235,19 +32267,19 @@ pattern batcalc.int(b:bat[:oid,:bit]):ba address CMDconvertsignal_int; comment cast from bit to int, signal error on overflow -pattern batcalc.int_noerror(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:int] +pattern batcalc.int_noerror(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:int] address CMDconvert_int; comment cast from void to int with candidates list -pattern batcalc.int_noerror(b:bat[:oid,:void]):bat[:oid,:int] +pattern batcalc.int_noerror(b:bat[:oid,:oid]):bat[:oid,:int] address CMDconvert_int; comment cast from void to int -pattern batcalc.int(b:bat[:oid,:void],s:bat[:oid,:oid]):bat[:oid,:int] +pattern batcalc.int(b:bat[:oid,:oid],s:bat[:oid,:oid]):bat[:oid,:int] address CMDconvertsignal_int; comment cast from void to int with candidates list, signal error on overflow -pattern batcalc.int(b:bat[:oid,:void]):bat[:oid,:int] +pattern batcalc.int(b:bat[:oid,:oid]):bat[:oid,:int] address CMDconvertsignal_int; comment cast from void to int, signal error on overflow @@ -32531,11 +32563,11 @@ command batcalc.lng(v:bat[:oid,:str],dig address batstr_2num_lng; comment cast to lng and check for overflow _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list