Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.18, 10.0(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
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
- relates to
-
MDEV-7635 update defaults and simplify mysqld config parameters
-
- Closed
-