Issue Information
| Issue Number | 700999a |
| Issue | Incorrect results occur when the CUBE and ORDER BY clauses are used together. |
| Cause | Incorrect results occur because the internal indexes are changed when the Projection node is merged into the Group By Hash for CUBE. |
| Solutions | Modified so that Projection is not merged into the Group By Hash for CUBE. |
| Occurrence Date | 26.05.29. |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_700999a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fix for incorrect results when Projection is merged into Group By (Hash) for CUBE |
| Available for Deployment Date | 26.06.12. |
| Compatibility | • TAC rolling patch: Yes • TSC rolling patch: Yes • Backup data compatibility: Yes • Protocol compatibility: Yes • Data format compatibility: Yes |
| AP Impact | • Plan change: Yes • Result value change: Yes • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameters | - |
| Workaround | - |