Package dev.frostlake.functions.scalar.semistructured

Class ArrayToString

java.lang.Object
dev.frostlake.functions.BuiltInFunction
dev.frostlake.functions.VariantAccessorFunction
dev.frostlake.functions.scalar.semistructured.ArrayToString
public class ArrayToString extends VariantAccessorFunction
ARRAY_TO_STRING(array, delimiter) — joins array elements with a delimiter.

  • Constructor Details

    • ArrayToString

      public ArrayToString()

  • Method Details

    • structuredRejection

      public SemiStructuredRejection structuredRejection(int position)
      The ARRAY position takes a plain ARRAY and refuses a STRUCTURED one. Live, ARRAY_TO_STRING(a, ',') joins to 1,2 while ARRAY_TO_STRING(sa, ',') is "Invalid argument types for function 'ARRAY_TO_STRING': (ARRAY(NUMBER(38,0)), VARCHAR(1))" — and a MAP is refused there too. Only position 0 is declared: what a structured value does in the DELIMITER position has not been measured, and undeclared means unconstrained.
      Overrides:
      structuredRejection in class BuiltInFunction
      Parameters:
      position - the zero-based argument position being asked about
      Returns:
      the extra refusal this position gives a structured value, or NONE when undeclared

    • evaluate

      public Object evaluate(List<Object> args)
      Description copied from class: BuiltInFunction
      Computes the function's result over its already-evaluated argument values. A SQL NULL argument arrives as Java null, and returning null makes the SQL result NULL.
      Specified by:
      evaluate in class BuiltInFunction
      Parameters:
      args - the argument values, in call order
      Returns:
      the function's value for these arguments, or null for SQL NULL

    • getMinArgCount

      public int getMinArgCount()
      Description copied from class: BuiltInFunction
      The fewest arguments a call to this function may pass; fewer is an argument-count error.
      Specified by:
      getMinArgCount in class BuiltInFunction
      Returns:
      the minimum accepted argument count

    • getMaxArgCount

      public int getMaxArgCount()
      Description copied from class: BuiltInFunction
      The most arguments a call to this function may pass; Integer.MAX_VALUE marks a variadic function (see BuiltInFunction.isVariadic()).
      Specified by:
      getMaxArgCount in class BuiltInFunction
      Returns:
      the maximum accepted argument count