Bug #40457 not possible to set ndb_optimized_node_selection in session

• Submitted: 31 Oct 2008 14:21
• Modified: 1 Nov 2008 21:09
• Reporter: Tomas Ulin
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 5.1.29-ndb-6.3
• OS: Any
• Assigned to: Tomas Ulin
• CPU Architecture: Any

[31 Oct 2008 14:21] Tomas Ulin

Description:
not possible to set ndb_optimized_node_selection in session

How to repeat:
master> set session ndb_optimized_node_selection=1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

master> show warnings;
+---------+------+-------------------------------------------------------------+
| Level   | Code | Message                                                     |
+---------+------+-------------------------------------------------------------+
| Warning | 1292 | Truncated incorrect ndb_optimized_node_selection value: '1' | 
+---------+------+-------------------------------------------------------------+
1 row in set (0.00 sec)

master> show variables like '%ndb_optimized_node_selection%';
+------------------------------+-------+
| Variable_name                | Value |
+------------------------------+-------+
| ndb_optimized_node_selection | 0     | 
+------------------------------+-------+
1 row in set (0.01 sec)

master> show variables like '%ndb_optimized_node_selection%';
+------------------------------+-------+
| Variable_name                | Value |
+------------------------------+-------+
| ndb_optimized_node_selection | 0     | 
+------------------------------+-------+
1 row in set (0.00 sec)

[31 Oct 2008 14:24] Tomas Ulin

fixed in upcoming 6.3.19

[31 Oct 2008 14:25] Bugs System

Pushed into 5.1.29-ndb-6.3.19  (revid:[e-mail]-20081031142211-y80na7j8dkjeopef) (version source revid:[e-mail]-20081031142211-y80na7j8dkjeopef) (pib:5)

[1 Nov 2008 9:46] Bugs System

Pushed into 5.1.29-ndb-6.4.0  (revid:[e-mail]-20081031142211-y80na7j8dkjeopef) (version source revid:[e-mail]-20081101082305-qx5a1bj0z7i8ueys) (pib:5)

[1 Nov 2008 21:09] Jon Stephens

Documented in the ndb-6.3.19 changelog as follows:

        SET SESSION ndb_optimized_node_selection = 1 failed with an invalid
        warning message.

[3 Nov 2008 8:01] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/57656

2729 Tomas Ulin	2008-10-31
      Bug #40457  	not possible to set ndb_optimized_node_selection in session