Issue Number : 700652a
| Issue | When a query using OR conditions includes the CONTAINS function and the upper-level node does not use the column of that table, an error occurs in the result values. |
| Cause | When applying certain logical expansion features using the CONTAINS function, Tibero processes the condition as a set. However, if a specific column is not referenced in the upper query, duplicate removal is not performed correctly. |
| Solutions | For OR Expansion using CONTAINS, the ROWID is now also passed to the upper node. |
| Major Version | 7 |
| Minor Version | FS02PS |
| Deployment Date | 06.26.26 |
| Compatibility Information | No incompatible items โข TAC rolling patch: Available โข TSC rolling patch: Available โข Backup data compatibility: Available โข Protocol compatibility: Available โข Data format compatibility: Available |
| AP Impact | โข Plan change: Yes โข Result value change: Yes โข SQL syntax change: No โข System object change: No โข Existing feature change: No |
| Main Module | optimizer |
| Parameter | - |
| Related Patch | - |