| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_switch_basic.result | 5 select @@global.optimizer_switch;
6 @@global.optimizer_switch
8 select @@session.optimizer_switch;
9 @@session.optimizer_switch
23 set global optimizer_switch=10;
26 @@global.optimizer_switch
29 @@session.optimizer_switch
34 @@global.optimizer_switch
37 @@session.optimizer_switch
53 @@session.optimizer_switch
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 7 set @@global.optimizer_switch=@@optimizer_switch;
12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=4101;
23 set session optimizer_switch=2058;
24 select @@global.optimizer_switch;
28 select @@global.optimizer_switch;
37 set optimizer_switch = replace(@@optimizer_switch, '=off', '=on');
38 select @@optimizer_switch;
44 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 7 set @@global.optimizer_switch=@@optimizer_switch;
12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=4101;
23 set session optimizer_switch=2058;
24 select @@global.optimizer_switch;
28 select @@global.optimizer_switch;
37 set optimizer_switch = replace(@@optimizer_switch, '=off', '=on');
38 select @@optimizer_switch;
44 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 7 set @@global.optimizer_switch=@@optimizer_switch;
12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=4101;
23 set session optimizer_switch=2058;
24 select @@global.optimizer_switch;
28 select @@global.optimizer_switch;
37 set optimizer_switch = replace(@@optimizer_switch, '=off', '=on');
38 select @@optimizer_switch;
44 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 7 set @@global.optimizer_switch=@@optimizer_switch;
12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=4101;
23 set session optimizer_switch=2058;
24 select @@global.optimizer_switch;
28 select @@global.optimizer_switch;
37 set optimizer_switch = replace(@@optimizer_switch, '=off', '=on');
38 select @@optimizer_switch;
44 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 7 set @@global.optimizer_switch=@@optimizer_switch;
12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=4101;
23 set session optimizer_switch=2058;
24 select @@global.optimizer_switch;
28 select @@global.optimizer_switch;
37 set optimizer_switch = replace(@@optimizer_switch, '=off', '=on');
38 select @@optimizer_switch;
44 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 7 set @@global.optimizer_switch=@@optimizer_switch;
12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=4101;
23 set session optimizer_switch=2058;
24 select @@global.optimizer_switch;
28 select @@global.optimizer_switch;
37 set optimizer_switch = replace(@@optimizer_switch, '=off', '=on');
38 select @@optimizer_switch;
44 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=10;
23 set session optimizer_switch=5;
24 select @@global.optimizer_switch;
25 select @@session.optimizer_switch;
28 select @@global.optimizer_switch;
29 select @@session.optimizer_switch;
35 select @@session.optimizer_switch;
41 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=10;
23 set session optimizer_switch=5;
24 select @@global.optimizer_switch;
25 select @@session.optimizer_switch;
28 select @@global.optimizer_switch;
29 select @@session.optimizer_switch;
35 select @@session.optimizer_switch;
41 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=10;
23 set session optimizer_switch=5;
24 select @@global.optimizer_switch;
25 select @@session.optimizer_switch;
28 select @@global.optimizer_switch;
29 select @@session.optimizer_switch;
35 select @@session.optimizer_switch;
41 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=10;
23 set session optimizer_switch=5;
24 select @@global.optimizer_switch;
25 select @@session.optimizer_switch;
28 select @@global.optimizer_switch;
29 select @@session.optimizer_switch;
35 select @@session.optimizer_switch;
41 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=10;
23 set session optimizer_switch=5;
24 select @@global.optimizer_switch;
25 select @@session.optimizer_switch;
28 select @@global.optimizer_switch;
29 select @@session.optimizer_switch;
35 select @@session.optimizer_switch;
41 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/mysql55-client/mysql-5.5.62/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
22 set global optimizer_switch=10;
23 set session optimizer_switch=5;
24 select @@global.optimizer_switch;
25 select @@session.optimizer_switch;
28 select @@global.optimizer_switch;
29 select @@session.optimizer_switch;
35 select @@session.optimizer_switch;
41 set global optimizer_switch=1.1;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_switch_basic.test | 12 select @@global.optimizer_switch;
13 select @@session.optimizer_switch;
24 set global optimizer_switch=10;
25 set session optimizer_switch=5;
26 select @@global.optimizer_switch;
27 select @@session.optimizer_switch;
30 select @@global.optimizer_switch;
31 select @@session.optimizer_switch;
45 set global optimizer_switch=1.1;
47 set global optimizer_switch=1e1;
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/t/ |
| H A D | index_merge_myisam.test | 31 select @@optimizer_switch;
34 select @@optimizer_switch;
37 select @@optimizer_switch;
40 select @@optimizer_switch;
42 set optimizer_switch=4;
45 set optimizer_switch=NULL;
63 set optimizer_switch='on';
74 set optimizer_switch=default;
76 select @@optimizer_switch;
77 set optimizer_switch=default;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/t/ |
| H A D | index_merge_myisam.test | 31 select @@optimizer_switch;
34 select @@optimizer_switch;
37 select @@optimizer_switch;
40 select @@optimizer_switch;
42 set optimizer_switch=4;
45 set optimizer_switch=NULL;
63 set optimizer_switch='on';
74 set optimizer_switch=default;
76 select @@optimizer_switch;
77 set optimizer_switch=default;
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/t/ |
| H A D | index_merge_myisam.test | 31 select @@optimizer_switch;
34 select @@optimizer_switch;
37 select @@optimizer_switch;
40 select @@optimizer_switch;
42 set optimizer_switch=4;
45 set optimizer_switch=NULL;
63 set optimizer_switch='on';
74 set optimizer_switch=default;
76 select @@optimizer_switch;
77 set optimizer_switch=default;
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/t/ |
| H A D | index_merge_myisam.test | 31 select @@optimizer_switch;
34 select @@optimizer_switch;
37 select @@optimizer_switch;
40 select @@optimizer_switch;
42 set optimizer_switch=4;
45 set optimizer_switch=NULL;
63 set optimizer_switch='on';
74 set optimizer_switch=default;
76 select @@optimizer_switch;
77 set optimizer_switch=default;
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/t/ |
| H A D | index_merge_myisam.test | 31 select @@optimizer_switch;
34 select @@optimizer_switch;
37 select @@optimizer_switch;
40 select @@optimizer_switch;
42 set optimizer_switch=4;
45 set optimizer_switch=NULL;
63 set optimizer_switch='on';
74 set optimizer_switch=default;
76 select @@optimizer_switch;
77 set optimizer_switch=default;
[all …]
|