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

MySQL database using the compress function, can provide analytic function

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Unresolved
    • Icon: Critical Critical
    • Backlog
    • 2.4.2.Final
    • mysql-connector
    • None
    • False
    • None
    • False
    • 0
    • 0% 0%

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Bug report

      For bug reports, provide this information, please:

      MySQL database using the compress function, now use the base64 and udf are not parsed, the community did not see a solution, I hope to solve such problems

      What Debezium connector do you use and what version?

      <Your answer> 

      2.4.2.Final

      What is the connector configuration?

      <Your answer>mysql-connector,default configuration

      What is the captured database version and mode of depoyment?

      MySQL 5.7,master/slave

      What behaviour do you expect?

      <Your answer>Normal analysis

      What behaviour do you see?

      <Your answer>Unable to parse, only parse data without using the compress function

      Do you see the same behaviour using the latest relesead Debezium version?

      (Ideally, also verify with latest Alpha/Beta/CR version)

      <Your answer> 

      The latest version does not support MySQL 5.7

      Do you have the connector logs, ideally from start till finish?

      (You might be asked later to provide DEBUG/TRACE level log)

      <Your answer>No error logs, only data cannot be parsed

      How to reproduce the issue using our tutorial deployment?

      mysql:

      create tabel test 
      (`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
      str blob)ENGINE=InnoDB DEFAULT CHARSET=utf8,
      insert into test (str) values (compress ('aaaaaa'))

      Feature request or enhancement

      For feature requests or enhancements, provide this information, please:

      Normal parsing of data using the compress function

      Which use case/requirement will be addressed by the proposed feature?

      <Your answer>Can solve the collection problem of MySQL after using compress to insert data

      Implementation ideas (optional)

      <Your answer>

            Unassigned Unassigned
            zhb123456 huaibei zhang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: