The type a Concat that converts types gives a column of these two types
(PLAN ยง11.5, Q5): the type itself when they are equal, else the most
specific type both are (getLeastCommonAncestor): String for two Varchar
lengths, Integer for SmallInt and Int, Number for Int and Float4, Decimal
for two Numeric precisions, Date for StrictDate and Timestamp. undefined
across numbers, strings and dates, which share no type, and for two
enumerations or opaque types, which share none either.
The type a Concat that converts types gives a column of these two types (PLAN ยง11.5, Q5): the type itself when they are equal, else the most specific type both are (
getLeastCommonAncestor): String for two Varchar lengths, Integer for SmallInt and Int, Number for Int and Float4, Decimal for two Numeric precisions, Date for StrictDate and Timestamp.undefinedacross numbers, strings and dates, which share no type, and for two enumerations or opaque types, which share none either.