Bug #33358 Plugin enum variables can't be set from command line

Submitted: 19 Dec 2007 6:16 Modified: 15 Apr 2008 2:11
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Antony Curtis CPU Architecture:Any
Tags: plugin

[19 Dec 2007 6:16] Oleksandr Byelkin
Description:
value of variable does not change if set it from command line.

How to repeat:
1. have bug#33345 fixed.
2. start mysqld with example plugin loaded from the start, for example:
(from /home/bell/mysql/bk/work-variable-5.1/mysql-test directory after running some tests):
/home/bell/mysql/bk/work-variable-5.1/sql/mysqld --no-defaults --skip-grant-tables --basedir=/home/bell/mysql/bk/work-variable-5.1/mysql-test --datadir=/home/bell/mysql/bk/work-variable-5.1/mysql-test/var/master-data --loose-skip-innodb --loose-skip-ndbcluster --tmpdir=. --core-file --language=/home/bell/mysql/bk/work-variable-5.1/sql/share/english --character-sets-dir=/home/bell/mysql/bk/work-variable-5.1/sql/share/charsets --plugin_dir=/home/bell/mysql/bk/work-variable-5.1/storage/example/.libs/ --plugin_load=ha_example.so
3. check the variable value:
mysql> select @@global.example_enum_var;
+---------------------------+
| @@global.example_enum_var |
+---------------------------+
| e1                        |
+---------------------------+
1 row in set (0.00 sec)
4. restart the server with variable set:
/home/bell/mysql/bk/work-variable-5.1/sql/mysqld --no-defaults --skip-grant-tables --basedir=/home/bell/mysql/bk/work-variable-5.1/mysql-test --datadir=/home/bell/mysql/bk/work-variable-5.1/mysql-test/var/master-data --loose-skip-innodb --loose-skip-ndbcluster --tmpdir=. --core-file --language=/home/bell/mysql/bk/work-variable-5.1/sql/share/english --character-sets-dir=/home/bell/mysql/bk/work-variable-5.1/sql/share/charsets --plugin_dir=/home/bell/mysql/bk/work-variable-5.1/storage/example/.libs/ --plugin_load=ha_example.so --example-enum-var=e2
5. check that value of the variable is still e1
[19 Dec 2007 20:41] MySQL Verification Team
Thank you for the bug report.

[miguel@amanhecer 5.1]$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.23-rc-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select @@global.example_enum_var;
+---------------------------+
| @@global.example_enum_var |
+---------------------------+
| e1                        | 
+---------------------------+
1 row in set (0.00 sec)

mysql> exit
Bye
[miguel@amanhecer 5.1]$ bin/mysqladmin -uroot shutdown
[miguel@amanhecer 5.1]$ bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.23-rc-debug Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select @@global.example_enum_var;
+---------------------------+
| @@global.example_enum_var |
+---------------------------+
| e1                        | 
+---------------------------+
1 row in set (0.00 sec)

mysql>
[21 Jan 2008 20:02] 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/41088

ChangeSet@1.2655, 2008-01-21 12:01:21-08:00, acurtis@xiphis.org +4 -0
  Bug#33358
    "Plugin enum variables can't be set from command line"
    fix crash of LOCK_plugins mutex when loading plug-ins from command line.
    fix off-by-one bug when loading multiple plug-ins from the command line.
    initialize command line handling for ENUM and SET plugin variable types.
[23 Jan 2008 5:00] 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/41132

ChangeSet@1.2655, 2008-01-22 20:59:46-08:00, acurtis@xiphis.org +4 -0
  Bug#33358
    "Plugin enum variables can't be set from command line"
    fix crash of LOCK_plugins mutex when loading plug-ins from command line.
    fix off-by-one bug when loading multiple plug-ins from the command line.
    initialize command line handling for ENUM and SET plugin variable types.
[26 Jan 2008 0:05] 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/41273

ChangeSet@1.2659, 2008-01-25 16:05:15-08:00, acurtis@xiphis.org +4 -0
  Bug#33358
    "Plugin enum variables can't be set from command line"
    fix crash of LOCK_plugins mutex when loading plug-ins from command line.
    fix off-by-one bug when loading multiple plug-ins from the command line.
    initialize command line handling for ENUM and SET plugin variable types.
[26 Jan 2008 2:41] Antony Curtis
Queued to 5.1-engines and 6.0-engines
[27 Mar 2008 11:21] Bugs System
Pushed into 5.1.24-rc
[27 Mar 2008 17:53] Bugs System
Pushed into 6.0.5-alpha
[2 Apr 2008 16:01] Jon Stephens
Pushed into 5.1.23-ndb-6.3.11.
[15 Apr 2008 2:11] Paul DuBois
Noted in 5.1.24, 6.0.5 changelogs.

ENUM- or SET-valued plugin variables could not be set from the
command line.

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

Page generated in 0.068 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.