diff options
Diffstat (limited to 'mysql-test/main/view_debug.result')
| -rw-r--r-- | mysql-test/main/view_debug.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/main/view_debug.result b/mysql-test/main/view_debug.result new file mode 100644 index 00000000000..cfb70b5e74c --- /dev/null +++ b/mysql-test/main/view_debug.result @@ -0,0 +1,25 @@ +# +#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'; +drop procedure proc; +drop view v1,v2; |