search

pingcap / tidb-binlog

A tool used to collect and merge tidb's binlog for real-time data backup and synchronization.
Apache License 2.0
292 stars 131 forks source link

drainer: rtrim char type column in sql #1164

Open cartersz opened 2 years ago

cartersz commented 2 years ago

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do? oracle will pad column of char type, if the value length less than the length defined , we need to rtrim the column in where clause in sql.

  2. What did you expect to see? when table defined the char type column, rtrim function will be used in sql

  3. What did you see instead? it do not rtrim the char type column.

  4. Please provide the relate downstream type and version of drainer. (run drainer -V in terminal to get drainer's version)

niubell commented 2 years ago

/label affects-6.1

ti-chi-bot commented 2 years ago

@niubell: The label(s) affects-6.1 cannot be applied. These labels are supported: contribution, duplicate, feature-request, first-time-contributor, invalid, need-update-ansible, need-update-docs, needs-cherry-pick-release-2.1, needs-cherry-pick-release-3.0, needs-cherry-pick-release-3.1, needs-cherry-pick-release-4.0, needs-cherry-pick-release-5.0, needs-cherry-pick-release-5.1, needs-cherry-pick-release-5.2, needs-cherry-pick-release-5.3, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.0, needs-cherry-pick-release-6.1, p0, p1, p2, question, wontfix.

In response to [this](https://github.com/pingcap/tidb-binlog/issues/1164#issuecomment-1138717253): >/label affects-6.1 Instructions for interacting with me using PR comments are available [here](https://prow.tidb.io/command-help). If you have questions or suggestions related to my behavior, please file an issue against the [ti-community-infra/tichi](https://github.com/ti-community-infra/tichi/issues/new?title=Prow%20issue:) repository.
niubell commented 2 years ago

/label needs-cherry-pick-release-6.1

ti-chi-bot commented 2 years ago

@niubell: The label(s) needs-cherry-pick-release-6.1 cannot be applied, because the repository doesn't have them.

In response to [this](https://github.com/pingcap/tidb-binlog/issues/1164#issuecomment-1139196665): >/label needs-cherry-pick-release-6.1 Instructions for interacting with me using PR comments are available [here](https://prow.tidb.io/command-help). If you have questions or suggestions related to my behavior, please file an issue against the [ti-community-infra/tichi](https://github.com/ti-community-infra/tichi/issues/new?title=Prow%20issue:) repository.