Issue Information
| Issue Number | 701460a |
| Issue | When performing a Left Partition Outer Join, duplicate results are retrieved. |
| Cause | When the Partition Key is NULL, it is considered a different partition, resulting in duplicate identical results. |
| Solutions | The system was modified to consider a NULL Partition Key as the same partition, preventing duplicate results. |
| Occurrence Date | 26.09.28. |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701460a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fix for Duplicate Results When Performing a Left Partition Outer Join |
| Available for Deployment | 26.10.01. |
| Compatibility | • TAC rolling patch: Yes • TSC rolling patch: Yes • Backup data compatibility: Yes • Protocol compatibility: Yes • Data format compatibility: Yes |
| AP Impact | • Plan change: No • Result value change: Yes • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameter | - |
| Workaround | - |