[FEA] better rlike function supported

[nvliyuan]

I wish we can support end of line/string anchor in rlike function:

from pyspark.sql.functions import col
data = [("1", "123"), 
        ("2", "456"),
        ("3", "789"),
        ("4", "abc")]
df = spark.createDataFrame(data=data, schema=["id", "value"])
result = df.filter(col("value").rlike("^[0-9]*$"))
result.show()

[NVnavkumar]

See related issue #5659. It looks like this is case that is caught up in one of the false positive use cases described there.

Unit test directly referenced there: #5659 (comment)

[nvliyuan]

See related issue #5659. It looks like this is case that is caught up in one of the false positive use cases described there.

Unit test directly referenced there: #5659 (comment)

Thanks for reminding, close this issue since duplicate with #5659