mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
fe3adde250
MDEV-28567 counted two execution sequences, there is third one which executes ALTER VIEW before f() is created. The more appropriate place for this test case is lock_sync.test
28 lines
862 B
Text
28 lines
862 B
Text
#
|
|
#MDEV-8087:Server crashed in Time_and_counter_tracker::incr_loops
|
|
#
|
|
CREATE PROCEDURE proc() SELECT * FROM v2;
|
|
CREATE ALGORITHM = UNDEFINED VIEW v1 AS SELECT 1;
|
|
CREATE ALGORITHM = TEMPTABLE VIEW v2 AS SELECT 3 FROM v1;
|
|
DROP VIEW v1;
|
|
connect con1,localhost,root,,test;
|
|
connect con2,localhost,root,,test;
|
|
connection con1;
|
|
CALL proc();
|
|
ERROR HY000: View 'test.v2' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
|
|
SET DEBUG_SYNC= 'after_cached_view_opened SIGNAL oppp WAIT_FOR created';
|
|
CALL proc();
|
|
connection con2;
|
|
SET DEBUG_SYNC= 'now WAIT_FOR oppp';
|
|
SET DEBUG_SYNC= 'RESET';
|
|
CREATE ALGORITHM = TEMPTABLE VIEW v1 AS SELECT 2;
|
|
SET DEBUG_SYNC= 'now SIGNAL created';
|
|
connection con1;
|
|
3
|
|
3
|
|
SET DEBUG_SYNC= 'RESET';
|
|
disconnect con1;
|
|
disconnect con2;
|
|
connection default;
|
|
drop procedure proc;
|
|
drop view v1,v2;
|