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