Changeset: defc4a65e6b1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/defc4a65e6b1 Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 monetdb5/modules/atoms/str.c monetdb5/modules/mal/remote.c monetdb5/modules/mal/wlc.c sql/server/rel_optimizer.c sql/server/rel_unnest.c Branch: default Log Message:
Merged with Jul2021 diffs (truncated from 1142 to 300 lines): 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 @@ -757,6 +757,14 @@ [ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:daytime], X_1:daytime, X_2:bit):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:bat[:inet]):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:bat[:inet], X_2:bit):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:inet):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:inet, X_2:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:inet, X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:inet], X_1:inet, X_2:bit):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:bat[:int], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] @@ -873,6 +881,10 @@ [ "batcalc", "!=", "pattern batcalc.!=(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:daytime, X_1:bat[:daytime], X_2:bit):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:inet, X_1:bat[:inet]):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:inet, X_1:bat[:inet], X_2:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:inet, X_1:bat[:inet], X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatNE;", "" ] +[ "batcalc", "!=", "pattern batcalc.!=(X_0:inet, X_1:bat[:inet], X_2:bit):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatNE;", "" ] [ "batcalc", "!=", "pattern batcalc.!=(X_0:int, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatNE;", "" ] @@ -2627,6 +2639,10 @@ [ "batcalc", "<", "pattern batcalc.<(X_0:bat[:daytime], X_1:bat[:daytime], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:bat[:daytime], X_1:daytime):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] +[ "batcalc", "<", "pattern batcalc.<(X_0:bat[:inet], X_1:bat[:inet]):bat[:bit] ", "CMDbatLT;", "" ] +[ "batcalc", "<", "pattern batcalc.<(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] +[ "batcalc", "<", "pattern batcalc.<(X_0:bat[:inet], X_1:inet):bat[:bit] ", "CMDbatLT;", "" ] +[ "batcalc", "<", "pattern batcalc.<(X_0:bat[:inet], X_1:inet, X_2:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:bat[:int], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:bat[:int], X_1:bat[:lng]):bat[:bit] ", "CMDbatLT;", "" ] @@ -2685,6 +2701,8 @@ [ "batcalc", "<", "pattern batcalc.<(X_0:date, X_1:bat[:date], X_2:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:daytime, X_1:bat[:daytime]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] +[ "batcalc", "<", "pattern batcalc.<(X_0:inet, X_1:bat[:inet]):bat[:bit] ", "CMDbatLT;", "" ] +[ "batcalc", "<", "pattern batcalc.<(X_0:inet, X_1:bat[:inet], X_2:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:int, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatLT;", "" ] [ "batcalc", "<", "pattern batcalc.<(X_0:int, X_1:bat[:lng]):bat[:bit] ", "CMDbatLT;", "" ] @@ -2831,6 +2849,10 @@ [ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:daytime], X_1:bat[:daytime], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:daytime], X_1:daytime):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:inet], X_1:bat[:inet]):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:inet], X_1:inet):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:inet], X_1:inet, X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:int], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:bat[:int], X_1:bat[:lng]):bat[:bit] ", "CMDbatLE;", "" ] @@ -2889,6 +2911,8 @@ [ "batcalc", "<=", "pattern batcalc.<=(X_0:date, X_1:bat[:date], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:daytime, X_1:bat[:daytime]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:inet, X_1:bat[:inet]):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:inet, X_1:bat[:inet], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:int, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:int, X_1:bat[:lng]):bat[:bit] ", "CMDbatLE;", "" ] @@ -2905,7 +2929,7 @@ [ "batcalc", "<=", "pattern batcalc.<=(X_0:lng, X_1:bat[:sht], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:bte]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] -[ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:int]):bat[:bit] ", "CMDbatLE;", "" ] +[ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:int]):ba[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatEQ;", "" ]t[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:int], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:lng]):bat[:bit] ", "CMDbatLE;", "" ] [ "batcalc", "<=", "pattern batcalc.<=(X_0:sht, X_1:bat[:lng], X_2:bat[:oid]):bat[:bit] ", "CMDbatLE;", "" ] @@ -2965,6 +2989,14 @@ [ "batcalc", "==", "pattern batcalc.==(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:bat[:daytime], X_1:daytime, X_2:bit):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:bat[:inet]):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid], X_4:bit):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:bat[:inet], X_2:bit):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:inet):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:inet, X_2:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:inet, X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:bat[:inet], X_1:inet, X_2:bit):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:bat[:int], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] @@ -3081,6 +3113,10 @@ [ "batcalc", "==", "pattern batcalc.==(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:daytime, X_1:bat[:daytime], X_2:bit):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:inet, X_1:bat[:inet]):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:inet, X_1:bat[:inet], X_2:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:inet, X_1:bat[:inet], X_2:bat[:oid], X_3:bit):bat[:bit] ", "CMDbatEQ;", "" ] +[ "batcalc", "==", "pattern batcalc.==(X_0:inet, X_1:bat[:inet], X_2:bit):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatEQ;", "" ] [ "batcalc", "==", "pattern batcalc.==(X_0:int, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatEQ;", "" ] @@ -3155,6 +3191,10 @@ [ "batcalc", ">", "pattern batcalc.>(X_0:bat[:daytime], X_1:bat[:daytime], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:bat[:daytime], X_1:daytime):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] +[ "batcalc", ">", "pattern batcalc.>(X_0:bat[:inet], X_1:bat[:inet]):bat[:bit] ", "CMDbatGT;", "" ] +[ "batcalc", ">", "pattern batcalc.>(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] +[ "batcalc", ">", "pattern batcalc.>(X_0:bat[:inet], X_1:inet):bat[:bit] ", "CMDbatGT;", "" ] +[ "batcalc", ">", "pattern batcalc.>(X_0:bat[:inet], X_1:inet, X_2:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:bat[:int], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:bat[:int], X_1:bat[:lng]):bat[:bit] ", "CMDbatGT;", "" ] @@ -3213,6 +3253,8 @@ [ "batcalc", ">", "pattern batcalc.>(X_0:date, X_1:bat[:date], X_2:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:daytime, X_1:bat[:daytime]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] +[ "batcalc", ">", "pattern batcalc.>(X_0:inet, X_1:bat[:inet]):bat[:bit] ", "CMDbatGT;", "" ] +[ "batcalc", ">", "pattern batcalc.>(X_0:inet, X_1:bat[:inet], X_2:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:int, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatGT;", "" ] [ "batcalc", ">", "pattern batcalc.>(X_0:int, X_1:bat[:lng]):bat[:bit] ", "CMDbatGT;", "" ] @@ -3263,6 +3305,10 @@ [ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:daytime], X_1:bat[:daytime], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:daytime], X_1:daytime):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:daytime], X_1:daytime, X_2:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] +[ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:inet], X_1:bat[:inet]):bat[:bit] ", "CMDbatGE;", "" ] +[ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:inet], X_1:bat[:inet], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] +[ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:inet], X_1:inet):bat[:bit] ", "CMDbatGE;", "" ] +[ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:inet], X_1:inet, X_2:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:int], X_1:bat[:bte]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:int], X_1:bat[:bte], X_2:bat[:oid], X_3:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:bat[:int], X_1:bat[:lng]):bat[:bit] ", "CMDbatGE;", "" ] @@ -3321,6 +3367,8 @@ [ "batcalc", ">=", "pattern batcalc.>=(X_0:date, X_1:bat[:date], X_2:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:daytime, X_1:bat[:daytime]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:daytime, X_1:bat[:daytime], X_2:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] +[ "batcalc", ">=", "pattern batcalc.>=(X_0:inet, X_1:bat[:inet]):bat[:bit] ", "CMDbatGE;", "" ] +[ "batcalc", ">=", "pattern batcalc.>=(X_0:inet, X_1:bat[:inet], X_2:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:int, X_1:bat[:bte]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:int, X_1:bat[:bte], X_2:bat[:oid]):bat[:bit] ", "CMDbatGE;", "" ] [ "batcalc", ">=", "pattern batcalc.>=(X_0:int, X_1:bat[:lng]):bat[:bit] ", "CMDbatGE;", "" ] @@ -6652,6 +6700,8 @@ [ "calc", "!=", "pattern calc.!=(X_0:flt, X_1:lng, X_2:bit):bit ", "CMDvarNE;", "Return V1 != V2" ] [ "calc", "!=", "pattern calc.!=(X_0:flt, X_1:sht):bit ", "CMDvarNE;", "Return V1 != V2" ] [ "calc", "!=", "pattern calc.!=(X_0:flt, X_1:sht, X_2:bit):bit ", "CMDvarNE;", "Return V1 != V2" ] +[ "calc", "!=", "pattern calc.!=(X_0:inet, X_1:inet):bit ", "CMDvarNE;", "Return V1 != V2" ] +[ "calc", "!=", "pattern calc.!=(X_0:inet, X_1:inet, X_2:bit):bit ", "CMDvarNE;", "Return V1 != V2" ] [ "calc", "!=", "pattern calc.!=(X_0:int, X_1:bte):bit ", "CMDvarNE;", "Return V1 != V2" ] [ "calc", "!=", "pattern calc.!=(X_0:int, X_1:bte, X_2:bit):bit ", "CMDvarNE;", "Return V1 != V2" ] [ "calc", "!=", "pattern calc.!=(X_0:int, X_1:dbl):bit ", "CMDvarNE;", "Return V1 != V2" ] @@ -6698,7 +6748,6 @@ [ "calc", "!=", "pattern calc.!=(X_0:timestamp, X_1:timestamp, X_2:bit):bit ", "CMDvarNE;", "Equality of two timestamps" ] [ "calc", "!=", "pattern calc.!=(X_0:uuid, X_1:uuid):bit ", "CMDvarNE;", "Return V1 != V2" ] [ "calc", "!=", "pattern calc.!=(X_0:uuid, X_1:uuid, X_2:bit):bit ", "CMDvarNE;", "Return V1 != V2" ] -[ "calc", "!=", "command calc.!=(X_0:inet, X_1:inet):bit ", "INET_comp_NEQ;", "Inequality of two inets" ] [ "calc", "%", "pattern calc.%(X_0:bte, X_1:bte):bte ", "CMDvarMODsignal;", "Return V1 % V2, signal error on divide by zero" ] [ "calc", "%", "pattern calc.%(X_0:bte, X_1:bte):int ", "CMDvarMODsignal;", "Return V1 % V2, signal error on divide by zero" ] [ "calc", "%", "pattern calc.%(X_0:bte, X_1:bte):lng ", "CMDvarMODsignal;", "Return V1 % V2, signal error on divide by zero" ] @@ -7282,6 +7331,7 @@ [ "calc", "<", "pattern calc.<(X_0:flt, X_1:int):bit ", "CMDvarLT;", "Return V1 < V2" ] [ "calc", "<", "pattern calc.<(X_0:flt, X_1:lng):bit ", "CMDvarLT;", "Return V1 < V2" ] [ "calc", "<", "pattern calc.<(X_0:flt, X_1:sht):bit ", "CMDvarLT;", "Return V1 < V2" ] +[ "calc", "<", "pattern calc.<(X_0:inet, X_1:inet):bit ", "CMDvarLT;", "Return V1 < V2" ] [ "calc", "<", "pattern calc.<(X_0:int, X_1:bte):bit ", "CMDvarLT;", "Return V1 < V2" ] [ "calc", "<", "pattern calc.<(X_0:int, X_1:dbl):bit ", "CMDvarLT;", "Return V1 < V2" ] [ "calc", "<", "pattern calc.<(X_0:int, X_1:flt):bit ", "CMDvarLT;", "Return V1 < V2" ] @@ -7305,7 +7355,6 @@ [ "calc", "<", "pattern calc.<(X_0:str, X_1:str):bit ", "CMDvarLT;", "Return V1 < V2" ] [ "calc", "<", "pattern calc.<(X_0:timestamp, X_1:timestamp):bit ", "CMDvarLT;", "Equality of two timestamps" ] [ "calc", "<", "pattern calc.<(X_0:uuid, X_1:uuid):bit ", "CMDvarLT;", "Return V1 < V2" ] -[ "calc", "<", "command calc.<(X_0:inet, X_1:inet):bit ", "INET_comp_LT;", "Whether v is less than w" ] [ "calc", "<<", "pattern calc.<<(X_0:bte, X_1:bte):bte ", "CMDvarLSHsignal;", "Return V1 << V2, raise error on out of range second operand" ] [ "calc", "<<", "pattern calc.<<(X_0:bte, X_1:int):bte ", "CMDvarLSHsignal;", "Return V1 << V2, raise error on out of range second operand" ] [ "calc", "<<", "pattern calc.<<(X_0:bte, X_1:lng):bte ", "CMDvarLSHsignal;", "Return V1 << V2, raise error on out of range second operand" ] @@ -7344,6 +7393,7 @@ [ "calc", "<=", "pattern calc.<=(X_0:flt, X_1:int):bit ", "CMDvarLE;", "Return V1 <= V2" ] [ "calc", "<=", "pattern calc.<=(X_0:flt, X_1:lng):bit ", "CMDvarLE;", "Return V1 <= V2" ] [ "calc", "<=", "pattern calc.<=(X_0:flt, X_1:sht):bit ", "CMDvarLE;", "Return V1 <= V2" ] +[ "calc", "<=", "pattern calc.<=(X_0:inet, X_1:inet):bit ", "CMDvarLE;", "Return V1 <= V2" ] [ "calc", "<=", "pattern calc.<=(X_0:int, X_1:bte):bit ", "CMDvarLE;", "Return V1 <= V2" ] [ "calc", "<=", "pattern calc.<=(X_0:int, X_1:dbl):bit ", "CMDvarLE;", "Return V1 <= V2" ] [ "calc", "<=", "pattern calc.<=(X_0:int, X_1:flt):bit ", "CMDvarLE;", "Return V1 <= V2" ] @@ -7367,7 +7417,6 @@ [ "calc", "<=", "pattern calc.<=(X_0:str, X_1:str):bit ", "CMDvarLE;", "Return V1 <= V2" ] [ "calc", "<=", "pattern calc.<=(X_0:timestamp, X_1:timestamp):bit ", "CMDvarLE;", "Equality of two timestamps" ] [ "calc", "<=", "pattern calc.<=(X_0:uuid, X_1:uuid):bit ", "CMDvarLE;", "Return V1 <= V2" ] -[ "calc", "<=", "command calc.<=(X_0:inet, X_1:inet):bit ", "INET_comp_LE;", "Whether v is less than or equal to w" ] [ "calc", "==", "pattern calc.==(X_0:bit, X_1:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:bit, X_1:bit, X_2:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:blob, X_1:blob):bit ", "CMDvarEQ;", "Return V1 == V2" ] @@ -7412,6 +7461,8 @@ [ "calc", "==", "pattern calc.==(X_0:flt, X_1:lng, X_2:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:flt, X_1:sht):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:flt, X_1:sht, X_2:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] +[ "calc", "==", "pattern calc.==(X_0:inet, X_1:inet):bit ", "CMDvarEQ;", "Return V1 == V2" ] +[ "calc", "==", "pattern calc.==(X_0:inet, X_1:inet, X_2:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:int, X_1:bte):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:int, X_1:bte, X_2:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:int, X_1:dbl):bit ", "CMDvarEQ;", "Return V1 == V2" ] @@ -7458,7 +7509,6 @@ [ "calc", "==", "pattern calc.==(X_0:timestamp, X_1:timestamp, X_2:bit):bit ", "CMDvarEQ;", "Equality of two timestamps" ] [ "calc", "==", "pattern calc.==(X_0:uuid, X_1:uuid):bit ", "CMDvarEQ;", "Return V1 == V2" ] [ "calc", "==", "pattern calc.==(X_0:uuid, X_1:uuid, X_2:bit):bit ", "CMDvarEQ;", "Return V1 == V2" ] -[ "calc", "==", "command calc.==(X_0:inet, X_1:inet):bit ", "INET_comp_EQ;", "Equality of two inets" ] [ "calc", ">", "pattern calc.>(X_0:bit, X_1:bit):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:blob, X_1:blob):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:bte, X_1:bte):bit ", "CMDvarGT;", "Return V1 > V2" ] @@ -7481,6 +7531,7 @@ [ "calc", ">", "pattern calc.>(X_0:flt, X_1:int):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:flt, X_1:lng):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:flt, X_1:sht):bit ", "CMDvarGT;", "Return V1 > V2" ] +[ "calc", ">", "pattern calc.>(X_0:inet, X_1:inet):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:int, X_1:bte):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:int, X_1:dbl):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:int, X_1:flt):bit ", "CMDvarGT;", "Return V1 > V2" ] @@ -7504,7 +7555,6 @@ [ "calc", ">", "pattern calc.>(X_0:str, X_1:str):bit ", "CMDvarGT;", "Return V1 > V2" ] [ "calc", ">", "pattern calc.>(X_0:timestamp, X_1:timestamp):bit ", "CMDvarGT;", "Equality of two timestamps" ] [ "calc", ">", "pattern calc.>(X_0:uuid, X_1:uuid):bit ", "CMDvarGT;", "Return V1 > V2" ] -[ "calc", ">", "command calc.>(X_0:inet, X_1:inet):bit ", "INET_comp_GT;", "Whether v is greater than w" ] [ "calc", ">=", "pattern calc.>=(X_0:bit, X_1:bit):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:blob, X_1:blob):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:bte, X_1:bte):bit ", "CMDvarGE;", "Return V1 >= V2" ] @@ -7527,6 +7577,7 @@ [ "calc", ">=", "pattern calc.>=(X_0:flt, X_1:int):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:flt, X_1:lng):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:flt, X_1:sht):bit ", "CMDvarGE;", "Return V1 >= V2" ] +[ "calc", ">=", "pattern calc.>=(X_0:inet, X_1:inet):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:int, X_1:bte):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:int, X_1:dbl):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:int, X_1:flt):bit ", "CMDvarGE;", "Return V1 >= V2" ] @@ -7550,7 +7601,6 @@ [ "calc", ">=", "pattern calc.>=(X_0:str, X_1:str):bit ", "CMDvarGE;", "Return V1 >= V2" ] [ "calc", ">=", "pattern calc.>=(X_0:timestamp, X_1:timestamp):bit ", "CMDvarGE;", "Equality of two timestamps" ] [ "calc", ">=", "pattern calc.>=(X_0:uuid, X_1:uuid):bit ", "CMDvarGE;", "Return V1 >= V2" ] -[ "calc", ">=", "command calc.>=(X_0:inet, X_1:inet):bit ", "INET_comp_GE;", "Whether v is equal to or greater than w" ] [ "calc", ">>", "pattern calc.>>(X_0:bte, X_1:bte):bte ", "CMDvarRSHsignal;", "Return V1 >> V2, raise error on out of range second operand" ] [ "calc", ">>", "pattern calc.>>(X_0:bte, X_1:int):bte ", "CMDvarRSHsignal;", "Return V1 >> V2, raise error on out of range second operand" ] [ "calc", ">>", "pattern calc.>>(X_0:bte, X_1:lng):bte ", "CMDvarRSHsignal;", "Return V1 >> V2, raise error on out of range second operand" ] @@ -9439,15 +9489,15 @@ [ "sqlcatalog", "alter_table", "pattern sqlcatalog.alter_table(X_0:str, X_1:str, X_2:ptr, X_3:int):void ", "SQLalter_table;", "Catalog operation alter_table" ] [ "sqlcatalog", "alter_user", "pattern sqlcatalog.alter_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str, X_5:str):void ", "SQLalter_user;", "Catalog operation alter_user" ] [ "sqlcatalog", "comment_on", "pattern sqlcatalog.comment_on(X_0:int, X_1:str):void ", "SQLcomment_on;", "Catalog operation comment_on" ] -[ "sqlcatalog", "create_function", "pattern sqlcatalog.create_function(X_0:str, X_1:str, X_2:ptr):void ", "SQLcreate_function;", "Catalog operation create_function" ] +[ "sqlcatalog", "create_function", "pattern sqlcatalog.create_function(X_0:str, X_1:str, X_2:ptr, X_3:int):void ", "SQLcreate_function;", "Catalog operation create_function" ] [ "sqlcatalog", "create_role", "pattern sqlcatalog.create_role(X_0:str, X_1:str, X_2:int):void ", "SQLcreate_role;", "Catalog operation create_role" ] [ "sqlcatalog", "create_schema", "pattern sqlcatalog.create_schema(X_0:str, X_1:str, X_2:int):void ", "SQLcreate_schema;", "Catalog operation create_schema" ] [ "sqlcatalog", "create_seq", "pattern sqlcatalog.create_seq(X_0:str, X_1:str, X_2:ptr, X_3:int):void ", "SQLcreate_seq;", "Catalog operation create_seq" ] [ "sqlcatalog", "create_table", "pattern sqlcatalog.create_table(X_0:str, X_1:str, X_2:ptr, X_3:int):void ", "SQLcreate_table;", "Catalog operation create_table" ] -[ "sqlcatalog", "create_trigger", "pattern sqlcatalog.create_trigger(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:str, X_7:str, X_8:str, X_9:str):void ", "SQLcreate_trigger;", "Catalog operation create_trigger" ] +[ "sqlcatalog", "create_trigger", "pattern sqlcatalog.create_trigger(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:str, X_7:str, X_8:str, X_9:str, X_10:int):void ", "SQLcreate_trigger;", "Catalog operation create_trigger" ] [ "sqlcatalog", "create_type", "pattern sqlcatalog.create_type(X_0:str, X_1:str, X_2:str):void ", "SQLcreate_type;", "Catalog operation create_type" ] [ "sqlcatalog", "create_user", "pattern sqlcatalog.create_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str, X_5:str):void ", "SQLcreate_user;", "Catalog operation create_user" ] -[ "sqlcatalog", "create_view", "pattern sqlcatalog.create_view(X_0:str, X_1:str, X_2:ptr, X_3:int):void ", "SQLcreate_view;", "Catalog operation create_view" ] +[ "sqlcatalog", "create_view", "pattern sqlcatalog.create_view(X_0:str, X_1:str, X_2:ptr, X_3:int, X_4:int):void ", "SQLcreate_view;", "Catalog operation create_view" ] [ "sqlcatalog", "drop_constraint", "pattern sqlcatalog.drop_constraint(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int):void ", "SQLdrop_constraint;", "Catalog operation drop_constraint" ] [ "sqlcatalog", "drop_function", "pattern sqlcatalog.drop_function(X_0:str, X_1:str, X_2:int, X_3:int, X_4:int):void ", "SQLdrop_function;", "Catalog operation drop_function" ] [ "sqlcatalog", "drop_index", "pattern sqlcatalog.drop_index(X_0:str, X_1:str, X_2:int):void ", "SQLdrop_index;", "Catalog operation drop_index" ] @@ -9613,15 +9663,15 @@ [ "wlc", "comment_on", "pattern wlc.comment_on(X_0:int, X_1:str):void ", "WLCgeneric;", "Catalog operation comment_on" ] [ "wlc", "commit", "pattern wlc.commit():void ", "WLCcommitCmd;", "Commit the workload-capture-replay record" ] [ "wlc", "commit", "pattern wlc.commit():void ", "WLCcommitCmd;", "Mark the end of the work unit" ] -[ "wlc", "create_function", "pattern wlc.create_function(X_0:str, X_1:str):void ", "WLCgeneric;", "Catalog operation create_function" ] +[ "wlc", "create_function", "pattern wlc.create_function(X_0:str, X_1:str, X_2:int):void ", "WLCgeneric;", "Catalog operation create_function" ] [ "wlc", "create_role", "pattern wlc.create_role(X_0:str, X_1:str, X_2:int):void ", "WLCgeneric;", "Catalog operation create_role" ] [ "wlc", "create_schema", "pattern wlc.create_schema(X_0:str, X_1:str, X_2:int):void ", "WLCgeneric;", "Catalog operation create_schema" ] [ "wlc", "create_seq", "pattern wlc.create_seq(X_0:str, X_1:str, X_2:int):void ", "WLCgeneric;", "Catalog operation create_seq" ] [ "wlc", "create_table", "pattern wlc.create_table(X_0:str, X_1:str, X_2:int):void ", "WLCgeneric;", "Catalog operation create_table" ] -[ "wlc", "create_trigger", "pattern wlc.create_trigger(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:str, X_7:str, X_8:str, X_9:str):void ", "WLCgeneric;", "Catalog operation create_trigger" ] +[ "wlc", "create_trigger", "pattern wlc.create_trigger(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:str, X_7:str, X_8:str, X_9:str, X_10:int):void ", "WLCgeneric;", "Catalog operation create_trigger" ] [ "wlc", "create_type", "pattern wlc.create_type(X_0:str, X_1:str, X_2:str):void ", "WLCgeneric;", "Catalog operation create_type" ] [ "wlc", "create_user", "pattern wlc.create_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str):void ", "WLCgeneric;", "Catalog operation create_user" ] -[ "wlc", "create_view", "pattern wlc.create_view(X_0:str, X_1:str, X_2:int):void ", "WLCgeneric;", "Catalog operation create_view" ] +[ "wlc", "create_view", "pattern wlc.create_view(X_0:str, X_1:str, X_2:int, X_3:int):void ", "WLCgeneric;", "Catalog operation create_view" ] [ "wlc", "delete", "pattern wlc.delete(X_0:str, X_1:str, X_2:any):int ", "WLCdelete;", "Keep the deletions in the workload-capture-replay list" ] [ "wlc", "drop_constraint", "pattern wlc.drop_constraint(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int):void ", "WLCgeneric;", "Catalog operation drop_constraint" ] [ "wlc", "drop_function", "pattern wlc.drop_function(X_0:str, X_1:str, X_2:int, X_3:int, X_4:int):void ", "WLCgeneric;", "Catalog operation drop_function" ] @@ -9682,15 +9732,15 @@ [ "wlr", "clear_table", "pattern wlr.clear_table(X_0:str, X_1:str):int ", "WLRclear_table;", "Destroy the tuples in the table" ] [ "wlr", "comment_on", "pattern wlr.comment_on(X_0:int, X_1:str):void ", "WLRgeneric;", "Catalog operation comment_on" ] [ "wlr", "commit", "pattern wlr.commit():void ", "WLRcommit;", "Mark the end of the work unit" ] -[ "wlr", "create_function", "pattern wlr.create_function(X_0:str, X_1:str):void ", "WLRgeneric;", "Catalog operation create_function" ] +[ "wlr", "create_function", "pattern wlr.create_function(X_0:str, X_1:str, X_2:int):void ", "WLRgeneric;", "Catalog operation create_function" ] [ "wlr", "create_role", "pattern wlr.create_role(X_0:str, X_1:str, X_2:int):void ", "WLRgeneric;", "Catalog operation create_role" ] [ "wlr", "create_schema", "pattern wlr.create_schema(X_0:str, X_1:str, X_2:int):void ", "WLRgeneric;", "Catalog operation create_schema" ] [ "wlr", "create_seq", "pattern wlr.create_seq(X_0:str, X_1:str, X_2:int):void ", "WLRgeneric;", "Catalog operation create_seq" ] [ "wlr", "create_table", "pattern wlr.create_table(X_0:str, X_1:str, X_2:int):void ", "WLRgeneric;", "Catalog operation create_table" ] -[ "wlr", "create_trigger", "pattern wlr.create_trigger(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:str, X_7:str, X_8:str, X_9:str):void ", "WLRgeneric;", "Catalog operation create_trigger" ] +[ "wlr", "create_trigger", "pattern wlr.create_trigger(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int, X_5:int, X_6:str, X_7:str, X_8:str, X_9:str, X_10:int):void ", "WLRgeneric;", "Catalog operation create_trigger" ] [ "wlr", "create_type", "pattern wlr.create_type(X_0:str, X_1:str, X_2:str):void ", "WLRgeneric;", "Catalog operation create_type" ] [ "wlr", "create_user", "pattern wlr.create_user(X_0:str, X_1:str, X_2:int, X_3:str, X_4:str):void ", "WLRgeneric;", "Catalog operation create_user" ] -[ "wlr", "create_view", "pattern wlr.create_view(X_0:str, X_1:str, X_2:int):void ", "WLRgeneric;", "Catalog operation create_view" ] +[ "wlr", "create_view", "pattern wlr.create_view(X_0:str, X_1:str, X_2:int, X_3:int):void ", "WLRgeneric;", "Catalog operation create_view" ] [ "wlr", "delete", "pattern wlr.delete(X_0:str, X_1:str, X_2:oid...):int ", "WLRdelete;", "Apply the deletions in the workload-capture-replay list" ] [ "wlr", "drop_constraint", "pattern wlr.drop_constraint(X_0:str, X_1:str, X_2:str, X_3:int, X_4:int):void ", "WLRgeneric;", "Catalog operation drop_constraint" ] [ "wlr", "drop_function", "pattern wlr.drop_function(X_0:str, X_1:str, X_2:int, X_3:int, X_4:int):void ", "WLRgeneric;", "Catalog operation drop_function" ] diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list