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

              • Assignee:
                marko Marko Mäkelä
                Reporter:
                nirbhay_c Nirbhay Choubey (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: