Package dev.frostlake.functions

Class SystemFunctionNames

java.lang.Object
dev.frostlake.functions.SystemFunctionNames
public final class SystemFunctionNames extends Object
The SYSTEM$ built-ins the engine evaluates itself. They are not in the FunctionRegistry maps — SystemFunctionEvaluator (expression-AST path) and VisitorExpressionBuilder (parse-tree path) switch on the name — so without this set SHOW FUNCTIONS could only list them from a hand-maintained copy, which is exactly how it fell behind.

This set is load-bearing for dispatch: both evaluators reject a name that is not declared here before reaching their switch, so a new case that is not declared here does not work, and SHOW FUNCTIONS enumerates the same set through FunctionRegistry.allDispatchableNames().

SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS is deliberately absent: it is a registered table function, so the registry already contributes it.

Snowflake lists SYSTEM$ routines under SHOW FUNCTIONS, not SHOW PROCEDURES (live-verified) SHOW BUILTIN FUNCTIONS LIKE 'SYSTEM$WAIT' returns SYSTEM$WAIT(NUMBER, DEFAULT VARCHAR) RETURN VARCHAR with is_builtin = 'Y'). Its own listing is incomplete — SYSTEM$TYPEOF and SYSTEM$STREAM_HAS_DATA both work on a real account yet are not among the 156 SYSTEM$ names it returns — so this set describes Frostlake, not that listing.

  • Method Details

    • contains

      public static boolean contains(String name)
      Whether the engine implements this SYSTEM$ name (case-insensitive).

    • names

      public static SortedSet<String> names()
      Every SYSTEM$ function name the engine implements, upper-cased and sorted.