| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/sys_vars/r/ |
| H A D | join_cache_level_basic.result | 4 join_cache_level #
7 join_cache_level #
14 set global join_cache_level=4;
15 select @@global.join_cache_level;
16 @@global.join_cache_level
18 set session join_cache_level=4;
20 @@session.join_cache_level
22 set global join_cache_level=1.1;
28 set global join_cache_level=0;
30 @@global.join_cache_level
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/sys_vars/r/ |
| H A D | join_cache_level_basic.result | 4 join_cache_level #
7 join_cache_level #
14 set global join_cache_level=4;
15 select @@global.join_cache_level;
16 @@global.join_cache_level
18 set session join_cache_level=4;
20 @@session.join_cache_level
22 set global join_cache_level=1.1;
28 set global join_cache_level=0;
30 @@global.join_cache_level
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/sys_vars/r/ |
| H A D | join_cache_level_basic.result | 4 join_cache_level #
7 join_cache_level #
14 set global join_cache_level=4;
15 select @@global.join_cache_level;
16 @@global.join_cache_level
18 set session join_cache_level=4;
20 @@session.join_cache_level
22 set global join_cache_level=1.1;
28 set global join_cache_level=0;
30 @@global.join_cache_level
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/sys_vars/r/ |
| H A D | join_cache_level_basic.result | 4 join_cache_level #
7 join_cache_level #
14 set global join_cache_level=4;
15 select @@global.join_cache_level;
16 @@global.join_cache_level
18 set session join_cache_level=4;
20 @@session.join_cache_level
22 set global join_cache_level=1.1;
28 set global join_cache_level=0;
30 @@global.join_cache_level
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/sys_vars/r/ |
| H A D | join_cache_level_basic.result | 4 join_cache_level #
7 join_cache_level #
14 set global join_cache_level=4;
15 select @@global.join_cache_level;
16 @@global.join_cache_level
18 set session join_cache_level=4;
20 @@session.join_cache_level
22 set global join_cache_level=1.1;
28 set global join_cache_level=0;
30 @@global.join_cache_level
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/sys_vars/r/ |
| H A D | join_cache_level_basic.result | 4 join_cache_level #
7 join_cache_level #
14 set global join_cache_level=4;
15 select @@global.join_cache_level;
16 @@global.join_cache_level
18 set session join_cache_level=4;
20 @@session.join_cache_level
22 set global join_cache_level=1.1;
28 set global join_cache_level=0;
30 @@global.join_cache_level
[all …]
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/sys_vars/t/ |
| H A D | join_cache_level_basic.test | 9 show global variables like 'join_cache_level';
20 set global join_cache_level=4;
21 select @@global.join_cache_level;
22 set session join_cache_level=4;
23 select @@session.join_cache_level;
29 set global join_cache_level=1.1;
31 set session join_cache_level=1e1;
33 set global join_cache_level="foo";
38 set global join_cache_level=0;
39 select @@global.join_cache_level;
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/sys_vars/t/ |
| H A D | join_cache_level_basic.test | 9 show global variables like 'join_cache_level';
20 set global join_cache_level=4;
21 select @@global.join_cache_level;
22 set session join_cache_level=4;
23 select @@session.join_cache_level;
29 set global join_cache_level=1.1;
31 set session join_cache_level=1e1;
33 set global join_cache_level="foo";
38 set global join_cache_level=0;
39 select @@global.join_cache_level;
[all …]
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/sys_vars/t/ |
| H A D | join_cache_level_basic.test | 9 show global variables like 'join_cache_level';
20 set global join_cache_level=4;
21 select @@global.join_cache_level;
22 set session join_cache_level=4;
23 select @@session.join_cache_level;
29 set global join_cache_level=1.1;
31 set session join_cache_level=1e1;
33 set global join_cache_level="foo";
38 set global join_cache_level=0;
39 select @@global.join_cache_level;
[all …]
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/sys_vars/t/ |
| H A D | join_cache_level_basic.test | 9 show global variables like 'join_cache_level';
20 set global join_cache_level=4;
21 select @@global.join_cache_level;
22 set session join_cache_level=4;
23 select @@session.join_cache_level;
29 set global join_cache_level=1.1;
31 set session join_cache_level=1e1;
33 set global join_cache_level="foo";
38 set global join_cache_level=0;
39 select @@global.join_cache_level;
[all …]
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/sys_vars/t/ |
| H A D | join_cache_level_basic.test | 9 show global variables like 'join_cache_level';
20 set global join_cache_level=4;
21 select @@global.join_cache_level;
22 set session join_cache_level=4;
23 select @@session.join_cache_level;
29 set global join_cache_level=1.1;
31 set session join_cache_level=1e1;
33 set global join_cache_level="foo";
38 set global join_cache_level=0;
39 select @@global.join_cache_level;
[all …]
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/sys_vars/t/ |
| H A D | join_cache_level_basic.test | 9 show global variables like 'join_cache_level';
20 set global join_cache_level=4;
21 select @@global.join_cache_level;
22 set session join_cache_level=4;
23 select @@session.join_cache_level;
29 set global join_cache_level=1.1;
31 set session join_cache_level=1e1;
33 set global join_cache_level="foo";
38 set global join_cache_level=0;
39 select @@global.join_cache_level;
[all …]
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
| H A D | subselect_sj_jcl6.test | 14 set join_cache_level=6;
70 SET SESSION join_cache_level=3;
79 SET SESSION join_cache_level=6;
87 set join_cache_level=default;
95 set @jcl_912513= @@join_cache_level;
97 SET join_cache_level = 3;
115 set @@join_cache_level= @jcl_912513;
138 set join_cache_level=0;
152 set join_cache_level=6;
188 set join_cache_level=0;
[all …]
|
| H A D | subselect_sj2_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_subselect_sj2_test=@@join_cache_level;
46 SET SESSION join_cache_level=2;
54 set join_cache_level=default;
74 SET join_cache_level = 2;
81 set join_cache_level=default;
87 --echo # Bug #899962: materialized subquery with join_cache_level=3
98 SET join_cache_level = 3;
109 set join_cache_level=default;
|
| H A D | select_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_select_test=@@join_cache_level;
19 set join_cache_level=default;
|
| /dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
| H A D | subselect_sj_jcl6.test | 14 set join_cache_level=6;
70 SET SESSION join_cache_level=3;
79 SET SESSION join_cache_level=6;
87 set join_cache_level=default;
95 set @jcl_912513= @@join_cache_level;
97 SET join_cache_level = 3;
115 set @@join_cache_level= @jcl_912513;
138 set join_cache_level=0;
152 set join_cache_level=6;
188 set join_cache_level=0;
[all …]
|
| H A D | subselect_sj2_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_subselect_sj2_test=@@join_cache_level;
46 SET SESSION join_cache_level=2;
54 set join_cache_level=default;
74 SET join_cache_level = 2;
81 set join_cache_level=default;
87 --echo # Bug #899962: materialized subquery with join_cache_level=3
98 SET join_cache_level = 3;
109 set join_cache_level=default;
|
| /dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/ |
| H A D | subselect_sj_jcl6.test | 14 set join_cache_level=6;
70 SET SESSION join_cache_level=3;
79 SET SESSION join_cache_level=6;
87 set join_cache_level=default;
95 set @jcl_912513= @@join_cache_level;
97 SET join_cache_level = 3;
115 set @@join_cache_level= @jcl_912513;
138 set join_cache_level=0;
152 set join_cache_level=6;
188 set join_cache_level=0;
[all …]
|
| H A D | subselect_sj2_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_subselect_sj2_test=@@join_cache_level;
46 SET SESSION join_cache_level=2;
54 set join_cache_level=default;
74 SET join_cache_level = 2;
81 set join_cache_level=default;
87 --echo # Bug #899962: materialized subquery with join_cache_level=3
98 SET join_cache_level = 3;
109 set join_cache_level=default;
|
| /dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
| H A D | subselect_sj_jcl6.test | 14 set join_cache_level=6;
70 SET SESSION join_cache_level=3;
79 SET SESSION join_cache_level=6;
87 set join_cache_level=default;
95 set @jcl_912513= @@join_cache_level;
97 SET join_cache_level = 3;
115 set @@join_cache_level= @jcl_912513;
138 set join_cache_level=0;
152 set join_cache_level=6;
188 set join_cache_level=0;
[all …]
|
| H A D | subselect_sj2_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_subselect_sj2_test=@@join_cache_level;
46 SET SESSION join_cache_level=2;
54 set join_cache_level=default;
74 SET join_cache_level = 2;
81 set join_cache_level=default;
87 --echo # Bug #899962: materialized subquery with join_cache_level=3
98 SET join_cache_level = 3;
109 set join_cache_level=default;
|
| /dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/ |
| H A D | subselect_sj_jcl6.test | 14 set join_cache_level=6;
70 SET SESSION join_cache_level=3;
79 SET SESSION join_cache_level=6;
87 set join_cache_level=default;
95 set @jcl_912513= @@join_cache_level;
97 SET join_cache_level = 3;
115 set @@join_cache_level= @jcl_912513;
138 set join_cache_level=0;
152 set join_cache_level=6;
188 set join_cache_level=0;
[all …]
|
| H A D | subselect_sj2_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_subselect_sj2_test=@@join_cache_level;
39 SET SESSION join_cache_level=2;
47 set join_cache_level=default;
67 SET join_cache_level = 2;
74 set join_cache_level=default;
80 --echo # Bug #899962: materialized subquery with join_cache_level=3
91 SET join_cache_level = 3;
102 set join_cache_level=default;
|
| /dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/main/ |
| H A D | subselect_sj_jcl6.test | 14 set join_cache_level=6;
70 SET SESSION join_cache_level=3;
79 SET SESSION join_cache_level=6;
87 set join_cache_level=default;
95 set @jcl_912513= @@join_cache_level;
97 SET join_cache_level = 3;
115 set @@join_cache_level= @jcl_912513;
138 set join_cache_level=0;
152 set join_cache_level=6;
188 set join_cache_level=0;
[all …]
|
| H A D | subselect_sj2_jcl6.test | 11 set join_cache_level=6;
12 show variables like 'join_cache_level';
15 set @join_cache_level_for_subselect_sj2_test=@@join_cache_level;
39 SET SESSION join_cache_level=2;
47 set join_cache_level=default;
67 SET join_cache_level = 2;
74 set join_cache_level=default;
80 --echo # Bug #899962: materialized subquery with join_cache_level=3
91 SET join_cache_level = 3;
102 set join_cache_level=default;
|