Documentation Errata: SQL Function About Resource Control

translator_bot · June 22, 2024, 5:05am

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 文档勘误，sql function about resource control

| username: ShawnYan

There is a function CURRENT_RESOURCE_GROUP() that can check the resource group bound to the current session of the user,

but, this function is not provided in MySQL 5.7, so it should not appear on this page,

github.com

pingcap/docs/blob/master/functions-and-operators/information-functions.md?plain=1#L17


      
          # Information Functions
          
          TiDB supports most of the [information functions](https://dev.mysql.com/doc/refman/8.0/en/information-functions.html) available in MySQL 8.0.
          
          ## TiDB supported MySQL functions
          
          | Name | Description |
          |:-----|:------------|
          | [`BENCHMARK()`](#benchmark) | Execute an expression in a loop |
          | [`CONNECTION_ID()`](#connection_id) | Return the connection ID (thread ID) for the connection  |
          | [`CURRENT_ROLE()`](#current_role) | Return the role that is in use by the connection |
          | [`CURRENT_USER()`, `CURRENT_USER`](#current_user) | Return the authenticated user name and host name |
          | [`DATABASE()`](#database) | Return the default (current) database name  |
          | [`FOUND_ROWS()`](#found_rows) | For a `SELECT` with a `LIMIT` clause, the number of the rows that are returned if there is no `LIMIT` clause |
          | [`LAST_INSERT_ID()`](#last_insert_id) | Return the value of the `AUTOINCREMENT` column for the last `INSERT`   |
          | [`ROW_COUNT()`](#row_count) | The number of rows affected |
          | [`SCHEMA()`](#schema) | Synonym for `DATABASE()`  |
          | [`SESSION_USER()`](#session_user) | Synonym for `USER()`    |
          | [`SYSTEM_USER()`](#system_user) | Synonym for `USER()`   |
          | [`USER()`](#user) | Return the user name and host name provided by the client    |
          | [`VERSION()`](#version) | Return a string that indicates the MySQL server version   |

github.com

pingcap/docs/blob/master/functions-and-operators/information-functions.md?plain=1#L17


      
          # Information Functions
          
          TiDB supports most of the [information functions](https://dev.mysql.com/doc/refman/8.0/en/information-functions.html) available in MySQL 8.0.
          
          ## TiDB supported MySQL functions
          
          | Name | Description |
          |:-----|:------------|
          | [`BENCHMARK()`](#benchmark) | Execute an expression in a loop |
          | [`CONNECTION_ID()`](#connection_id) | Return the connection ID (thread ID) for the connection  |
          | [`CURRENT_ROLE()`](#current_role) | Return the role that is in use by the connection |
          | [`CURRENT_USER()`, `CURRENT_USER`](#current_user) | Return the authenticated user name and host name |
          | [`DATABASE()`](#database) | Return the default (current) database name  |
          | [`FOUND_ROWS()`](#found_rows) | For a `SELECT` with a `LIMIT` clause, the number of the rows that are returned if there is no `LIMIT` clause |
          | [`LAST_INSERT_ID()`](#last_insert_id) | Return the value of the `AUTOINCREMENT` column for the last `INSERT`   |
          | [`ROW_COUNT()`](#row_count) | The number of rows affected |
          | [`SCHEMA()`](#schema) | Synonym for `DATABASE()`  |
          | [`SESSION_USER()`](#session_user) | Synonym for `USER()`    |
          | [`SYSTEM_USER()`](#system_user) | Synonym for `USER()`   |
          | [`USER()`](#user) | Return the user name and host name provided by the client    |
          | [`VERSION()`](#version) | Return a string that indicates the MySQL server version   |

The MySQL documentation page does not have current_resource_group, and searching the entire documentation also does not have it,
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html

Searching the entire MySQL codebase also does not have it,
https://github.com/search?q=repo%3Amysql%2Fmysql-server+current_resource_group&type=code

@Billmay pls help.