summaryrefslogtreecommitdiff
path: root/mysql-test/main/sp-i_s_columns.test
blob: 0782d06d1cc0210378c022bf17f0edda1bbebaaa (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
--echo #
--echo # MDEV-28267 ASAN heap-use-after-free in Item_sp::func_name_cstring
--echo #

CREATE TABLE t1 (a INT);
CREATE FUNCTION test.f1(a INT) RETURNS TEXT RETURN '';
CREATE FUNCTION test.f2(a INT) RETURNS TEXT RETURN '';
CREATE VIEW v1 AS SELECT f1(a) AS v1 FROM t1;
CREATE VIEW v2 AS SELECT f1(a) AS v2 FROM t1;
CREATE VIEW v3 AS SELECT f1(a) AS v3 FROM t1;
CREATE VIEW v4 AS SELECT f1(a) AS v4 FROM t1;

--disable_result_log

DELIMITER $$;
--send
BEGIN NOT ATOMIC
  FOR i IN 1..10
  DO
    ANALYZE FORMAT=JSON SELECT *
      FROM INFORMATION_SCHEMA.COLUMNS
    WHERE
      TABLE_SCHEMA='test'
    AND
      TABLE_NAME LIKE 'v%'
    AND
      (SLEEP(0.01)=0 OR f1(ordinal_position) >'')
    ORDER BY TABLE_NAME;
  END FOR;
END;
$$
DELIMITER ;$$

--connect (con1,localhost,root,,test)
CREATE OR REPLACE FUNCTION f2(a INT) RETURNS TEXT RETURN '';
--connection default
--reap

--enable_result_log


# Cleanup
--disconnect con1
--connection default

DROP FUNCTION f1;
DROP FUNCTION f2;
DROP TABLE t1;
DROP VIEW v1, v2, v3, v4;