Fun_GetJson_Length.md 893 Bytes

Fun_GetJson_Length (function)

  • Type: FUNCTION
  • Returns: int
  • Deterministic: NO
  • SQL data access: CONTAINS SQL

Parameters

# Mode Name Type
1 IN sJson longtext

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFunGetJson_Length'._

Narrative

Business context: JSON-array length helper. Trivially thin wrapper for callers that want a "未解析到Key" sentinel instead of an error when the input is malformed.

What it does: if JSON_VALID(sJson) = 1, returns JSON_LENGTH(sJson). Otherwise returns the string "未解析到Key".

Invocation: Status: appears orphaned. No caller found in any channel (form-master sSqlStr, gdsmodule hooks, other routines, exhaustive xly-src grep, dynamic-dispatch search) — candidate for maintainer audit.