expect_column_values_to_match_regex -> trino error #7656

[JustinGuese]

Describe the bug

TrinoUserError(type=USER_ERROR, name=FUNCTION_NOT_FOUND, message="line 9:39: Unexpected parameters (decimal(4,0), varchar(6)) for function regexp_like. Expected: regexp_like(varchar(x), joniregexp)", query_id=xxxx)

Sql query generated by that function:

WHERE true) AS great_expectations_sub_selection 
WHERE mandant IS NOT NULL AND NOT regexp_like(mandant, ?)
LIMIT ?
[parameters: ('^\\d{4}$', 20)]

Regular expression:

regex = "^\d{4}"
validator.expect_column_values_to_match_regex(column = columnname, regex = regex)

To Reproduce
Steps to reproduce the behavior:

1. Use Trino backend ->Trino Version 380-e.3

regex = "^\d{4}"
validator.expect_column_values_to_match_regex(column = columnname, regex = regex)

Expected behavior
A clear and concise description of what you expected to happen.

Environment (please complete the following information):

• Operating System: Linux
• Great Expectations Version: 0.15.50

Additional context

Exception has occurred: MetricResolutionError
(trino.exceptions.TrinoUserError) TrinoUserError(type=USER_ERROR, name=FUNCTION_NOT_FOUND, message="line 9:39: Unexpected parameters (decimal(4,0), varchar(6)) for function regexp_like. Expected: regexp_like(varchar(x), joniregexp)", query_id=xxxxx)
[SQL: SELECT mandant AS unexpected_values 
FROM (SELECT * 
FROM hiveexample.kunde 
WHERE true) AS great_expectations_sub_selection 
WHERE mandant IS NOT NULL AND NOT regexp_like(mandant, ?)
LIMIT ?]
[parameters: ('^\\d{4}', 20)]
(Background on this error at: https://sqlalche.me/e/14/f405)
trino.exceptions.TrinoUserError: TrinoUserError(type=USER_ERROR, name=FUNCTION_NOT_FOUND, message="line 9:39: Unexpected parameters (decimal(4,0), varchar(6)) for function regexp_like. Expected: regexp_like(varchar(x), joniregexp)", query_id=xxxxx)

The above exception was the direct cause of the following exception:

  File "<string>", line 2, in execute
sqlalchemy.exc.ProgrammingError: (trino.exceptions.TrinoUserError) TrinoUserError(type=USER_ERROR, name=FUNCTION_NOT_FOUND, message="line 9:39: Unexpected parameters (decimal(4,0), varchar(6)) for function regexp_like. Expected: regexp_like(varchar(x), joniregexp)", query_id=xxxxx)
[SQL: SELECT mandant AS unexpected_values 
FROM (SELECT * 
FROM hiveexample.kunde 
WHERE true) AS great_expectations_sub_selection 
WHERE mandant IS NOT NULL AND NOT regexp_like(mandant, ?)
LIMIT ?]
[parameters: ('^\\d{4}', 20)]
(Background on this error at: https://sqlalche.me/e/14/f405)

The above exception was the direct cause of the following exception:

  File "/hoipt.py", line 88, in standardTests
    validator.expect_column_values_to_match_regex(column = columnname, regex = regex)
  File "/hpy", line 191, in handleDataProductUpdate
    validator = standardTests(validator, validation.columnname, validation.mandatoryGlossarRef)
  File "/hocript.py", line 280, in <module>
    handleDataProductUpdate(tablename, data["allColumns"], data["customValidations"])
great_expectations.exceptions.exceptions.MetricResolutionError: (trino.exceptions.TrinoUserError) TrinoUserError(type=USER_ERROR, name=FUNCTION_NOT_FOUND, message="line 9:39: Unexpected parameters (decimal(4,0), varchar(6)) for function regexp_like. Expected: regexp_like(varchar(x), joniregexp)", query_id=xxxx)
[SQL: SELECT mandant AS unexpected_values 
FROM (SELECT * 
FROM hiveexample.kunde 
WHERE true) AS great_expectations_sub_selection 
WHERE mandant IS NOT NULL AND NOT regexp_like(mandant, ?)
LIMIT ?]
[parameters: ('^\\d{4}', 20)]
(Background on this error at: https://sqlalche.me/e/14/f405)