Debian Codegraph @

mysql-test/suite/sys_vars/r/enforce_storage_engine_basic.result

raw
1 SET @start_session_value = @@session.enforce_storage_engine;
2 SET @@session.enforce_storage_engine = INNODB;
3 SET @@session.enforce_storage_engine = DEFAULT;
4 SELECT @@session.enforce_storage_engine;
5 @@session.enforce_storage_engine
6 NULL
7 SET @@session.enforce_storage_engine = MYISAM;
8 SELECT @@session.enforce_storage_engine;
9 @@session.enforce_storage_engine
10 MyISAM
11 SET @@session.enforce_storage_engine = MERGE;
12 SELECT @@session.enforce_storage_engine;
13 @@session.enforce_storage_engine
14 MRG_MyISAM
15 SET @@session.enforce_storage_engine = MEMORY;
16 SELECT @@session.enforce_storage_engine;
17 @@session.enforce_storage_engine
18 MEMORY
19 SET @@session.enforce_storage_engine = INNODB;
20 SELECT @@session.enforce_storage_engine;
21 @@session.enforce_storage_engine
22 InnoDB
23 SET @@session.enforce_storage_engine = 8199;
24 ERROR 42000: Incorrect argument type to variable 'enforce_storage_engine'
25 SET @@session.enforce_storage_engine = 65530.34;
26 ERROR 42000: Incorrect argument type to variable 'enforce_storage_engine'
27 SET @@session.enforce_storage_engine = RECORD;
28 ERROR 42000: Unknown storage engine 'RECORD'
29 SELECT @@session.enforce_storage_engine =
30 VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
31 WHERE VARIABLE_NAME='enforce_storage_engine';
32 @@session.enforce_storage_engine =
33 VARIABLE_VALUE
34 1
35 SET @@session.enforce_storage_engine = TRUE;
36 ERROR 42000: Incorrect argument type to variable 'enforce_storage_engine'
37 SET @@session.enforce_storage_engine = FALSE;
38 ERROR 42000: Incorrect argument type to variable 'enforce_storage_engine'
39 SET @@session.enforce_storage_engine = @start_session_value;