Changeset: a8a762e46538 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a8a762e46538 Modified Files: clients/Tests/MAL-signatures_all.stable.out.int128 clients/Tests/MAL-signatures_fits_geom.stable.out.int128 clients/Tests/MAL-signatures_geom.stable.out.int128 clients/Tests/MAL-signatures_none.stable.out.int128 clients/Tests/SQL-dump_all.stable.out.int128 clients/Tests/SQL-dump_all.stable.out.oid32.int128 clients/Tests/SQL-dump_geom.stable.out.int128 clients/Tests/SQL-dump_geom.stable.out.oid32.int128 clients/Tests/SQL-dump_none.stable.out.int128 Branch: default Log Message:
Approved 128 bit output after merge. diffs (169 lines): 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 @@ -2847,6 +2847,10 @@ command algebra.groupby(gids:bat[:oid,:o address ALGgroupby; comment Produces a new BAT with groups identified by the head column. The result contains tail times the head value, ie the tail contains the result group sizes. +command algebra.ilikesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address ILIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case insensitive match.The result is two aligned bats with oids of matching rows. + command algebra.ilikesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCREilike_join_pcre; function algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; @@ -2899,6 +2903,10 @@ pattern algebra.leftjoinPath(l:bat[:any, address ALGjoinPath; comment Routine to handle join paths. The type analysis is rather tricky. +command algebra.likesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address LIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case sensitive match.The result is two aligned bats with oids of matching rows. + command algebra.likesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCRElike_join_pcre; function algebra.likesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; 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 @@ -2847,6 +2847,10 @@ command algebra.groupby(gids:bat[:oid,:o address ALGgroupby; comment Produces a new BAT with groups identified by the head column. The result contains tail times the head value, ie the tail contains the result group sizes. +command algebra.ilikesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address ILIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case insensitive match.The result is two aligned bats with oids of matching rows. + command algebra.ilikesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCREilike_join_pcre; function algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; @@ -2899,6 +2903,10 @@ pattern algebra.leftjoinPath(l:bat[:any, address ALGjoinPath; comment Routine to handle join paths. The type analysis is rather tricky. +command algebra.likesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address LIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case sensitive match.The result is two aligned bats with oids of matching rows. + command algebra.likesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCRElike_join_pcre; function algebra.likesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; 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 @@ -2847,6 +2847,10 @@ command algebra.groupby(gids:bat[:oid,:o address ALGgroupby; comment Produces a new BAT with groups identified by the head column. The result contains tail times the head value, ie the tail contains the result group sizes. +command algebra.ilikesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address ILIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case insensitive match.The result is two aligned bats with oids of matching rows. + command algebra.ilikesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCREilike_join_pcre; function algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; @@ -2899,6 +2903,10 @@ pattern algebra.leftjoinPath(l:bat[:any, address ALGjoinPath; comment Routine to handle join paths. The type analysis is rather tricky. +command algebra.likesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address LIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case sensitive match.The result is two aligned bats with oids of matching rows. + command algebra.likesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCRElike_join_pcre; function algebra.likesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; 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 @@ -2845,6 +2845,10 @@ command algebra.groupby(gids:bat[:oid,:o address ALGgroupby; comment Produces a new BAT with groups identified by the head column. The result contains tail times the head value, ie the tail contains the result group sizes. +command algebra.ilikesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address ILIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case insensitive match.The result is two aligned bats with oids of matching rows. + command algebra.ilikesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCREilike_join_pcre; function algebra.ilikesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; @@ -2897,6 +2901,10 @@ pattern algebra.leftjoinPath(l:bat[:any, address ALGjoinPath; comment Routine to handle join paths. The type analysis is rather tricky. +command algebra.likesubjoin(l:bat[:oid,:str],r:bat[:oid,:str],sl:bat[:oid,:oid],sr:bat[:oid,:oid],esc:str) (X_6:bat[:oid,:oid],X_7:bat[:oid,:oid]) +address LIKEsubjoin; +comment Join the string bat L with the pattern bat Rwith optional candidate lists SL and SR using pattern escape string ESCand doing a case sensitive match.The result is two aligned bats with oids of matching rows. + command algebra.likesubselect(s:bat[:oid,:str],pat:bat[:oid,:str],esc:str) (l:bat[:oid,:oid],r:bat[:oid,:oid]) address PCRElike_join_pcre; function algebra.likesubselect(b:bat[:oid,:str],cand:bat[:oid,:oid],pat:str,esc:str,anti:bit):bat[:oid,:oid]; diff --git a/clients/Tests/SQL-dump_all.stable.out.int128 b/clients/Tests/SQL-dump_all.stable.out.int128 --- a/clients/Tests/SQL-dump_all.stable.out.int128 +++ b/clients/Tests/SQL-dump_all.stable.out.int128 @@ -57,9 +57,9 @@ Ready. SCHEMA bam SCHEMA json SCHEMA tmp +SCHEMA bam +SCHEMA json SCHEMA tmp -SCHEMA json -SCHEMA bam SYSTEM SCHEMA sys SYSTEM TABLE sys._columns SYSTEM TABLE sys._tables diff --git a/clients/Tests/SQL-dump_all.stable.out.oid32.int128 b/clients/Tests/SQL-dump_all.stable.out.oid32.int128 --- a/clients/Tests/SQL-dump_all.stable.out.oid32.int128 +++ b/clients/Tests/SQL-dump_all.stable.out.oid32.int128 @@ -57,9 +57,9 @@ Ready. SCHEMA bam SCHEMA json SCHEMA tmp +SCHEMA bam +SCHEMA json SCHEMA tmp -SCHEMA json -SCHEMA bam SYSTEM SCHEMA sys SYSTEM TABLE sys._columns SYSTEM TABLE sys._tables diff --git a/clients/Tests/SQL-dump_geom.stable.out.int128 b/clients/Tests/SQL-dump_geom.stable.out.int128 --- a/clients/Tests/SQL-dump_geom.stable.out.int128 +++ b/clients/Tests/SQL-dump_geom.stable.out.int128 @@ -56,8 +56,8 @@ Ready. SCHEMA json SCHEMA tmp +SCHEMA json SCHEMA tmp -SCHEMA json SYSTEM SCHEMA sys SYSTEM TABLE sys._columns SYSTEM TABLE sys._tables diff --git a/clients/Tests/SQL-dump_geom.stable.out.oid32.int128 b/clients/Tests/SQL-dump_geom.stable.out.oid32.int128 --- a/clients/Tests/SQL-dump_geom.stable.out.oid32.int128 +++ b/clients/Tests/SQL-dump_geom.stable.out.oid32.int128 @@ -56,8 +56,8 @@ Ready. SCHEMA json SCHEMA tmp +SCHEMA json SCHEMA tmp -SCHEMA json SYSTEM SCHEMA sys SYSTEM TABLE sys._columns SYSTEM TABLE sys._tables diff --git a/clients/Tests/SQL-dump_none.stable.out.int128 b/clients/Tests/SQL-dump_none.stable.out.int128 --- a/clients/Tests/SQL-dump_none.stable.out.int128 +++ b/clients/Tests/SQL-dump_none.stable.out.int128 @@ -56,8 +56,8 @@ Ready. SCHEMA json SCHEMA tmp +SCHEMA json SCHEMA tmp -SCHEMA json SYSTEM SCHEMA sys SYSTEM TABLE sys._columns SYSTEM TABLE sys._tables _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
