Issue Information
| Issue Number | 701686a |
| Issue | When DBMS_METADATA.GET_DDL('INDEX') is executed, the result is not returned and execution continues indefinitely. |
| Cause | When GET_DDL is executed, the process of finding an internally generated virtual column does not terminate if the column does not exist. This occurs because FBIs created in an earlier version, and FBIs on IOTs or object tables, do not include the column. |
| Solutions | Internal virtual columns are excluded from the search, and if the column cannot be found, the iterative processing is stopped and the FBI expression is output as is. |
| Occurrence Date | 26.10.23. |
| Version Requiring the Patch | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701686a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fix infinite loop in GET_DDL for FBI on IOT tables |
| Available for Deployment | 26.11.04. |
| 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: No • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameters | - |
| Workaround | - |