diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2014-10-24 10:13:08 +0200 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2014-11-11 11:48:50 +0100 |
commit | 1827d9e6d188e3ad53e057a583ebed02767b65ac (patch) | |
tree | 83cbcb5d6e4284149e9a16803884ed4e4766b23d /mysql-test/t/set_statement_debug.test | |
parent | a03dd94be804a4b8b1406696920834bb2c0bedbd (diff) | |
download | mariadb-git-1827d9e6d188e3ad53e057a583ebed02767b65ac.tar.gz |
MDEV-5231: Per query variables from Percona Server (rewritten)
Diffstat (limited to 'mysql-test/t/set_statement_debug.test')
-rw-r--r-- | mysql-test/t/set_statement_debug.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/set_statement_debug.test b/mysql-test/t/set_statement_debug.test new file mode 100644 index 00000000000..a409370a61a --- /dev/null +++ b/mysql-test/t/set_statement_debug.test @@ -0,0 +1,24 @@ +--source include/have_debug.inc +--source include/have_debug_sync.inc + +set @save_debug_dbug= @@debug_dbug; + +# check that change debug_dbug visible in SELECT +set statement debug_dbug="d,something" for select @@debug_dbug; +set @@debug_dbug= @save_debug_dbug; + +#check that change debug_dbug has influence of hooks... +CREATE TABLE t1(f0 int auto_increment primary key, f1 int); +INSERT INTO t1(f1) VALUES (0),(1),(2),(3),(4),(5); +CALL mtr.add_suppression("Out of sort memory"); +--error ER_OUT_OF_SORTMEMORY +SET statement debug_dbug= '+d,alloc_sort_buffer_fail' for SELECT * FROM t1 ORDER BY f1 ASC, f0; + +# ... and works only for one statement +SELECT * FROM t1 ORDER BY f1 ASC, f0; + +DROP TABLE t1; +set @@debug_dbug= @save_debug_dbug; + +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement DEBUG_SYNC = 'now SIGNAL hi' for select 1; |