Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

canal.instance.filter.black.regex不生效 #4459

Closed
2 tasks done
qq592304796 opened this issue Oct 18, 2022 · 1 comment
Closed
2 tasks done

canal.instance.filter.black.regex不生效 #4459

qq592304796 opened this issue Oct 18, 2022 · 1 comment

Comments

@qq592304796
Copy link

qq592304796 commented Oct 18, 2022

  • I have searched the issues of this repository and believe that this is not a duplicate.
  • I have checked the FAQ of this repository and believe that this is not a duplicate.

environment

  • canal version
    1.1.5
  • mysql version
    polardb-8.0.1.1.28

Issue Description

https://help.aliyun.com/document_detail/212957.html?scm=20140722.S_help%40%40%E6%96%87%E6%A1%A3%40%40212957.S_0%2Bos.ID_212957-RL_access%E4%B8%AD%E8%A1%A8%E5%92%8C%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E5%85%B3%E7%B3%BB%E6%98%AF%20%20%20DOT-LOC_main-OR_ser-V_2-P0_1

DTS会在源库定时执CREATE DATABASE IF NOT EXISTS test命令以推进Binlog位点

canal.instance.filter.black.regex=mysql\.slave_.,.\.base table,test\..*

{"data":null,"database":"test","es":1666101967000,"id":273,"isDdl":true,"mysqlType":null,"old":null,"pkNames":null,"sql":"CREATE DATABASE IF NOT EXISTS test","sqlType":null,"table":"","ts":1666101967931,"type":"QUERY"}

过滤不生效

Steps to reproduce

Expected behaviour

Actual behaviour

If there is an exception, please attach the exception trace:

Just put your stack trace here!
@agapple
Copy link
Member

agapple commented Nov 16, 2022

create database默认不做filter,因为不符合 schema.tablename的过滤表达式,可以考虑提交一个PR给我

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants