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
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.0 [ 16000 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Labels | upstream |
| Assignee | Marko Mäkelä [ marko ] |
| Component/s | Admin statements [ 11400 ] | |
| Component/s | Storage Engine - Aria [ 10126 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.6 [ 24028 ] | |
| Assignee | Marko Mäkelä [ marko ] | Oleksandr Byelkin [ sanja ] |
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Fix Version/s | 10.6 [ 24028 ] |
| Fix Version/s | 10.1 [ 16100 ] |
| Workflow | MariaDB v3 [ 77804 ] | MariaDB v4 [ 143906 ] |
| Fix Version/s | 10.2 [ 14601 ] |
| Fix Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.4 [ 22408 ] |