Issue Number : 700631a
| Issue | When executing SQL containing PIVOT BLOB in Parallel mode, an error occurs if PIVOT BLOB-related columns or functions are not used. |
| Cause | A variable is added to the Group By node to perform PIVOT BLOB. However, if the PIVOT function is not used in the upper node, the PIVOT is not executed, and the variable set at this time remains, causing an error. |
| Solutions | Modify the process to initialize PIVOT-related variables when PIVOT is not performed. |
| Occurrence Date | March 6, 2026 |
| Patch Required Version | - |
Patch Information
| Patch Name | FS02PS_700631a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Release Date | June 24, 2026 |
| Version Title | Error Resolution Caused by Removed PIVOT Function in Parallel Plan |
| Base Version Included | - |
| Compatibility Information | No incompatible items • TAC Rolling Patch: Possible • TSC Rolling Patch: Possible • Backup Data Compatibility: Possible • Protocol Compatibility: Possible • Data Format Compatibility: Possible |
| AP Impact | • Plan Change: Yes • Result Value Change: No • SQL Syntax Change: No • System Object Change: No • Existing Feature Change: No |
| Parameters | - |
| Workaround | - |