diff options
Diffstat (limited to 'mysql-test/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index e8a7eb133fb..d72ecd65547 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -897,10 +897,13 @@ show status like 'prepared_stmt_count'; Variable_name Value Prepared_stmt_count 0 prepare stmt from "select 1"; +connect con1,localhost,root,,; +connection con1; prepare stmt from "select 2"; prepare stmt1 from "select 3"; prepare stmt2 from "select 4"; ERROR 42000: Can't create more than max_prepared_stmt_count statements (current value: 3) +connection default; prepare stmt2 from "select 4"; ERROR 42000: Can't create more than max_prepared_stmt_count statements (current value: 3) select @@max_prepared_stmt_count; @@ -909,6 +912,8 @@ select @@max_prepared_stmt_count; show status like 'prepared_stmt_count'; Variable_name Value Prepared_stmt_count 3 +disconnect con1; +connection default; deallocate prepare stmt; select @@max_prepared_stmt_count; @@max_prepared_stmt_count @@ -2895,12 +2900,14 @@ INSERT INTO t1 VALUES (1); CREATE TABLE t2 (i INT); INSERT INTO t2 VALUES (2); LOCK TABLE t1 READ, t2 WRITE; +connect conn1, localhost, root, , ; PREPARE stmt1 FROM "SELECT i FROM t1"; PREPARE stmt2 FROM "INSERT INTO t2 (i) VALUES (3)"; EXECUTE stmt1; i 1 EXECUTE stmt2; +connection default; SELECT * FROM t2; i 2 @@ -2913,6 +2920,7 @@ ALTER TABLE t1 ADD COLUMN j INT; ALTER TABLE t2 ADD COLUMN j INT; INSERT INTO t1 VALUES (4, 5); INSERT INTO t2 VALUES (4, 5); +connection conn1; EXECUTE stmt1; i 1 @@ -2924,6 +2932,8 @@ i j 3 NULL 4 5 3 NULL +disconnect conn1; +connection default; DROP TABLE t1, t2; drop table if exists t1; Warnings: @@ -3793,11 +3803,16 @@ DROP TABLE t1; # # Test that metadata locks taken during prepare are released. # +connect con1,localhost,root,,; +connection default; DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a INT); +connection con1; BEGIN; PREPARE stmt1 FROM "SELECT * FROM t1"; +connection default; DROP TABLE t1; +disconnect con1; # # Bug#56115: invalid memory reads when PS selecting from |