[jira] [Created] (FLINK-40240) Support additional Flink SQL regular expression functions in YAML Transform

["Mao Jiayi (Jira)" <ji...@apache.org>]

Mao Jiayi created FLINK-40240:
---------------------------------

             Summary: Support additional Flink SQL regular expression functions in YAML Transform
                 Key: FLINK-40240
                 URL: https://issues.apache.org/jira/browse/FLINK-40240
             Project: Flink
          Issue Type: Improvement
          Components: Flink CDC
            Reporter: Mao Jiayi


Flink CDC YAML Transform currently supports REGEXP_REPLACE, but the other regular expression functions commonly available in Flink SQL are missing.

This limits the ability to extract, locate, and count pattern matches in row-level transform expressions. Users currently need to implement UDFs for these operations.

The missing functions include:

* REGEXP_EXTRACT
* REGEXP_EXTRACT_ALL
* REGEXP_COUNT
* REGEXP_INSTR
* REGEXP_SUBSTR

YAML Transform should support these functions with behavior aligned with Flink SQL, including Java regular expression syntax, capture group indexes, NULL arguments, invalid patterns, and unmatched input.

REGEXP_EXTRACT_ALL should return ARRAY<STRING> and work correctly in YAML Transform projections.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)