[Bug] split_part function split String bug

[lit2430]

Search before asking

• I had searched in the issues and found no similar issues.

Version

doris 0.15 - 1.2

What's Wrong?

If the string does not contain a delimiter, null is returned

What You Expected?

If the string does not contain a delimiter, should the original data be returned instead of null

How to Reproduce?

SELECT split_part ("23456/123", '/', 1 )

SELECT split_part ("23456", '/', 1 )

Anything Else?

no

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[Yulei-Yang]

this is not a bug, this is what it is designed. postgre sql has this function too, for this case it returns an empty string, not the whole string either.