Issue Information
| Issue Number | 701252a |
| Issue | When nodes requiring sorting of all rows in the PE PLAN are processed by partition, the sort order of the results is not maintained. |
| Cause | When processing by partition, the sort order of all rows is not maintained. |
| Solutions | When sorting of all rows is required, the process has been modified to sort across the entire range instead of by partition. |
| Occurrence Date | 26.08.10. |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701252a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fixed an issue where the sort order of all rows was not maintained when using KEEP_ORDER_GLOBAL |
| Available for Release | 26.10.01. |
| 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: Yes • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameters | - |
| Workaround | - |