Daniel Black added a comment - 2023-12-17 21:30 Cannot reproduce on latest 10.5 release: MariaDB [testdb]> CREATE TABLE `denodo_camp_promo_view` ( `ID` decimal(15,0) DEFAULT NULL, `name` varchar(80) DEFAULT NULL, `startdate` date DEFAULT NULL, `enddate` date DEFAULT NULL, `ownerid` varchar(18) DEFAULT NULL, `promotion_code__c` varchar(255) DEFAULT NULL, `PROMOCODE_DETAILS` varchar(321) DEFAULT NULL ); Query OK, 0 rows affected (0.018 sec)   MariaDB [testdb]> INSERT INTO denodo_camp_promo_view (ID, name, startdate, enddate, ownerid, promotion_code__c, PROMOCODE_DETAILS) SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),NULL,NULL,NULL,NULL,NULL,'NA'; Query OK, 1 row affected (0.003 sec) Records: 1 Duplicates: 0 Warnings: 0   MariaDB [testdb]> \s -------------- mariadb Ver 15.1 Distrib 10.5.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2   Connection id: 28000 Current database: testdb Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.5.23-MariaDB-1:10.5.23+maria~ubu2004 mariadb.org binary distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /run/mysqld/mysqld.sock Uptime: 4 days 14 hours 34 min 33 sec   Threads: 22 Questions: 56142 Slow queries: 0 Opens: 27 Open tables: 20 Queries per second avg: 0.141 --------------   MariaDB [testdb]> select version(); +-----------------------------------------+ | version() | +-----------------------------------------+ | 10.5.23-MariaDB-1:10.5.23+maria~ubu2004 | +-----------------------------------------+ 1 row in set (0.001 sec)

Daniel Black added a comment - 2023-12-17 21:32 is fixed somewhere between 10.5.9 and 10.5.23.

R S N Murthy added a comment - 2023-12-18 04:51 Thank you for providing the fix, Please help with version upgrade steps for a Master Slave environment. we have used mariadb-10.5.9-linux-x86_64.tar.gz tar ball extract in present setup.

Daniel Black added a comment - 2023-12-18 05:29 JIRA is for bug reports and not support sorry. See https://mariadb.com/kb/en/getting-help-with-mariadb/ if below isn't sufficient. Basics steps are there as 10.5.23 tarball here . It needs to replace your existing instance. Keep in mind your data dir is within your current mariadb installation. Update Slave first and then master. Ensure current instance is stopped before new instance is started. Run mariadb-upgrade afterwards on both master and slave. Keep a backup.

R S N Murthy added a comment - 2023-12-18 06:12 That certainly helps. Thank you very much