Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5709

The DDL_FILTER of SchemaHistory doesn't work for including break lines ddl statement

XMLWordPrintable

    • False
    • None
    • False

      We met following ddl parser failed last night, and want to set this property `"internal.schema.history.internal.ddl.filter": "CREATE.VIEW."` to skip this ddl and recovery the connector in time. Unfortunatly, it didn't work becasue there are some break lines in create view statement.

      DDL_FILTER:

      CREATE.*VIEW.*
      

      Create view statement:

      create algorithm=undefined definer=`bi_rw`@`172.29.%` sql security definer view 
      v_some_table as (
      with a as (select * from some_table) 
      select * from a
      );
      

              Unassigned Unassigned
              ywyuewei Harvey Yue (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: