Bug #23930 Can not set numeric system variables
Submitted: 3 Nov 2006 10:15 Modified: 13 Nov 2006 11:08
Reporter: Heinz Schweitzer (Gold Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.5 RC OS:Windows (XP)
Assigned to: Mike Lischke CPU Architecture:Any

[3 Nov 2006 10:15] Heinz Schweitzer
Description:
Can not set numeric system variables
You can change the values for all variables of type ON/OFF but
not for those with a numeric value.

MySQL-Server-Information
--------------------------------------------------------------------------------
Mit MySQL-Serverinstanz verbunden
  Benutzername:            root
  Hostname:                localhost
  Port:                    3306
--------------------------------------------------------------------------------
Serverinformation
  MySQL-Version:           MySQL 5.0.24a-community-nt via TCP/IP
  Netzwerkname:            localhost
  IP:                      127.0.0.1
--------------------------------------------------------------------------------
Clientinformation
  Version:                 MySQL Client Version 5.1.11
  Netzwerkname:            hgs
  IP:                      192.168.2.5
  Betriebssystem:          Windows XP
  Hardware:                Intel(R) Pentium(R) 4 CPU 2.00GHz, 504 MB RAM

How to repeat:
Start MA 1.2.5RC German

In left pane select 'Serverstaus'
In right pane activate tab 'Systemvariablen'
In there select 'General'->'Performance'
In the rigth frame, variables show up that indicate that they all 
can be set/changed.

Try to set flush_time
--> error like in screen shot v1

You can change the values for all variables of type ON/OFF but
not for those with a numeric value.
[3 Nov 2006 10:16] Heinz Schweitzer
v1

Attachment: v1.png (image/png, text), 115.05 KiB.

[11 Nov 2006 10:22] Valeriy Kravchuk
Thank you for a bug report. Verified just as described on XP SP2.
[13 Nov 2006 11:08] Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html