Package dev.frostlake.functions.scalar.semistructured

Class MapInsert

java.lang.Object
dev.frostlake.functions.BuiltInFunction
dev.frostlake.functions.scalar.semistructured.MapInsert
public class MapInsert extends BuiltInFunction
MAP_INSERT(map, key, value [, updateFlag]) — the map with one entry added or replaced.

Its NULL handling is its own, and every branch was measured live rather than carried over from OBJECT_INSERT, which differs on two of them: a NULL map answers NULL, a NULL KEY answers NULL (OBJECT_INSERT returns the map unchanged), and a NULL VALUE is STORED as a JSON null member — MAP_INSERT(<{'a':1}>, 'b', NULL) is {"a":1,"b":null} and MAP_SIZE of it is 2, where OBJECT_INSERT omits the pair.

Inserting a key the map already holds is a RUN-TIME error, "Duplicate field key 'a'", unless the fourth argument is TRUE; live gives the same error for an absent flag, an explicit FALSE and an explicit NULL alike.

  • Constructor Details

    • MapInsert

      public MapInsert()

  • 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