Changeset: 75069b186048 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=75069b186048
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
        
sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out.Windows
        sql/test/subquery/Tests/subquery4.sql
Branch: Jun2020
Log Message:

Approved outputs and added explicit ordering at subquery4 test queries for 
consistent results across testing platforms


diffs (truncated from 1521 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
@@ -7596,24 +7596,38 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:str], 
r:bat[:bit]):bat[:bte] ",     "CMDconvertsignal_bte;",        "cast from str to 
bte, signal error on overflow"        ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:str], 
s:bat[:oid]):bat[:bte] ",     "CMDconvertsignal_bte;",        "cast from str to 
bte with candidates list, signal error on overflow"   ]
 [ "batcalc",   "bte",  "pattern batcalc.bte(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:bte] ",        "CMDconvertsignal_bte;",        "cast from str 
to bte with candidates list, signal error on overflow"   ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:bte] ",     "batbte_ce_dec2_bte;",  "cast decimal(bte) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batbte_ce_dec2dec_bte;",       "cast 
decimal(bte) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batbte_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte]):bat[:bte] ",  
"batbte_dec2_bte;",     "cast decimal(bte) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:bte] ",  "batbte_dec2dec_bte;",  "cast decimal(bte) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:bte], digits:int, 
scale:int):bat[:bte] ",   "batbte_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batdbl_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:dbl], digits:int, 
scale:int):bat[:bte] ",   "batdbl_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batflt_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:flt], digits:int, 
scale:int):bat[:bte] ",   "batflt_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:bte] ",     "batint_ce_dec2_bte;",  "cast decimal(int) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batint_ce_dec2dec_bte;",       "cast 
decimal(int) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batint_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int]):bat[:bte] ",  
"batint_dec2_bte;",     "cast decimal(int) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:bte] ",  "batint_dec2dec_bte;",  "cast decimal(int) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:int], digits:int, 
scale:int):bat[:bte] ",   "batint_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:bte] ",     "batlng_ce_dec2_bte;",  "cast decimal(lng) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batlng_ce_dec2dec_bte;",       "cast 
decimal(lng) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batlng_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng]):bat[:bte] ",  
"batlng_dec2_bte;",     "cast decimal(lng) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:bte] ",  "batlng_dec2dec_bte;",  "cast decimal(lng) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:lng], digits:int, 
scale:int):bat[:bte] ",   "batlng_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:oid], digits:int, 
scale:int):bat[:bte] ",   "batnil_2dec_bte;",     "cast to dec(bte) and check 
for overflow"       ]
-[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:oid], digits:int):bat[:bte] 
",      "batnil_2num_bte;",     "cast to bte and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:oid], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batnil_ce_2dec_bte;",  "cast to 
dec(bte) and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:bte] ",     "batsht_ce_dec2_bte;",  "cast decimal(sht) to bte 
and check for overflow"       ]
+[ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:bte] ",     "batsht_ce_dec2dec_bte;",       "cast 
decimal(sht) to decimal(bte) and check for overflow"      ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batsht_ce_num2dec_bte;",       "cast 
number to decimal(bte) and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht]):bat[:bte] ",  
"batsht_dec2_bte;",     "cast decimal(sht) to bte and check for overflow"       
]
 [ "batcalc",   "bte",  "command batcalc.bte(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:bte] ",  "batsht_dec2dec_bte;",  "cast decimal(sht) to 
decimal(bte) and check for overflow"      ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:sht], digits:int, 
scale:int):bat[:bte] ",   "batsht_num2dec_bte;",  "cast number to decimal(bte) 
and check for overflow"    ]
 [ "batcalc",   "bte",  "command batcalc.bte(v:bat[:str], digits:int, 
scale:int):bat[:bte] ",   "batstr_2dec_bte;",     "cast to dec(bte) and check 
for overflow"       ]
-[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:str], digits:int):bat[:bte] 
",      "batstr_2num_bte;",     "cast to bte and check for overflow"    ]
+[ "batcalc",   "bte",  "command batcalc.bte(v:bat[:str], digits:int, 
scale:int, r:bat[:bit]):bat[:bte] ",      "batstr_ce_2dec_bte;",  "cast to 
dec(bte) and check for overflow"       ]
 [ "batcalc",   "bte_noerror",  "pattern 
batcalc.bte_noerror(b:bat[:bit]):bat[:bte] ",  "CMDconvert_bte;",      "cast 
from bit to bte"  ]
 [ "batcalc",   "bte_noerror",  "pattern batcalc.bte_noerror(b:bat[:bit], 
r:bat[:bit]):bat[:bte] ",     "CMDconvert_bte;",      "cast from bit to bte"  ]
 [ "batcalc",   "bte_noerror",  "pattern batcalc.bte_noerror(b:bat[:bit], 
s:bat[:oid]):bat[:bte] ",     "CMDconvert_bte;",      "cast from bit to bte 
with candidates list"     ]
@@ -8166,15 +8180,27 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:str], 
r:bat[:bit]):bat[:dbl] ",     "CMDconvertsignal_dbl;",        "cast from str to 
dbl, signal error on overflow"        ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:str], 
s:bat[:oid]):bat[:dbl] ",     "CMDconvertsignal_dbl;",        "cast from str to 
dbl with candidates list, signal error on overflow"   ]
 [ "batcalc",   "dbl",  "pattern batcalc.dbl(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:dbl] ",        "CMDconvertsignal_dbl;",        "cast from str 
to dbl with candidates list, signal error on overflow"   ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:dbl] ",     "batbte_ce_dec2_dbl;",  "cast decimal(bte) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batbte_ce_dec2dec_dbl;",       "cast 
decimal(bte) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batbte_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte]):bat[:dbl] ",  
"batbte_dec2_dbl;",     "cast decimal(bte) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:dbl] ",  "batbte_dec2dec_dbl;",  "cast decimal(bte) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:bte], digits:int, 
scale:int):bat[:dbl] ",   "batbte_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:dbl] ",     "batint_ce_dec2_dbl;",  "cast decimal(int) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batint_ce_dec2dec_dbl;",       "cast 
decimal(int) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batint_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int]):bat[:dbl] ",  
"batint_dec2_dbl;",     "cast decimal(int) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:dbl] ",  "batint_dec2dec_dbl;",  "cast decimal(int) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:int], digits:int, 
scale:int):bat[:dbl] ",   "batint_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:dbl] ",     "batlng_ce_dec2_dbl;",  "cast decimal(lng) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batlng_ce_dec2dec_dbl;",       "cast 
decimal(lng) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batlng_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng]):bat[:dbl] ",  
"batlng_dec2_dbl;",     "cast decimal(lng) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:dbl] ",  "batlng_dec2dec_dbl;",  "cast decimal(lng) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:lng], digits:int, 
scale:int):bat[:dbl] ",   "batlng_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:dbl] ",     "batsht_ce_dec2_dbl;",  "cast decimal(sht) to dbl 
and check for overflow"       ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:dbl] ",     "batsht_ce_dec2dec_dbl;",       "cast 
decimal(sht) to decimal(dbl) and check for overflow"      ]
+[ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:dbl] ",      "batsht_ce_num2dec_dbl;",       "cast 
number to decimal(dbl) and check for overflow"    ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht]):bat[:dbl] ",  
"batsht_dec2_dbl;",     "cast decimal(sht) to dbl and check for overflow"       
]
 [ "batcalc",   "dbl",  "command batcalc.dbl(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:dbl] ",  "batsht_dec2dec_dbl;",  "cast decimal(sht) to 
decimal(dbl) and check for overflow"      ]
 [ "batcalc",   "dbl",  "command batcalc.dbl(v:bat[:sht], digits:int, 
scale:int):bat[:dbl] ",   "batsht_num2dec_dbl;",  "cast number to decimal(dbl) 
and check for overflow"    ]
@@ -9006,15 +9032,27 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "flt",  "pattern batcalc.flt(b:bat[:str], 
r:bat[:bit]):bat[:flt] ",     "CMDconvertsignal_flt;",        "cast from str to 
flt, signal error on overflow"        ]
 [ "batcalc",   "flt",  "pattern batcalc.flt(b:bat[:str], 
s:bat[:oid]):bat[:flt] ",     "CMDconvertsignal_flt;",        "cast from str to 
flt with candidates list, signal error on overflow"   ]
 [ "batcalc",   "flt",  "pattern batcalc.flt(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:flt] ",        "CMDconvertsignal_flt;",        "cast from str 
to flt with candidates list, signal error on overflow"   ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:flt] ",     "batbte_ce_dec2_flt;",  "cast decimal(bte) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batbte_ce_dec2dec_flt;",       "cast 
decimal(bte) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batbte_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte]):bat[:flt] ",  
"batbte_dec2_flt;",     "cast decimal(bte) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:flt] ",  "batbte_dec2dec_flt;",  "cast decimal(bte) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:bte], digits:int, 
scale:int):bat[:flt] ",   "batbte_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:flt] ",     "batint_ce_dec2_flt;",  "cast decimal(int) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batint_ce_dec2dec_flt;",       "cast 
decimal(int) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batint_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int]):bat[:flt] ",  
"batint_dec2_flt;",     "cast decimal(int) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:flt] ",  "batint_dec2dec_flt;",  "cast decimal(int) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:int], digits:int, 
scale:int):bat[:flt] ",   "batint_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:flt] ",     "batlng_ce_dec2_flt;",  "cast decimal(lng) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batlng_ce_dec2dec_flt;",       "cast 
decimal(lng) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batlng_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng]):bat[:flt] ",  
"batlng_dec2_flt;",     "cast decimal(lng) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:flt] ",  "batlng_dec2dec_flt;",  "cast decimal(lng) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:lng], digits:int, 
scale:int):bat[:flt] ",   "batlng_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:flt] ",     "batsht_ce_dec2_flt;",  "cast decimal(sht) to flt 
and check for overflow"       ]
+[ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:flt] ",     "batsht_ce_dec2dec_flt;",       "cast 
decimal(sht) to decimal(flt) and check for overflow"      ]
+[ "batcalc",   "flt",  "command batcalc.flt(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:flt] ",      "batsht_ce_num2dec_flt;",       "cast 
number to decimal(flt) and check for overflow"    ]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht]):bat[:flt] ",  
"batsht_dec2_flt;",     "cast decimal(sht) to flt and check for overflow"       
]
 [ "batcalc",   "flt",  "command batcalc.flt(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:flt] ",  "batsht_dec2dec_flt;",  "cast decimal(sht) to 
decimal(flt) and check for overflow"      ]
 [ "batcalc",   "flt",  "command batcalc.flt(v:bat[:sht], digits:int, 
scale:int):bat[:flt] ",   "batsht_num2dec_flt;",  "cast number to decimal(flt) 
and check for overflow"    ]
@@ -9111,24 +9149,38 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "int",  "pattern batcalc.int(b:bat[:str], 
r:bat[:bit]):bat[:int] ",     "CMDconvertsignal_int;",        "cast from str to 
int, signal error on overflow"        ]
 [ "batcalc",   "int",  "pattern batcalc.int(b:bat[:str], 
s:bat[:oid]):bat[:int] ",     "CMDconvertsignal_int;",        "cast from str to 
int with candidates list, signal error on overflow"   ]
 [ "batcalc",   "int",  "pattern batcalc.int(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:int] ",        "CMDconvertsignal_int;",        "cast from str 
to int with candidates list, signal error on overflow"   ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:int] ",     "batbte_ce_dec2_int;",  "cast decimal(bte) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batbte_ce_dec2dec_int;",       "cast 
decimal(bte) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batbte_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte]):bat[:int] ",  
"batbte_dec2_int;",     "cast decimal(bte) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:int] ",  "batbte_dec2dec_int;",  "cast decimal(bte) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:bte], digits:int, 
scale:int):bat[:int] ",   "batbte_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batdbl_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:dbl], digits:int, 
scale:int):bat[:int] ",   "batdbl_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batflt_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:flt], digits:int, 
scale:int):bat[:int] ",   "batflt_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:int] ",     "batint_ce_dec2_int;",  "cast decimal(int) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batint_ce_dec2dec_int;",       "cast 
decimal(int) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batint_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int]):bat[:int] ",  
"batint_dec2_int;",     "cast decimal(int) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:int] ",  "batint_dec2dec_int;",  "cast decimal(int) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:int], digits:int, 
scale:int):bat[:int] ",   "batint_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:int] ",     "batlng_ce_dec2_int;",  "cast decimal(lng) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batlng_ce_dec2dec_int;",       "cast 
decimal(lng) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batlng_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng]):bat[:int] ",  
"batlng_dec2_int;",     "cast decimal(lng) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:int] ",  "batlng_dec2dec_int;",  "cast decimal(lng) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:lng], digits:int, 
scale:int):bat[:int] ",   "batlng_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:oid], digits:int, 
scale:int):bat[:int] ",   "batnil_2dec_int;",     "cast to dec(int) and check 
for overflow"       ]
-[ "batcalc",   "int",  "command batcalc.int(v:bat[:oid], digits:int):bat[:int] 
",      "batnil_2num_int;",     "cast to int and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:oid], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batnil_ce_2dec_int;",  "cast to 
dec(int) and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:int] ",     "batsht_ce_dec2_int;",  "cast decimal(sht) to int 
and check for overflow"       ]
+[ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:int] ",     "batsht_ce_dec2dec_int;",       "cast 
decimal(sht) to decimal(int) and check for overflow"      ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batsht_ce_num2dec_int;",       "cast 
number to decimal(int) and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht]):bat[:int] ",  
"batsht_dec2_int;",     "cast decimal(sht) to int and check for overflow"       
]
 [ "batcalc",   "int",  "command batcalc.int(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:int] ",  "batsht_dec2dec_int;",  "cast decimal(sht) to 
decimal(int) and check for overflow"      ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:sht], digits:int, 
scale:int):bat[:int] ",   "batsht_num2dec_int;",  "cast number to decimal(int) 
and check for overflow"    ]
 [ "batcalc",   "int",  "command batcalc.int(v:bat[:str], digits:int, 
scale:int):bat[:int] ",   "batstr_2dec_int;",     "cast to dec(int) and check 
for overflow"       ]
-[ "batcalc",   "int",  "command batcalc.int(v:bat[:str], digits:int):bat[:int] 
",      "batstr_2num_int;",     "cast to int and check for overflow"    ]
+[ "batcalc",   "int",  "command batcalc.int(v:bat[:str], digits:int, 
scale:int, r:bat[:bit]):bat[:int] ",      "batstr_ce_2dec_int;",  "cast to 
dec(int) and check for overflow"       ]
 [ "batcalc",   "int_noerror",  "pattern 
batcalc.int_noerror(b:bat[:bit]):bat[:int] ",  "CMDconvert_int;",      "cast 
from bit to int"  ]
 [ "batcalc",   "int_noerror",  "pattern batcalc.int_noerror(b:bat[:bit], 
r:bat[:bit]):bat[:int] ",     "CMDconvert_int;",      "cast from bit to int"  ]
 [ "batcalc",   "int_noerror",  "pattern batcalc.int_noerror(b:bat[:bit], 
s:bat[:oid]):bat[:int] ",     "CMDconvert_int;",      "cast from bit to int 
with candidates list"     ]
@@ -9233,24 +9285,38 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "lng",  "pattern batcalc.lng(b:bat[:str], 
r:bat[:bit]):bat[:lng] ",     "CMDconvertsignal_lng;",        "cast from str to 
lng, signal error on overflow"        ]
 [ "batcalc",   "lng",  "pattern batcalc.lng(b:bat[:str], 
s:bat[:oid]):bat[:lng] ",     "CMDconvertsignal_lng;",        "cast from str to 
lng with candidates list, signal error on overflow"   ]
 [ "batcalc",   "lng",  "pattern batcalc.lng(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:lng] ",        "CMDconvertsignal_lng;",        "cast from str 
to lng with candidates list, signal error on overflow"   ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:lng] ",     "batbte_ce_dec2_lng;",  "cast decimal(bte) to lng 
and check for overflow"       ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:lng] ",     "batbte_ce_dec2dec_lng;",       "cast 
decimal(bte) to decimal(lng) and check for overflow"      ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batbte_ce_num2dec_lng;",       "cast 
number to decimal(lng) and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:bte]):bat[:lng] ",  
"batbte_dec2_lng;",     "cast decimal(bte) to lng and check for overflow"       
]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:lng] ",  "batbte_dec2dec_lng;",  "cast decimal(bte) to 
decimal(lng) and check for overflow"      ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:bte], digits:int, 
scale:int):bat[:lng] ",   "batbte_num2dec_lng;",  "cast number to decimal(lng) 
and check for overflow"    ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batdbl_ce_num2dec_lng;",       "cast 
number to decimal(lng) and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:dbl], digits:int, 
scale:int):bat[:lng] ",   "batdbl_num2dec_lng;",  "cast number to decimal(lng) 
and check for overflow"    ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batflt_ce_num2dec_lng;",       "cast 
number to decimal(lng) and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:flt], digits:int, 
scale:int):bat[:lng] ",   "batflt_num2dec_lng;",  "cast number to decimal(lng) 
and check for overflow"    ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:lng] ",     "batint_ce_dec2_lng;",  "cast decimal(int) to lng 
and check for overflow"       ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:lng] ",     "batint_ce_dec2dec_lng;",       "cast 
decimal(int) to decimal(lng) and check for overflow"      ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batint_ce_num2dec_lng;",       "cast 
number to decimal(lng) and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:int]):bat[:lng] ",  
"batint_dec2_lng;",     "cast decimal(int) to lng and check for overflow"       
]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:lng] ",  "batint_dec2dec_lng;",  "cast decimal(int) to 
decimal(lng) and check for overflow"      ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:int], digits:int, 
scale:int):bat[:lng] ",   "batint_num2dec_lng;",  "cast number to decimal(lng) 
and check for overflow"    ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:lng] ",     "batlng_ce_dec2_lng;",  "cast decimal(lng) to lng 
and check for overflow"       ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:lng] ",     "batlng_ce_dec2dec_lng;",       "cast 
decimal(lng) to decimal(lng) and check for overflow"      ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batlng_ce_num2dec_lng;",       "cast 
number to decimal(lng) and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:lng]):bat[:lng] ",  
"batlng_dec2_lng;",     "cast decimal(lng) to lng and check for overflow"       
]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:lng] ",  "batlng_dec2dec_lng;",  "cast decimal(lng) to 
decimal(lng) and check for overflow"      ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:lng], digits:int, 
scale:int):bat[:lng] ",   "batlng_num2dec_lng;",  "cast number to decimal(lng) 
and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:oid], digits:int, 
scale:int):bat[:lng] ",   "batnil_2dec_lng;",     "cast to dec(lng) and check 
for overflow"       ]
-[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:oid], digits:int):bat[:lng] 
",      "batnil_2num_lng;",     "cast to lng and check for overflow"    ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:oid], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batnil_ce_2dec_lng;",  "cast to 
dec(lng) and check for overflow"       ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:lng] ",     "batsht_ce_dec2_lng;",  "cast decimal(sht) to lng 
and check for overflow"       ]
+[ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:lng] ",     "batsht_ce_dec2dec_lng;",       "cast 
decimal(sht) to decimal(lng) and check for overflow"      ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batsht_ce_num2dec_lng;",       "cast 
number to decimal(lng) and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:sht]):bat[:lng] ",  
"batsht_dec2_lng;",     "cast decimal(sht) to lng and check for overflow"       
]
 [ "batcalc",   "lng",  "command batcalc.lng(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:lng] ",  "batsht_dec2dec_lng;",  "cast decimal(sht) to 
decimal(lng) and check for overflow"      ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:sht], digits:int, 
scale:int):bat[:lng] ",   "batsht_num2dec_lng;",  "cast number to decimal(lng) 
and check for overflow"    ]
 [ "batcalc",   "lng",  "command batcalc.lng(v:bat[:str], digits:int, 
scale:int):bat[:lng] ",   "batstr_2dec_lng;",     "cast to dec(lng) and check 
for overflow"       ]
-[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:str], digits:int):bat[:lng] 
",      "batstr_2num_lng;",     "cast to lng and check for overflow"    ]
+[ "batcalc",   "lng",  "command batcalc.lng(v:bat[:str], digits:int, 
scale:int, r:bat[:bit]):bat[:lng] ",      "batstr_ce_2dec_lng;",  "cast to 
dec(lng) and check for overflow"       ]
 [ "batcalc",   "lng_noerror",  "pattern 
batcalc.lng_noerror(b:bat[:bit]):bat[:lng] ",  "CMDconvert_lng;",      "cast 
from bit to lng"  ]
 [ "batcalc",   "lng_noerror",  "pattern batcalc.lng_noerror(b:bat[:bit], 
r:bat[:bit]):bat[:lng] ",     "CMDconvert_lng;",      "cast from bit to lng"  ]
 [ "batcalc",   "lng_noerror",  "pattern batcalc.lng_noerror(b:bat[:bit], 
s:bat[:oid]):bat[:lng] ",     "CMDconvert_lng;",      "cast from bit to lng 
with candidates list"     ]
@@ -10544,24 +10610,38 @@ stdout of test 'MAL-signatures` in direc
 [ "batcalc",   "sht",  "pattern batcalc.sht(b:bat[:str], 
r:bat[:bit]):bat[:sht] ",     "CMDconvertsignal_sht;",        "cast from str to 
sht, signal error on overflow"        ]
 [ "batcalc",   "sht",  "pattern batcalc.sht(b:bat[:str], 
s:bat[:oid]):bat[:sht] ",     "CMDconvertsignal_sht;",        "cast from str to 
sht with candidates list, signal error on overflow"   ]
 [ "batcalc",   "sht",  "pattern batcalc.sht(b:bat[:str], s:bat[:oid], 
r:bat[:bit]):bat[:sht] ",        "CMDconvertsignal_sht;",        "cast from str 
to sht with candidates list, signal error on overflow"   ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:bte], 
r:bat[:bit]):bat[:sht] ",     "batbte_ce_dec2_sht;",  "cast decimal(bte) to sht 
and check for overflow"       ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:bte], d2:int, 
s2:int, r:bat[:bit]):bat[:sht] ",     "batbte_ce_dec2dec_sht;",       "cast 
decimal(bte) to decimal(sht) and check for overflow"      ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:bte], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batbte_ce_num2dec_sht;",       "cast 
number to decimal(sht) and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:bte]):bat[:sht] ",  
"batbte_dec2_sht;",     "cast decimal(bte) to sht and check for overflow"       
]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:bte], d2:int, 
s2:int):bat[:sht] ",  "batbte_dec2dec_sht;",  "cast decimal(bte) to 
decimal(sht) and check for overflow"      ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:bte], digits:int, 
scale:int):bat[:sht] ",   "batbte_num2dec_sht;",  "cast number to decimal(sht) 
and check for overflow"    ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:dbl], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batdbl_ce_num2dec_sht;",       "cast 
number to decimal(sht) and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:dbl], digits:int, 
scale:int):bat[:sht] ",   "batdbl_num2dec_sht;",  "cast number to decimal(sht) 
and check for overflow"    ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:flt], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batflt_ce_num2dec_sht;",       "cast 
number to decimal(sht) and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:flt], digits:int, 
scale:int):bat[:sht] ",   "batflt_num2dec_sht;",  "cast number to decimal(sht) 
and check for overflow"    ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:int], 
r:bat[:bit]):bat[:sht] ",     "batint_ce_dec2_sht;",  "cast decimal(int) to sht 
and check for overflow"       ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:int], d2:int, 
s2:int, r:bat[:bit]):bat[:sht] ",     "batint_ce_dec2dec_sht;",       "cast 
decimal(int) to decimal(sht) and check for overflow"      ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:int], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batint_ce_num2dec_sht;",       "cast 
number to decimal(sht) and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:int]):bat[:sht] ",  
"batint_dec2_sht;",     "cast decimal(int) to sht and check for overflow"       
]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:int], d2:int, 
s2:int):bat[:sht] ",  "batint_dec2dec_sht;",  "cast decimal(int) to 
decimal(sht) and check for overflow"      ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:int], digits:int, 
scale:int):bat[:sht] ",   "batint_num2dec_sht;",  "cast number to decimal(sht) 
and check for overflow"    ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:lng], 
r:bat[:bit]):bat[:sht] ",     "batlng_ce_dec2_sht;",  "cast decimal(lng) to sht 
and check for overflow"       ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:lng], d2:int, 
s2:int, r:bat[:bit]):bat[:sht] ",     "batlng_ce_dec2dec_sht;",       "cast 
decimal(lng) to decimal(sht) and check for overflow"      ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:lng], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batlng_ce_num2dec_sht;",       "cast 
number to decimal(sht) and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:lng]):bat[:sht] ",  
"batlng_dec2_sht;",     "cast decimal(lng) to sht and check for overflow"       
]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:lng], d2:int, 
s2:int):bat[:sht] ",  "batlng_dec2dec_sht;",  "cast decimal(lng) to 
decimal(sht) and check for overflow"      ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:lng], digits:int, 
scale:int):bat[:sht] ",   "batlng_num2dec_sht;",  "cast number to decimal(sht) 
and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:oid], digits:int, 
scale:int):bat[:sht] ",   "batnil_2dec_sht;",     "cast to dec(sht) and check 
for overflow"       ]
-[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:oid], digits:int):bat[:sht] 
",      "batnil_2num_sht;",     "cast to sht and check for overflow"    ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:oid], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batnil_ce_2dec_sht;",  "cast to 
dec(sht) and check for overflow"       ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:sht], 
r:bat[:bit]):bat[:sht] ",     "batsht_ce_dec2_sht;",  "cast decimal(sht) to sht 
and check for overflow"       ]
+[ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:sht], d2:int, 
s2:int, r:bat[:bit]):bat[:sht] ",     "batsht_ce_dec2dec_sht;",       "cast 
decimal(sht) to decimal(sht) and check for overflow"      ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:sht], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batsht_ce_num2dec_sht;",       "cast 
number to decimal(sht) and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:sht]):bat[:sht] ",  
"batsht_dec2_sht;",     "cast decimal(sht) to sht and check for overflow"       
]
 [ "batcalc",   "sht",  "command batcalc.sht(s1:int, v:bat[:sht], d2:int, 
s2:int):bat[:sht] ",  "batsht_dec2dec_sht;",  "cast decimal(sht) to 
decimal(sht) and check for overflow"      ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:sht], digits:int, 
scale:int):bat[:sht] ",   "batsht_num2dec_sht;",  "cast number to decimal(sht) 
and check for overflow"    ]
 [ "batcalc",   "sht",  "command batcalc.sht(v:bat[:str], digits:int, 
scale:int):bat[:sht] ",   "batstr_2dec_sht;",     "cast to dec(sht) and check 
for overflow"       ]
-[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:str], digits:int):bat[:sht] 
",      "batstr_2num_sht;",     "cast to sht and check for overflow"    ]
+[ "batcalc",   "sht",  "command batcalc.sht(v:bat[:str], digits:int, 
scale:int, r:bat[:bit]):bat[:sht] ",      "batstr_ce_2dec_sht;",  "cast to 
dec(sht) and check for overflow"       ]
 [ "batcalc",   "sht_noerror",  "pattern 
batcalc.sht_noerror(b:bat[:bit]):bat[:sht] ",  "CMDconvert_sht;",      "cast 
from bit to sht"  ]
 [ "batcalc",   "sht_noerror",  "pattern batcalc.sht_noerror(b:bat[:bit], 
r:bat[:bit]):bat[:sht] ",     "CMDconvert_sht;",      "cast from bit to sht"  ]
 [ "batcalc",   "sht_noerror",  "pattern batcalc.sht_noerror(b:bat[:bit], 
s:bat[:oid]):bat[:sht] ",     "CMDconvert_sht;",      "cast from bit to sht 
with candidates list"     ]
diff --git 
a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out 
b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
--- a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
+++ b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
@@ -198,537 +198,537 @@ stdout of test 'hexadecimal_literals.Bug
 % 1 # length
 [ 0    ]
 #select 0x00;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 0    ]
 #select 0x0000;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 0    ]
 #select 0x00000000;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 0    ]
 #select 0x0000000000000000;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 0    ]
 #select 0x00000000000000000000000000000000;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 0    ]
 #select 0x01;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
 #select 0x0001;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
 #select 0x00000001;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
 [ 1    ]
 #select 0x0000000000000001;
-% . # table_name
-% single_value # name
+% .%2 # table_name
+% %2 # name
 % tinyint # type
 % 1 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to