Issue Number : 700883a
| Issue | Incorrect results are returned when using the RANDOM function or SYS_GUID function in the GROUP BY key. |
| Cause | When the RANDOM function or SYS_GUID function is used in the GROUP BY clause and the execution plan includes SORT AGGR and ORDER BY nodes, the ORDER BY node fails to properly handle these functions, resulting in incorrect results. |
| Solutions | Modify the ORDER BY node to correctly handle the RANDOM or SYS_GUID functions when they are included in the GROUP BY key. |
| Occurrence Date | April 22, 2026 |
| Patch Required Version | - |
Patch Information
| Patch Name | FS02PS_700883a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Release Date | July 14, 2026 |
| Version Title | Resolution of Result Errors Occurring When Using RANDOM or SYS_GUID Functions in GROUP BY Key |
| Default Applied Version | - |
| Compatibility Information | No incompatible items โข TAC rolling patch: Supported โข TSC rolling patch: Supported โข Backup data compatibility: Supported โข Protocol compatibility: Supported โข Data format compatibility: Supported |
| AP Impact | โข Plan change: No โข Result value change: Yes โข SQL syntax change: No โข System object change: No โข Existing feature change: No |
| Parameters | - |
| Workaround | - |