Feature Number: 701015b
| Overview | The restriction that SFC (Simple Filter Condition) was only applied when all conditions in the WHERE clause were SFC has been relaxed, and the supported types and node ranges have been expanded. This improvement allows partial application of SFC even in mixed queries. |
| Details | In queries involving constant comparisons that require type conversion in the condition clause, if the result is zero rows, it has been modified to return zero rows without causing a type conversion error. Additionally, performance has been improved for repeated queries including repeated execution of NL joins and queries with type conversion conditions. |
| Occurrence Timing | 26.07.10. |
| Patch Required Version | - |
Patch Information
| Patch Name | FS02PS_701015b |
| Major Version | 7 |
| Minor Version | FS02PS |
| Release Date | 26.07.14. |
| Version Title | Modified to Perform SFC Constant Evaluation After ROW FETCH |
| Base Applied Version | - |
| Compatibility Information | No incompatible items โข TAC rolling patch: Supported โข TSC rolling patch: Supported โข Backup data compatibility: Supported โข Protocol compatibility: Supported โข Data format compatibility: Supported |
| AP Impact | โข Plan change: No โข Result value change: Yes โข SQL syntax change: No โข System object change: No โข Existing function change: No |
| Parameters | - |
| Workaround | - |