10.1 testing (MDEV-6958)

[MDEV-6923] Testing for SET STATEMENT .. FOR (MDEV-5231, per-query variables) Created: 2014-10-24  Updated: 2015-05-19  Resolved: 2015-05-19

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: None
Fix Version/s: N/A

Type: Technical task Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: tests

Attachments: File mdev6923.test     File mdev6923_win.test    
Issue Links:
Relates
relates to MDEV-6940 SET STATEMENT executed after SET GLOB... Closed
relates to MDEV-6941 SET STATEMENT affects the value of th... Closed
relates to MDEV-6942 SET SESSION statement combined with S... Closed
relates to MDEV-6944 SQL_MODEs related to parsing are not ... Closed
relates to MDEV-6945 SET STATEMENT autocommit=... has no e... Closed
relates to MDEV-6946 Assertion `0' failed in mysql_execute... Closed
relates to MDEV-6948 SET STATEMENT gtid_domain_id = ... FO... Closed
relates to MDEV-6949 MySQL client does not recognize SET S... Closed
relates to MDEV-6951 Erroneous SET STATEMENT produces two ... Closed
relates to MDEV-6953 SET STATEMENT profiling = .. FOR does... Closed
relates to MDEV-6954 SET STATEMENT rand_seedX = ...FOR ...... Closed
relates to MDEV-6955 SET STATEMENT tx_isolation = FOR ...... Closed
relates to MDEV-6956 SET STATEMENT default_master_connecti... Closed
relates to MDEV-6957 SET STATEMENT skip_replication = .. m... Closed
relates to MDEV-6976 Assertion `! is_set() || m_can_overwr... Closed
relates to MDEV-6977 SET STATEMENT query_cache_type appare... Closed
relates to MDEV-6996 SET STATEMENT default_week_format = .... Closed
relates to MDEV-6997 SET STATEMENT last_insert_id FOR ... ... Closed
relates to MDEV-7002 SET STATEMENT sql_log_off has no effect Closed
relates to MDEV-7006 SET STATEMENT does not work with slow... Closed
relates to MDEV-7007 SET STATEMENT slow_query_log has no e... Closed
relates to MDEV-7009 SET STATEMENT min_examined_row_limit ... Closed
relates to MDEV-7012 SET STATEMENT character_set_client, c... Closed
relates to MDEV-7013 SET STATEMENT wait_timeout or interac... Closed
relates to MDEV-7015 SET STATEMENT old_passwords has no ef... Closed
relates to MDEV-7018 SET STATEMENT query_response_time_exe... Closed
relates to MDEV-8185 Variables related to query cache are ... Open

 Description   

Development task: MDEV-5231
docs: http://www.percona.com/doc/percona-server/5.6/flexibility/per_query_variable_statement.html
branch: https://github.com/MariaDB/server/tree/bb-10.1-set-statement

 Comments   
Comment by Elena Stepanova [ 2014-11-03 ]

Currently in the "standard" configuration (Linux, normal server with XtraDB, no additional plugins) we have 148 variables which are not read-only and have session scope.
As of

bb-10.1-set-statement

 
commit d6981391eb8f904135dfdedb5b90a7592b35e648
 
Author: Oleksandr Byelkin <sanja@mariadb.com>
 
Date:   Thu Oct 30 19:34:54 2014 +0100

10 are already disabled for SET STATEMENT (cause ER_SET_STATEMENT_NOT_SUPPORTED).

From the remaining ones, I tried about a half – not like tested them deeply, but at least checked that they do something more than just display their value in a SELECT under SET STATEMENT ... FOR.
Out of this half, about 2/3 worked and 1/3 didn't.
This gives enough information for further interpolation.

Bugs for discovered failures have been filed.
Most of failures are reproducible with Percona server, but not all of them.
Bugs reproducible on Percona server are also filed in their LP.

Attached is a rough test case for all variables (including read-only, global and unsupported). The windows version is the same as Linux minus several variables that do not exist on Windows.

Comment by Elena Stepanova [ 2014-11-04 ]

There are also plugin variables.

Query_response_time comes with 1, it doesn't work.
Spider comes with 80, didn't check them.
Test_sql_discovery comes with 2, they work.
Example comes with 4, didn't check them.
simple_parser comes with 2, didn't check them.
TokuDB comes with 28, didn't check them.

Didn't check Cassandra, Mroonga, probably more.

Comment by Elena Stepanova [ 2015-05-19 ]

Added new Linux test (the Windows one is not updated).

Comment by Elena Stepanova [ 2015-05-19 ]

The feature has not been fully tested, but it's been tested reasonably in accordance to its relative importance.

Generated at Thu Feb 08 07:15:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.