Spider tests with view protocol fail with "Failed to drop view: 0: "

spider/bugfix.mdev_21884                 w3 [ fail ]

        Test ended at 2025-04-04 10:32:45

CURRENT_TEST: spider/bugfix.mdev_21884

mysqltest: At line 90: Failed to drop view: 0: 

The result from queries just before the failure was:

< snip >

test 1

connection child2_1;

TRUNCATE TABLE mysql.general_log;

connection master_1;

SELECT STRAIGHT_JOIN b.a, b.b FROM tb_l a, tbl_a b WHERE a.a = b.a;

a	b

11	a

11	b

12	d

12	e

13	c

connection child2_1;

SET NAMES utf8;

SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %';

argument

select `a`,`b` from `auto_test_remote`.`ta_r2` order by `a`,`b`

select `a`,`b` from `auto_test_remote`.`ta_r3` order by `a`,`b`

SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %'

SELECT a, b, c FROM ta_r2 ORDER BY a ;

SELECT a, b, c FROM ta_r3 ORDER BY a;

More results from queries before failure can be found in /home/ycp/source/mariadb-server/10.5/build/mysql-test/var/3/log/mdev_21884.log