Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.4.13, 10.3(EOL), 10.4(EOL)
-
Linux x86-64, kernel 5.4.x
Description
show create table transaction_registry \G |
Table: transaction_registry |
Create Table: CREATE TABLE `transaction_registry` ( |
`transaction_id` bigint(20) unsigned NOT NULL, |
`commit_id` bigint(20) unsigned NOT NULL, |
`begin_timestamp` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000', |
`commit_timestamp` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000', |
`isolation_level` enum('READ-UNCOMMITTED','READ-COMMITTED','REPEATABLE-READ','SERIALIZABLE') COLLATE utf8_bin NOT NULL, |
PRIMARY KEY (`transaction_id`), |
UNIQUE KEY `commit_id` (`commit_id`), |
KEY `begin_timestamp` (`begin_timestamp`), |
KEY `commit_timestamp` (`commit_timestamp`,`transaction_id`) |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0 |
1 row in set (0.000 sec) |
|
\s
|
--------------
|
mysql Ver 15.1 Distrib 10.4.13-MariaDB, for Linux (x86_64) using readline 8.0 |
|
Connection id: 2570 |
Current database: mysql |
Current user: root@localhost |
SSL: Not in use |
Current pager: /usr/bin/less |
Using outfile: '' |
Using delimiter: ;
|
Server: MariaDB
|
Server version: 10.4.13-MariaDB Source distribution
|
Protocol version: 10
|
Connection: Localhost via UNIX socket |
Server characterset: utf8mb4
|
Db characterset: utf8mb4
|
Client characterset: utf8mb4
|
Conn. characterset: utf8mb4
|
UNIX socket: /var/run/mysqld/mysqld.sock
|
Uptime: 12 hours 41 min 16 sec |
While the above seems normal, if you have NO_ZERO_DATE sql mode enabled, when you analyze the mysql database, it fails with a 'invalid default value for column ....' error and stops.
Attachments
Issue Links
- relates to
-
MDEV-16226 TRX_ID-based System Versioning refactoring
- Stalled
-
MDEV-20254 Problems with EMPTY_STRING_IS_NULL and I_S tables
- Closed