Context Functions
Context Functions in SQL.
| Function | Description | Example | Result |
|---|---|---|---|
| CONNECTION_ID() | Return the connection id for the connection. | CONNECTION_ID() | 9b16ca73-e393-43bb-a77b-fa546e1b7b69 |
| CURRENT_USER() | Returns the user name and host name combination for the account that the server used to authenticate the current client. This account determines your access privileges. The return value is a string in the utf8 character set. | CURRENT_USER() | 'root'@'%' |
| DATABASE() | Returns the name of the currently selected database. If no database is selected, then this function returns default. | DATABASE() | default |
| VERSION() | Return the current version information of DatabendQuery. | VERSION() | DatabendQuery v-0.1.0-0f9ec31-simd(1.56.0-nightly-2021-08-10T15:25:36.875868571+00:00) |
| LAST_QUERY_ID(index) | Return the last query id of query in current session, index can be (-1, 1, 1+2)..., out of range index will return empty string | LAST_QUERY_ID(-1) | 5334c6a9-3628-4579-82d1-89302ecf1d42 |