1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/get_diagnostics.test b/mysql-test/main/get_diagnostics.test
index e8d81dca1e6..3dbe72ec55c 100644
--- a/mysql-test/main/get_diagnostics.test
+++ b/mysql-test/main/get_diagnostics.test
@@ -1687,3 +1687,19 @@ GET DIAGNOSTICS CONDITION 3 @n = ROW_NUMBER;
 SELECT @n;
 
 DROP TABLE t;
+
+-- echo #
+-- echo # MDEV-26698: Incorrect row number upon INSERT .. SELECT from the same
+-- echo # table: rows are counted twice
+-- echo #
+
+CREATE OR REPLACE TABLE t (a TINYINT);
+INSERT INTO t VALUES (1),(100);
+
+INSERT INTO t SELECT a*2 FROM t;
+GET DIAGNOSTICS CONDITION 1 @err1 = ROW_NUMBER;
+SELECT @err1;
+GET DIAGNOSTICS CONDITION 2 @err2 = ROW_NUMBER;
+SELECT @err2;
+
+DROP TABLE t;