This topic describes the RESOLVE_EXPR diagnostic point.
The RESOLVE_EXPR diagnostic point records information that OceanBase Database Proxy (ODP) parses the partitioning columns and values provided in the statement into information within a certain scope. The following table describes the diagnostic information at the RESOLVE_EXPR diagnostic point.
| Field | Description | Remarks |
|---|---|---|
| part_range | The partition range in the [start_val ; end_val] format. | Example 1: ... WHERE c1 > 0 AND c1 < 10. In this example, if c1 is a partitioning column, the partition range is [0; 10]. Example 2: ... WHERE c1 = 0 AND c2 > 0 AND c2 < 10. In this example, if c1 and c2 are partitioning columns, the partition range is part_range [0, 0 ; 0, 10]. |
| sub_part_range | The subpartition range, in the [start_val ; end_val] format. | / |