Debian Codegraph @

mysql-test/suite/test_service_sql_api/t/test_sql_views_triggers.test

raw
1 --echo # Creating table t1
2 CREATE TABLE t1(c1 INT, c2 VARCHAR(128));
3 INSERT INTO t1 VALUES (1, 'aaa'), (2, 'bbb'), (3, 'ccc');
4
5 --echo # Creating a view
6 CREATE VIEW v1 AS SELECT * FROM t1;
7
8 --echo # Creating table t2
9 CREATE TABLE t2(c1 INT, c2 VARCHAR(128));
10
11 --echo # Creating a trigger
12 CREATE TRIGGER trig AFTER UPDATE ON t1 FOR EACH ROW INSERT INTO t2 VALUES (1, 'aaa');
13
14 --echo ##########################################
15 --echo # Run plugin
16 --echo ##########################################
17 --replace_result $TEST_SQL_VIEWS_TRIGGERS TEST_SQL_VIEWS_TRIGGERS
18 eval INSTALL PLUGIN test_sql_views_triggers SONAME '$TEST_SQL_VIEWS_TRIGGERS';
19
20 --echo ##########################################
21 --echo # Stop plugin
22 --echo ##########################################
23 UNINSTALL PLUGIN test_sql_views_triggers;
24
25 --echo ##########################################
26 --echo # Plugin log
27 --echo ##########################################
28 let $MYSQLD_DATADIR= `select @@datadir`;
29 cat_file $MYSQLD_DATADIR/test_sql_views_triggers.log;
30 remove_file $MYSQLD_DATADIR/test_sql_views_triggers.log;
31
32 --echo # Checking the view created in test plugin is visible in MTR test
33 SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1';
34
35 --echo # Checking the contents of the view created
36 SELECT * FROM v1;
37
38 --echo # Checking the trigger created in test plugin is visible in MTR test
39 SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA = 'test' AND TRIGGER_NAME = 'trig';
40
41 --echo # Calling the trigger created in test plugin
42 UPDATE t1 SET c2 = 'abcde' WHERE c1 = 1;
43 SELECT * FROM t2;
44
45 --echo ##########################################
46 --echo # Cleanup
47 --echo ##########################################
48
49 --echo # Dropping the created view
50 DROP VIEW v1;
51
52 --echo # Dropping the created trigger
53 DROP TRIGGER trig;
54
55 --echo # Dropping the created tables
56 DROP TABLE t1;
57 DROP TABLE t2;