Package dev.frostlake.functions.scalar.string

Class Insert

java.lang.Object
dev.frostlake.functions.BuiltInFunction
dev.frostlake.functions.TextArgumentFunction
dev.frostlake.functions.scalar.string.Insert
public class Insert extends TextArgumentFunction
INSERT(base, position, length, insertion). The account plans it as SUBSTR(base, 1, position - 1) || insertion || SUBSTR(base, position + length) and answers exactly that, SUBSTR's windows included (all live-verified): 
   INSERT('abc', 2, 1, 'x')     axc        INSERT('abc', 0, 1, 'x')    xabc
   INSERT('abc', 2, -1, 'x')    axabc      INSERT('abc', -2, 1, 'x')   xc      a negative start counts back
   INSERT('abc', 5, 1, 'x')     abcx       INSERT('abc', 1, 1, NULL)   NULL    any NULL argument
   INSERT(X'6162', 1, 1, X'63') 6362       two binaries splice their BYTES

A BINARY beside another family is judged as that concatenation — see SemiStructuredRejection.INSERT_REWRITE_OPERANDS.

  • Constructor Details

    • Insert

      public Insert()

  • Method Details

    • 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

    • binaryRejection

      public SemiStructuredRejection binaryRejection(int position)
      A BINARY anywhere is judged as the concatenation the call is planned as (live-verified).
      Overrides:
      binaryRejection in class BuiltInFunction
      Parameters:
      position - the zero-based argument position being asked about
      Returns:
      the refusal this position gives a BINARY value; by default none