Note
This variable is available starting with V2.2.77.
Description
When a query has the TOPK hint, the is_result_accurate variable indicates whether the result is correct.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to view the values of Session system variables.Modify variables
The
systenant and all user tenants can directly modify the values of Session system variables in their own tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Bool |
| 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 the TOPK hint, indicating that the result is correct.
obclient> SET is_result_accurate= ON;