Issue Information
| Issue Number | 701460a |
| Issue | Duplicate results are returned when performing a Left Partition Outer Join. |
| Cause | When the Partition Key is NULL, it is treated as a different partition, resulting in duplicate identical results. |
| Solutions | The behavior has been modified so that when the Partition Key is NULL, it is treated as the same partition and duplicate results are not generated. |
| 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 Deployment Date | 26.10.01. |
| Compatibility | • TAC rolling patch: Available • TSC rolling patch: Available • Backup data compatibility: Available • Protocol compatibility: Available • Data format compatibility: Available |
| AP Impact | • Plan change: No • Result value change: Yes • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameters | - |
| Workaround | - |