Issue Information
| Issue Number | 701244a |
| Issue | In a Bush Join execution plan, when the left child node of a Hash Join is in a blocking state, the right child node, which is actually not blocking, is incorrectly identified as blocking. |
| Cause | The blocking information of the left child node was passed to the right child node, causing the right child node’s blocking status to be determined based on the left child node’s state instead of its own. |
| Solutions | Modified the system to prevent the blocking information of the left child node from being passed to the right child node, so the right child node determines its blocking status based solely on its own state. |
| Occurrence Date | 08/07/2026 |
| Patch Required Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701244a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fix for Error Where Blocking Does Not Occur in PE When Hash Join Is a Bush Join |
| Release Date | 08/24/2026 |
| Compatibility | • TAC Rolling Patch: Supported • TSC Rolling Patch: Supported • Backup Data Compatibility: Supported • Protocol Compatibility: Supported • Data Format Compatibility: Supported |
| AP Impact | • Plan Change: Yes • Result Value Change: No • SQL Syntax Change: No • System Object Change: No • Existing Feature Change: No |
| Parameters | - |
| Workaround | - |