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

Different checksum values

    XMLWordPrintable

Details

    Description

      The following set of commands lead to two different checksums:

      MariaDB [test]> drop table if exists t1, t2;
      Query OK, 0 rows affected, 2 warnings (0.01 sec)
       
      MariaDB [test]> create table t1(c varchar(100)) engine=innodb row_format=fixed; # "fixed" not a valid innodb row_format
      Query OK, 0 rows affected, 1 warning (0.04 sec)
       
      MariaDB [test]> show warnings;
      +---------+------+--------------------------------------+
      | Level   | Code | Message                              |
      +---------+------+--------------------------------------+
      | Warning | 1478 | InnoDB: assuming ROW_FORMAT=COMPACT. |
      +---------+------+--------------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> create table t2(c varchar(100)) engine=innodb row_format=compact;
      Query OK, 0 rows affected (0.05 sec)
       
      MariaDB [test]> insert into t1 values("hello");
      Query OK, 1 row affected (0.00 sec)
       
      MariaDB [test]> insert into t2 select * from t1;
      Query OK, 1 row affected (0.01 sec)
      Records: 1  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> select t1.c = t2.c from t1, t2;
      +-------------+
      | t1.c = t2.c |
      +-------------+
      |           1 |
      +-------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> checksum table t1;
      +---------+------------+
      | Table   | Checksum   |
      +---------+------------+
      | test.t1 | 3908893439 |
      +---------+------------+
      1 row in set (0.01 sec)
       
      MariaDB [test]> checksum table t2;
      +---------+------------+
      | Table   | Checksum   |
      +---------+------------+
      | test.t2 | 1852344401 |
      +---------+------------+
      1 row in set (0.00 sec)
      

      While the following works ok.

      MariaDB [test]> drop table if exists t1, t2;
      Query OK, 0 rows affected (0.08 sec)
       
      MariaDB [test]> create table t1(c varchar(100)) engine=innodb row_format=compact;
      Query OK, 0 rows affected (0.04 sec)
       
      MariaDB [test]> create table t2(c varchar(100)) engine=innodb row_format=compact;
      Query OK, 0 rows affected (0.02 sec)
       
      MariaDB [test]> insert into t1 values("hello");
      Query OK, 1 row affected (0.01 sec)
       
      MariaDB [test]> insert into t2 select * from t1;
      Query OK, 1 row affected (0.01 sec)
      Records: 1  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> select t1.c = t2.c from t1, t2;
      +-------------+
      | t1.c = t2.c |
      +-------------+
      |           1 |
      +-------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> checksum table t1;
      +---------+------------+
      | Table   | Checksum   |
      +---------+------------+
      | test.t1 | 1852344401 |
      +---------+------------+
      1 row in set (0.00 sec)
       
      MariaDB [test]> checksum table t2;
      +---------+------------+
      | Table   | Checksum   |
      +---------+------------+
      | test.t2 | 1852344401 |
      +---------+------------+
      1 row in set (0.00 sec)
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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