diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2014-11-05 11:05:01 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2014-11-05 11:05:01 +0100 |
| commit | 953dd8d87fea224e26d11452eb458c79ba098f4a (patch) | |
| tree | e650c8a11e5dd5f46a4a51526c8186a222da1df5 /mysql-test | |
| parent | d6981391eb8f904135dfdedb5b90a7592b35e648 (diff) | |
| download | mariadb-git-bb-10.1-set-statement.tar.gz | |
MDEV-6997 MDEV-6996 MDEV-7002 MDEV-7006 MDEV-7009 MDEV-7012 MDEV-7015 MDEV-6977bb-10.1-set-statement
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/set_statement.result | 34 | ||||
| -rw-r--r-- | mysql-test/t/set_statement.test | 35 |
2 files changed, 69 insertions, 0 deletions
diff --git a/mysql-test/r/set_statement.result b/mysql-test/r/set_statement.result index 3afc097ad47..efe5286147c 100644 --- a/mysql-test/r/set_statement.result +++ b/mysql-test/r/set_statement.result @@ -1066,3 +1066,37 @@ set statement skip_replication=default for select 1; ERROR 42000: The system variable skip_replication cannot be set in SET STATEMENT. set statement default_master_connection=default for select 1; ERROR 42000: The system variable default_master_connection cannot be set in SET STATEMENT. +set statement default_master_connection=default for select 1; +ERROR 42000: The system variable default_master_connection cannot be set in SET STATEMENT. +set statement last_insert_id=1 for select 1; +ERROR 42000: The system variable last_insert_id cannot be set in SET STATEMENT. +set statement sql_log_off=default for select 1; +ERROR 42000: The system variable sql_log_off cannot be set in SET STATEMENT. +set statement long_query_time=default for select 1; +ERROR 42000: The system variable long_query_time cannot be set in SET STATEMENT. +set statement log_slow_filter=default for select 1; +ERROR 42000: The system variable log_slow_filter cannot be set in SET STATEMENT. +set statement log_slow_verbosity=default for select 1; +ERROR 42000: The system variable log_slow_verbosity cannot be set in SET STATEMENT. +set statement log_slow_rate_limit=default for select 1; +ERROR 42000: The system variable log_slow_rate_limit cannot be set in SET STATEMENT. +set statement slow_query_log=default for select 1; +ERROR 42000: The system variable slow_query_log cannot be set in SET STATEMENT. +set statement min_examined_row_limit=default for select 1; +ERROR 42000: The system variable min_examined_row_limit cannot be set in SET STATEMENT. +set statement character_set_client=default for select 1; +ERROR 42000: The system variable character_set_client cannot be set in SET STATEMENT. +set statement character_set_connection=default for select 1; +ERROR 42000: The system variable character_set_connection cannot be set in SET STATEMENT. +set statement character_set_filesystem=default for select 1; +ERROR 42000: The system variable character_set_filesystem cannot be set in SET STATEMENT. +set statement collation_connection=default for select 1; +ERROR 42000: The system variable collation_connection cannot be set in SET STATEMENT. +set statement old_passwords=default for select 1; +ERROR 42000: The system variable old_passwords cannot be set in SET STATEMENT. +set statement query_cache_type=default for select 1; +ERROR 42000: The system variable query_cache_type cannot be set in SET STATEMENT. +set statement wait_timeout=default for select 1; +ERROR 42000: The system variable wait_timeout cannot be set in SET STATEMENT. +set statement interactive_timeout=default for select 1; +ERROR 42000: The system variable interactive_timeout cannot be set in SET STATEMENT. diff --git a/mysql-test/t/set_statement.test b/mysql-test/t/set_statement.test index b92e90937f3..a65807192b5 100644 --- a/mysql-test/t/set_statement.test +++ b/mysql-test/t/set_statement.test @@ -1012,3 +1012,38 @@ set statement rand_seed2=default for select 1; set statement skip_replication=default for select 1; --error ER_SET_STATEMENT_NOT_SUPPORTED set statement default_master_connection=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement default_master_connection=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement last_insert_id=1 for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement sql_log_off=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement long_query_time=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement log_slow_filter=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement log_slow_verbosity=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement log_slow_rate_limit=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement slow_query_log=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement min_examined_row_limit=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement character_set_client=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement character_set_connection=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement character_set_filesystem=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement collation_connection=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement old_passwords=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement query_cache_type=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement wait_timeout=default for select 1; +--error ER_SET_STATEMENT_NOT_SUPPORTED +set statement interactive_timeout=default for select 1; + |