Wrong results in intersect all in Oracle Mode under view

MariaDB [test]> create table t1 (a int, b int);

Query OK, 0 rows affected (0.004 sec)

MariaDB [test]> create table t2 like t1;

Query OK, 0 rows affected (0.003 sec)

MariaDB [test]> insert t1 values (1, 2), (1, 2), (1, 2), (2, 3), (2, 3), (3, 4), (3, 4);

Query OK, 7 rows affected (0.003 sec)

Records: 7  Duplicates: 0  Warnings: 0

MariaDB [test]> insert t2 values (1, 2), (1, 2), (2, 3), (2, 3), (2, 3), (2, 3), (4, 5);

Query OK, 7 rows affected (0.002 sec)

Records: 7  Duplicates: 0  Warnings: 0

MariaDB [test]> set sql_mode= 'oracle';

Query OK, 0 rows affected (0.001 sec)

MariaDB [test]> select * from t1 intersect all select * from t2 union values (1, 2);

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

| a    | b    |

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

|    1 |    2 |

|    2 |    3 |

|    1 |    2 |

|    2 |    3 |

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

4 rows in set (0.002 sec)

MariaDB [test]> create view t as select * from t1 intersect all select * from t2 union values (1, 2);

Query OK, 0 rows affected (0.002 sec)

MariaDB [test]> select * from t;

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

| a    | b    |

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

|    1 |    2 |

|    2 |    3 |

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

2 rows in set (0.003 sec)

select * from t1 intersect all select * from t2 union values (1, 2);

CURRENT_TEST: main.intersect_all

--- /home/buildbot/x86-debian-12-fulltest/build/mysql-test/main/intersect_all.result	2025-07-09 04:06:09.000000000 +0000

+++ /home/buildbot/x86-debian-12-fulltest/build/mysql-test/main/intersect_all.reject	2025-07-09 05:13:47.049907355 +0000

@@ -1155,8 +1155,6 @@

 a	b

 1	2

 2	3

-1	2

-2	3