This topic describes the ROUTE_INFO diagnostic point.
The ROUTE_INFO diagnostic point records the routing type or routing address. The following table describes the diagnostic information at the ROUTE_INFO diagnostic point.
| Field | Description | Remarks |
|---|---|---|
| route_info_type | The routing type. | Valid values:
|
| svr_addr | The address of the selected OBServer node. | When the value of route_info_type is USE_CURSOR, USE_PIECES_DATA, USE_CONFIG_TARGET_DB, USE_COMMENT_TARGET_DB, USE_LAST_SESSION, USE_CACHED_SESSION, or USE_COORDINATOR_SESSION, the IP address of the OBServer node is returned here. |
| in_transaction | Indicates whether the current statement is in a transaction. | If the current SQL statement is the first statement in a transaction, the value of this parameter is false. |
| depent_func | Indicates whether the user request involves function dependencies, that is, whether the current statement depends on the execution result of the last statement. | The following seven statements contain function dependencies in requests:
|
| trans_specified | Indicates whether to perform forcible routing. | In forcible routing, a session-level temporary table may be queried. |