Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25277

mysqlbinlog --verbose cannot read row events with compressed columns: Don't know how to handle column type: 140

Details

    Description

      --source include/have_binlog_format_row.inc
      		 
       
      		 
      CREATE TABLE t1 (a TEXT COMPRESSED);
      		 
      INSERT INTO t1 VALUES ('foo'),('bar');
      		 
      FLUSH BINARY LOGS;
      		 
      --let $binlog= query_get_value(SHOW BINARY LOGS, Log_name, 1)
      		 
      --let $datadir= `SELECT @@datadir`
      		 
       
      		 
      --echo # Running mysqlbinlog --verbose <binlog>
      		 
      --exec $MYSQL_BINLOG --verbose $datadir/$binlog
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t1;

      10.3 480a0671

      		 
      # Running mysqlbinlog --verbose <binlog>
      		 
      bug.t                                    [ fail ]
      		 
              Test ended at 2021-03-27 17:51:42
      		 
       
      		 
      CURRENT_TEST: bug.t
      		 
       
      		 
      Error: Don't know how to handle column type: 140 meta: 2 (0002)
      		 
      mysqltest: At line 10: exec of ...

      Not applicable to 10.2 as compressed columns were introduced in 10.3.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Description {code:sql}
          --source include/have_binlog_format_row.inc

          CREATE TABLE t1 (a TEXT COMPRESSED);
          INSERT INTO t1 VALUES ('foo'),('bar');
          FLUSH BINARY LOGS;
          --let $binlog= query_get_value(SHOW BINARY LOGS, Log_name, 1)
          --let $datadir= `SELECT @@datadir`

          --echo # Running mysqlbinlog --verbose <binlog>
          --exec $MYSQL_BINLOG --verbose $datadir/$binlog

          # Cleanup
          DROP TABLE t1;
          {code}

          {code:sql|title=10.3 480a0671}
          # Running mysqlbinlog --verbose <binlog>
          bug.t [ fail ]
                  Test ended at 2021-03-27 17:51:42

          CURRENT_TEST: bug.t

          Error: Don't know how to handle column type: 140 meta: 2 (0002)
          mysqltest: At line 10: exec of ...
          {code}
          		{code:sql}
          --source include/have_binlog_format_row.inc

          CREATE TABLE t1 (a TEXT COMPRESSED);
          INSERT INTO t1 VALUES ('foo'),('bar');
          FLUSH BINARY LOGS;
          --let $binlog= query_get_value(SHOW BINARY LOGS, Log_name, 1)
          --let $datadir= `SELECT @@datadir`

          --echo # Running mysqlbinlog --verbose <binlog>
          --exec $MYSQL_BINLOG --verbose $datadir/$binlog

          # Cleanup
          DROP TABLE t1;
          {code}

          {code:sql|title=10.3 480a0671}
          # Running mysqlbinlog --verbose <binlog>
          bug.t [ fail ]
                  Test ended at 2021-03-27 17:51:42

          CURRENT_TEST: bug.t

          Error: Don't know how to handle column type: 140 meta: 2 (0002)
          mysqltest: At line 10: exec of ...
          {code}

          Not applicable to 10.2 as compressed columns were introduced in 10.3.
          Elkin Andrei Elkin made changes -
          Assignee Andrei Elkin [ elkin ] Brandon Nesterenko [ JIRAUSER48702 ]
          bnestere Brandon Nesterenko made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          bnestere Brandon Nesterenko made changes -
          Fix Version/s 10.6 [ 24028 ]
          bnestere Brandon Nesterenko made changes -
          Assignee Brandon Nesterenko [ JIRAUSER48702 ] Andrei Elkin [ elkin ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 120545 ] MariaDB v4 [ 143786 ]
          kzinas Domantas Speciunas made changes -
          Comment [ Is this progressing? ]
          Elkin Andrei Elkin made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          Elkin Andrei Elkin made changes -
          Assignee Andrei Elkin [ elkin ] Brandon Nesterenko [ JIRAUSER48702 ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          bnestere Brandon Nesterenko made changes -
          issue.field.resolutiondate 2023-01-11 20:58:24.0 2023-01-11 20:58:24.514
          bnestere Brandon Nesterenko made changes -
          Fix Version/s 10.3.38 [ 28507 ]
          Fix Version/s 10.4.28 [ 28509 ]
          Fix Version/s 10.5.19 [ 28511 ]
          Fix Version/s 10.6.12 [ 28513 ]
          Fix Version/s 10.7.8 [ 28515 ]
          Fix Version/s 10.8.7 [ 28517 ]
          Fix Version/s 10.9.5 [ 28519 ]
          Fix Version/s 10.10.3 [ 28521 ]
          Fix Version/s 10.11.2 [ 28523 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 172234

          People

            bnestere Brandon Nesterenko
            elenst Elena Stepanova
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.