Issue Number: 342504a
| Issue | An error in result values occurs because unnecessary repeated scans are removed even when they should not be. |
| Cause | Join Elimination optimization should not be performed when the SAMPLE function is used on the PK side or when a PARTITION clause is included, but the logic was improperly applied, causing the error. |
| Solutions | The related logic was modified to consider cases where the SAMPLE function and PARTITION clause are used. |
| Note | This can be avoided by using the no_join_elimination hint. |