Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6923

REGEXP_REPLACE_PG_...: backward references behave differently than in postgres

    XMLWordPrintableJSON

Details

    Description

      REGEXP_REPLACE builtin function differs from Postgres/BigQuery

      The builtin function is using $1 for backward reference. Postgres and BigQuery are using \1.

      SELECT REGEXP_REPLACE('abc','([bc]+)','$1','g')

      produces abc. Running the same query against Postgres or BigQuery will return a$1.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-6921 REGEXP_REPLACE with empty string causes Exception

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. CALCITE-5858 Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery library)

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #4292

          Activity

            People

              kramerul Ulrich Kramer
              kramerul Ulrich Kramer
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: