Refactor regexplife signature

[jiashenC]

Which issue does this PR close?

Close some tasks in #13301.

What changes are included in this PR?

Simplify function signature.

Are these changes tested?

Added more tests for implicit casting.

Are there any user-facing changes?

No

[jiashenC]

@jayzhan211, I made some progress first for the RegExpLike function. In the original issue, you mentioned the signature can be replaced with Signature::string(2, Volatility::Immutable), but I do see this function can also accept 3 arguments. And this will fail tests like dataframe::dataframe_functions::test_fn_regexp_like. I wonder if I misunderstood something here?

[jayzhan211]

@jayzhan211, I made some progress first for the RegExpLike function. In the original issue, you mentioned the signature can be replaced with Signature::string(2, Volatility::Immutable), but I do see this function can also accept 3 arguments. And this will fail tests like dataframe::dataframe_functions::test_fn_regexp_like. I wonder if I misunderstood something here?

You can use one_of

signature: Signature::one_of(
                vec![
                    TypeSignature::String(2),
                    TypeSignature::String(3)
                ],
                Volatility::Immutable,
            ),

[jiashenC]

@jayzhan211 thanks for the reply! I mark this as ready for review.

[jayzhan211]

@jayzhan211 thanks for the reply! I mark this as ready for review.

You can run cargo test --test sqllogictests and ./dev/rust_lint.sh to cleanup CI