Why does SPLIT_PART function in TIBCO Data Virtualization not return a null when there is no match ?
Article ID: KB0071034
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | TIBCO Data Virtualization 8.4.1 and above |
Description
The new behavior of the SPLIT_PART function in TDV is as follows:
An empty string is returned if the position does not have any valid string. This behavior is consistent with the behavior of the SPLIT_PART function in Postgres and MySQL.
Example:
To illustrate the change in behavior, consider the following examples:
In versions 8.3 and below:
Calling SPLIT_PART('1234Acme_parts', ',', 2) => return NULL.
In versions 8.4.1 and above:
Calling SPLIT_PART('1234Acme_parts', ',', 2) => return an empty string.
This change aligns the SPLIT_PART function in TDV with the behavior of similar functions in popular database systems like Postgres and MySQL.
Environment
All supported environments
Resolution
The change in the behavior of the SPLIT_PART function is a conscious design enhancement made to mimic the Postgres and MySQL behavior for the same function.
Issue/Introduction
This article provides details of a design change in the behavior of the SPLIT_PART function on TDV 8.4 and later versions
Feedback
Yes
No
Powered by
