Debian Codegraph @

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

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