Issue Information
| Issue Number | 700535a |
| Issue | When an OR predicate exists in both the main query and the inline view, and the same predicate is included in that OR predicate, a result value error occurred in which duplicate values were output if OR expansion occurred only for the OR predicate in the main query. ex. select * from (select * from t1 where c1 > 0 or c1 >= 1) where c1 > 0 or c1 = 2; |
| Cause | While OR expansion of the OR predicate in the main query was occurring, OR expansion of the OR predicate in the inline view also occurred. When restoring the predicate created with LNNVL after the inline view's OR expansion was complete, the LNNVL for the OR predicate in the main query was restored, causing the LNNVL to be omitted and resulting in a result value error. |
| Solutions | When restoring the predicate created with LNNVL after the inline view's OR expansion is complete, it was changed to restore the LNNVL required for OR expansion of the main query. |
| Occurrence Date | 26.02.06. |
| Version Requiring the Patch | 6FS07PS 7FS02PS |
Patch Information
| Patch Name | FS02PS_700535a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Resolving Result Value Errors Caused by Partial Application of OR Expansion When the Same Predicate Exists |
| Available for Deployment | 26.03.06. |
| Compatibility | • TAC rolling patch: Supported • TSC rolling patch: Supported • Backup data compatibility: Supported • Protocol compatibility: Supported • Data format compatibility: Supported |
| AP Impact | • Whether the plan changes: Yes • Whether the result value changes: Yes • Whether SQL syntax changes: No • Whether system objects change: No • Whether existing functionality changes: No |
| Parameters | - |
| Workaround | - |