Note
This variable is available starting with V2.2.77.
Description
When a query has a topk hint, the is_result_accurate variable indicates whether the result is correct.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) or theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of a session-level system variable.Modify variables
systenants and all user tenants can directly modify the value of a session-level system variable in their own tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | ON |
| Value range |
|
| Scope | Session |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the value of the is_result_accurate variable to ON when a query has a topk hint, indicating that the result is correct.
obclient> SET is_result_accurate= ON;