My current MariaDB version is MariaDB Community Server 10.8.4 and operating system Windows Server 2019 X64-based A business table was created and an error was reported when using the following SQL INSERT INTO meeting (fielDID,fieldorder) SELECT MAX(fielDID)+1 AS fielDID, MAX(fieldorder)+1 AS fieldorder FROM meeting ERROR 1048 (23000): Column 'FIELDID' cannot be null First What parameters are not modified after the database is installed mariadb 10.8.4 Related database and table results, and the operation procedure are as follows: MariaDB [wang]> show create database wang; +----------+---------------------------------------------------------------------+ | Database | Create Database | +----------+---------------------------------------------------------------------+ | wang | CREATE DATABASE `wang` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ | +----------+---------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [wang]> MariaDB [wang]> show create table meeting; +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | meeting | CREATE TABLE `meeting` ( `FIELDID` int(11) NOT NULL, `FIELDORDER` int(11) DEFAULT NULL, PRIMARY KEY (`FIELDID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 | +---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [wang]> MariaDB [wang]> select * from meeting; +---------+------------+ | FIELDID | FIELDORDER | +---------+------------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | +---------+------------+ 4 rows in set (0.000 sec) MariaDB [wang]> INSERT INTO meeting (fieldid,fieldorder) -> SELECT -> MAX(fieldid)+1 AS fieldid, -> MAX(fieldorder)+1 AS fieldorder -> FROM meeting -> ; ERROR 1048 (23000): Column 'FIELDID' cannot be null MariaDB [wang]> Second Mariadb version 10.8.4 on Linux has the same problem,Other versions of Mariadb are not validated on Linux: MariaDB [wang]> \s -------------- ./bin/mysql Ver 15.1 Distrib 10.8.4-MariaDB, for linux-systemd (x86_64) using readline 5.1 Connection id: 3 Current database: wang Current user: root@ SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.8.4-MariaDB MariaDB Server Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: utf8mb3 Conn. characterset: utf8mb3 TCP port: 33060 Uptime: 9 min 50 sec Threads: 1 Questions: 71 Slow queries: 0 Opens: 18 Open tables: 13 Queries per second avg: 0.120 -------------- MariaDB [wang]> MariaDB [wang]> \! more /etc/redhat-release CentOS Linux release 7.9.2009 (Core) MariaDB [wang]> \! uname -a Linux localhost.localdomain 3.10.0-1160.el7.x86_64 #1 SMP Mon Oct 19 16:18:59 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux MariaDB [wang]> CREATE TABLE `meeting` ( -> `FIELDID` int(11) NOT NULL, -> `FIELDORDER` int(11) DEFAULT NULL, -> PRIMARY KEY (`FIELDID`) -> ) ENGINE=InnoDB ; Query OK, 0 rows affected (0.002 sec) MariaDB [wang]> insert into meeting values(1,1),(2,1),(3,1),(4,1); Query OK, 4 rows affected (0.001 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [wang]> commit; Query OK, 0 rows affected (0.000 sec) MariaDB [wang]> select * from meeting; +---------+------------+ | FIELDID | FIELDORDER | +---------+------------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | +---------+------------+ 4 rows in set (0.000 sec) MariaDB [wang]> MariaDB [wang]> INSERT INTO meeting (fieldid,fieldorder) SELECT MAX(fieldid)+1 AS fieldid, MAX(fieldorder)+1 AS fieldorder FROM meeting ; ERROR 1048 (23000): Column 'FIELDID' cannot be null MariaDB [wang]> MariaDB [wang]> Three At the same time, other MariaDB versions 10.9.2, 10.7.5, 10.6.9 on Windows Server 2019 X64 operating system have this problem, but 10.4.26 version can insert successfully. The procedure for MariaDB 10.4.26 is as follows: C:\Windows\system32>mysql -uroot -p Enter password: **** Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.4.26-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> \s -------------- mysql Ver 15.1 Distrib 10.4.26-MariaDB, for Win64 (AMD64), source revision 65e8506ca9d03967191b6ed207cf107d311f7f99 Connection id: 8 Current database: wang Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.4.26-MariaDB mariadb.org binary distribution Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: gbk Conn. characterset: gbk TCP port: 3306 Uptime: 2 min 21 sec Threads: 6 Questions: 13 Slow queries: 0 Opens: 22 Flush tables: 1 Open tables: 15 Queries per second avg: 0.092 -------------- MariaDB [(none)]> create database wang; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> use wang; Database changed MariaDB [wang]> CREATE TABLE `meeting` ( -> `FIELDID` int(11) NOT NULL, -> `FIELDORDER` int(11) DEFAULT NULL, -> PRIMARY KEY (`FIELDID`) -> ) ENGINE=InnoDB; Query OK, 0 rows affected (0.008 sec) MariaDB [wang]> MariaDB [wang]> insert into meeting values(1,1),(2,1),(3,1),(4,1); Query OK, 4 rows affected (0.004 sec) Records: 4 Duplicates: 0 Warnings: 0 MariaDB [wang]> commit; Query OK, 0 rows affected (0.000 sec) MariaDB [wang]> select * from meeting; +---------+------------+ | FIELDID | FIELDORDER | +---------+------------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | +---------+------------+ 4 rows in set (0.001 sec) MariaDB [wang]> INSERT INTO meeting (fieldid,fieldorder) SELECT MAX(fieldid)+1 AS fieldid, MAX(fieldorder)+1 AS fieldorder FROM meeting ; Query OK, 1 row affected (0.003 sec) Records: 1 Duplicates: 0 Warnings: 0 MariaDB [wang]> select * from meeting; +---------+------------+ | FIELDID | FIELDORDER | +---------+------------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | | 5 | 2 | +---------+------------+ 5 rows in set (0.000 sec) MariaDB [wang]>