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)

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)