Debian Codegraph @

mysql-test/suite/sysschema/r/pr_execute_prepared_stmt.result

raw
1 SET @sql := "CREATE TABLE test.t1 (i INT)";
2 CALL sys.execute_prepared_stmt(@sql);
3 SHOW CREATE TABLE test.t1;
4 Table Create Table
5 t1 CREATE TABLE `t1` (
6 `i` int DEFAULT NULL
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
8 SET @sql := CONCAT('INSERT INTO test.t1 VALUES (', 1, ')');
9 CALL sys.execute_prepared_stmt(@sql);
10 SELECT * FROM test.t1;
11 i
12 1
13 SET @sql := "DROP TABLE test.t1";
14 CALL sys.execute_prepared_stmt(@sql);
15 SHOW TABLES;
16 Tables_in_test
17 SET @sql = NULL;
18 CALL sys.execute_prepared_stmt(NULL);
19 ERROR 45000: The @sys.execute_prepared_stmt.sql must contain a query
20 CALL sys.execute_prepared_stmt('foo');
21 ERROR 45000: The @sys.execute_prepared_stmt.sql must contain a query