Debian Codegraph @

mysql-test/suite/sysschema/t/pr_execute_prepared_stmt.test

raw
1 -- source include/not_embedded.inc
2
3 # Do some valid changes, ensure they are successful
4 SET @sql := "CREATE TABLE test.t1 (i INT) Engine=MEMORY";
5 CALL sys.execute_prepared_stmt(@sql);
6
7 SHOW CREATE TABLE test.t1;
8
9 SET @sql := CONCAT('INSERT INTO test.t1 VALUES (', 1, ')');
10 CALL sys.execute_prepared_stmt(@sql);
11
12 SELECT * FROM test.t1;
13
14 SET @sql := "DROP TABLE test.t1";
15 CALL sys.execute_prepared_stmt(@sql);
16
17 SHOW TABLES;
18
19 SET @sql = NULL;
20
21 # Invalid inputs
22 -- error S45000
23 CALL sys.execute_prepared_stmt(NULL);
24 -- error S45000
25 CALL sys.execute_prepared_stmt('foo');