Issue Information
| Issue Number | 701407a |
| Issue | Incorrect results may occur when a hash join has a send partition key node on the left and an index desc scan node on the right. |
| Cause | The partition indexes between the send part key node and the scan node were inconsistent. As a result, data from different partitions could be joined on a single slave, potentially causing incorrect results. |
| Solutions | The partition index consistency between the send part key node and the scan node was corrected. |
| Occurrence Date | 26.09.15. |
| Required Patch Version | 6FS07PS 7FS02PS |
Patch Information
| Patch Name | FS02PS_701407a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Resolving Incorrect Results When send part key and index desc scan Are Used Simultaneously |
| Available Release 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: No • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameter | - |
| Workaround | ALTER SYSTEM SET _ENABLE_PARTIAL_PW_JOIN = N; |