Bug #9613 Some read-only variables are selectable, others are not

Submitted: 4 Apr 2005 14:18 Modified: 1 Sep 2005 2:12
Reporter: Victoria Reznichenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (any)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[4 Apr 2005 14:18] Victoria Reznichenko
Description:
Some read-only variables are selectable with SELECT @@variable_name, others are not.
For example:

mysql> show variables like "version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 4.1.11-debug-log    |
| version_comment         | Source distribution |
| version_compile_machine | i686                |
| version_compile_os      | pc-linux            |
+-------------------------+---------------------+
4 rows in set (0.00 sec)

mysql> select @@version;
+------------------+
| @@VERSION        |
+------------------+
| 4.1.11-debug-log |
+------------------+
1 row in set (0.00 sec)

mysql> select @@version_comment;
ERROR 1193 (HY000): Unknown system variable 'version_comment'
mysql> select @@version_compile_machine;
ERROR 1193 (HY000): Unknown system variable 'version_compile_machine'
mysql> select @@version_compile_os;
+----------------------+
| @@version_compile_os |
+----------------------+
| pc-linux             |
+----------------------+
1 row in set (0.00 sec)

How to repeat:
select @@version;
select @@version_comment;
select @@version_compile_machine;
select @@version_compile_os;
[30 Apr 2005 15:55] Sergei Golubchik
Fixing it properly for all variables would require significant changes that we cannot do in the stable version (4.1).

For now we'll only "fix" it for have_innodb variable, others will be fixed when we'll redo the complete framework (probably in 5.1)
[26 Aug 2005 8:23] 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/internals/28879
[30 Aug 2005 13:14] Ramil Kalimullin
Fixed in 4.1.15.
The behaviour changed only for have_innodb variable.
[1 Sep 2005 2:12] Paul DuBois
Noted in 4.1.15 changelog.

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

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