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