Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2.3, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Description
MariaDB [test]> SET sql_mode='NO_ZERO_DATE';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> DROP TABLE IF EXISTS t1;
|
Query OK, 0 rows affected (0.02 sec)
|
|
MariaDB [test]> CREATE TABLE t1 (c1 DATE NOT NULL) ENGINE=CSV;
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> INSERT IGNORE INTO t1 VALUES();
|
Query OK, 1 row affected, 1 warning (0.01 sec)
|
|
MariaDB [test]> SHOW WARNINGS;
|
+---------+------+-----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+-----------------------------------------+
|
| Warning | 1364 | Field 'c1' doesn't have a default value |
|
+---------+------+-----------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> SELECT * FROM t1;
|
ERROR 1194 (HY000): Table 't1' is marked as crashed and should be repaired
|
Attachments
Issue Links
- relates to
-
MDEV-26581 Table 't' is marked as crashed and should be repaired on UPDATE and sql_mode changes
-
- Confirmed
-
-
MDEV-7635 update defaults and simplify mysqld config parameters
-
- Closed
-
- links to
Activity
Fix Version/s | 10.2 [ 14601 ] | |
Affects Version/s | 5.5 [ 15800 ] | |
Affects Version/s | 10.0 [ 16000 ] | |
Affects Version/s | 10.1 [ 16100 ] | |
Affects Version/s | 10.2 [ 14601 ] | |
Labels | upstream |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Labels | upstream | 10.2-ga upstream |
Assignee | Alexander Barkov [ bar ] |
Labels | 10.2-ga upstream | upstream |
Affects Version/s | 10.3 [ 22126 ] | |
Affects Version/s | 10.4 [ 22408 ] | |
Affects Version/s | 10.5 [ 23123 ] | |
Affects Version/s | 10.6 [ 24028 ] | |
Affects Version/s | 10.7 [ 24805 ] |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] |
Labels | upstream | corruption upstream |
Assignee | Alexander Barkov [ bar ] | Oleksandr Byelkin [ sanja ] |
Remote Link | This issue links to "MySQL Bug 104627 (Web Link)" [ 31584 ] |
Link | This issue relates to MDEV-26581 [ MDEV-26581 ] |
Workflow | MariaDB v3 [ 79031 ] | MariaDB v4 [ 143918 ] |
Fix Version/s | 10.2 [ 14601 ] |
Fix Version/s | 10.7 [ 24805 ] | |
Fix Version/s | 10.8 [ 26121 ] | |
Fix Version/s | 10.9 [ 26905 ] | |
Fix Version/s | 10.10 [ 27530 ] |
Fix Version/s | 10.7 [ 24805 ] |
Fix Version/s | 10.3 [ 22126 ] |
Fix Version/s | 10.8 [ 26121 ] |
Labels | corruption upstream | corruption crash upstream |
Fix Version/s | 10.9 [ 26905 ] | |
Fix Version/s | 10.10 [ 27530 ] |
Fix Version/s | 10.4 [ 22408 ] |