SYSTEM$CLIENT_VULNERABILITY_INFO¶

语法¶

SYSTEM$CLIENT_VULNERABILITY_INFO()

实参¶

无

返回¶

返回一个包含对象 JSON 数组的字符串。每个对象都包含有关特定客户端和驱动程序的信息，例如 SnowSQL、JDBC 驱动程序等。

Each JSON object contains the following structure:

{
  "clientId": "GO",
  "vulnerabilities": [
    {
      "cve": "CVE-2023-34231",
      "severity": "high",
      "maxAffected": "1.6.18"
    },
    {
      "cve": "CVE-2025-46327",
      "severity": "low",
      "minAffected": "1.7.0",
      "maxAffected": "1.13.2"
    }
  ]
}

其中：

clientId

客户端或驱动程序的内部 ID。可能的值包括：

• DOTNETDriver

• GO

• JDBC

• JSDriver (Node.js)

• ODBC

• PHP_PDO

• PythonConnector

• SnowSQL

• SQLAPI

vulnerabilities

Array of vulnerabilities affecting the client or driver. Each vulnerability is represented as an object with the following name/value pairs:

• cve is the CVE identifier for the vulnerability.

• severity is the severity level of the vulnerability. Possible values include: none, low, medium, high, and critical.

• minAffected is the minimum version of the client or driver that contains this vulnerability. This field is optional, as some vulnerabilities might occur in the first version of a client or driver.

• maxAffected is the maximum version that contains this vulnerability.

使用说明¶

无

示例¶

The following example calls the SYSTEM$CLIENT_VERSION_INFO and SYSTEM$CLIENT_VULNERABIITY_INFO system functions. The example parses the JSON strings returned by these functions and presents the data in tabular form.

-- CLIENT VERSION INFO

SELECT
      value:clientAppId::VARCHAR clientAppId
    , value:clientId::VARCHAR clientId
    , value:minimumNearingEndOfSupportVersion::VARCHAR minimumNearingEndOfSupportVersion
    , value:minimumSupportedVersion::VARCHAR minimumSupportedVersion
    , value:recommendedVersion::VARCHAR recommendedVersion
    , value:deprecatedVersions deprecatedVersions
    , value:_customSupportedVersions_ customSupportedVersions
FROM
    TABLE(FLATTEN(PARSE_JSON(SYSTEM$CLIENT_VERSION_INFO())));

-- CLIENT VULNERABILITY INFO

SELECT
    c:clientId::VARCHAR clientId
    , f.value:cve::VARCHAR cve
    , f.value:maxAffected::VARCHAR maxAffected
    , f.value:minAffected::VARCHAR minAffected
    , f.value:severity::VARCHAR severity
FROM
    (
        SELECT value c
        FROM TABLE(FLATTEN(PARSE_JSON(SYSTEM$CLIENT_VULNERABILITY_INFO())))
    ) c,
    lateral flatten(input => c, path => 'vulnerabilities' ) f;