Bug #74104 ndb_join_pushdown documentation wrong?

• Submitted: 26 Sep 2014 11:27
• Modified: 29 Sep 2014 15:09
• Reporter: Hartmut Holzgraefe
• Status: Closed
• Category: MySQL Cluster: Documentation
• Severity: S3 (Non-critical)
• Version: cluster-7.2.15, 5.6.19-ndb-7.3.6
• OS: Any
• Assigned to: Jon Stephens
• CPU Architecture: Any

[26 Sep 2014 11:27] Hartmut Holzgraefe

Description:
The Manual says ndb_join_pushdown is global and can't be set dynamically,
but it acutally seems to be a runtime-settable per-session setting?

http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-system-variables.html#sysvar_ndb_join...

How to repeat:
mysql> show global variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | ON    |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> show session variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | ON    |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> set session ndb_join_pushdown=0;
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | ON    |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> show session variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | OFF   |
+-------------------+-------+
1 row in set (0.00 sec)

[26 Sep 2014 12:06] MySQL Verification Team

Hello Hartmut,

Thank you for the report.

Thanks,
Umesh

[26 Sep 2014 12:07] MySQL Verification Team

//

mysql> show variables like '%version%';
+-------------------------+------------------------------------------------------+
| Variable_name           | Value                                                |
+-------------------------+------------------------------------------------------+
| innodb_version          | 5.6.19                                               |
| ndb_version             | 459526                                               |
| ndb_version_string      | ndb-7.3.6                                            |
| ndbinfo_version         | 459526                                               |
| protocol_version        | 10                                                   |
| slave_type_conversions  |                                                      |
| version                 | 5.6.19-ndb-7.3.6-cluster-commercial-advanced-log     |
| version_comment         | MySQL Cluster Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                               |
| version_compile_os      | linux-glibc2.5                                       |
+-------------------------+------------------------------------------------------+
10 rows in set (0.00 sec)

mysql> show global variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | ON    |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> show session variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | ON    |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> set session ndb_join_pushdown=0;
Query OK, 0 rows affected (0.00 sec)

mysql> show session variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | OFF   |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> show global variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | ON    |
+-------------------+-------+
1 row in set (0.00 sec)

mysql> set global  ndb_join_pushdown=0;
Query OK, 0 rows affected (0.00 sec)

mysql> show global variables like 'ndb_join_pushdown';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| ndb_join_pushdown | OFF   |
+-------------------+-------+
1 row in set (0.00 sec)

[29 Sep 2014 15:09] Jon Stephens

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.