Bug #74104 ndb_join_pushdown documentation wrong?

Submitted: 26 Sep 2014 11:27 Modified: 29 Sep 2014 15:09
Reporter: Hartmut Holzgraefe Email Updates:
Status: Closed Impact on me:
None 
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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.