Issue Information
| Issue Number | 700922a |
| Issue | When the IN clause contains constants of different types, duplicate results are returned. |
| Cause | When the types of the constants differ, the Compiler cannot remove duplicates, so duplicate removal is required at runtime. |
| Solutions | Configure the system to remove duplicates at runtime when the IN clause contains constants of different types. |
| Occurrence Date | 26.05.06. |
| Version Requiring the Patch | 7FS02PS |
Patch Information
| Patch Name | FS02PS_700922a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fixing the dup_check Flag Setting Error in inlist |
| Available for Deployment | 26.05.29. |
| Compatibility | • TAC rolling patch: Yes • TSC rolling patch: Yes • Backup data compatibility: Yes • Protocol compatibility: Yes • Data format compatibility: Yes |
| AP Impact | • Plan change: No • Result value change: Yes • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameters | - |
| Workaround | - |