mariadb-dump --complete-insert emits INSERT statements for tables with only generated columns

CREATE TABLE allgen(a INT AS (1) VIRTUAL, b INT AS (2) STORED) ENGINE=InnoDB;

INSERT INTO allgen () VALUES ();

INSERT INTO allgen () VALUES ();

INSERT INTO allgen () VALUES ();

13.1.0-opt>CREATE TABLE allgen(a INT AS (1) VIRTUAL, b INT AS (2) STORED) ENGINE=InnoDB;

Query OK, 0 rows affected (0.040 sec)

13.1.0-opt>INSERT INTO allgen () VALUES ();

Query OK, 1 row affected (0.001 sec)

13.1.0-opt>INSERT INTO allgen () VALUES ();

Query OK, 1 row affected (0.001 sec)

13.1.0-opt>INSERT INTO allgen () VALUES ();

Query OK, 1 row affected (0.001 sec)

13.1.0-opt>

13.1.0-opt>SELECT * FROM allgen;

+------+------+

| a    | b    |

+------+------+

|    1 |    2 |

|    1 |    2 |

|    1 |    2 |

+------+------+

3 rows in set (0.000 sec)

13.1.0-opt>

13.1.0-opt>\q

Bye

ramesh_sivaraman@ramesh-01:/test/mtest/MDEV-32362/MD290626-mariadb-13.1.0-linux-x86_64-opt$ ./bin/mariadb-dump test -uroot -S/test/mtest/MDEV-32362/MD290626-mariadb-13.1.0-linux-x86_64-opt/socket.sock --complete-insert

/*M!999999\- enable the sandbox mode */

-- MariaDB dump 10.19-13.1.0-MariaDB, for Linux (x86_64)

--

-- Host: localhost    Database: test

-- ------------------------------------------------------

-- Server version	13.1.0-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;

/*!40103 SET TIME_ZONE='+00:00' */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;

--

-- Table structure for table `allgen`

--

DROP TABLE IF EXISTS `allgen`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8mb4 */;

CREATE TABLE `allgen` (

  `a` int(11) GENERATED ALWAYS AS (1) VIRTUAL,

  `b` int(11) GENERATED ALWAYS AS (2) STORED

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

-- Dump completed on 2026-06-29 12:44:26