Bug #9613 Some read-only variables are selectable, others are not
Submitted: 4 Apr 2005 16:18 Modified: 1 Sep 2005 4:12
Reporter: Victoria Reznichenko
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.1 OS:Any (any)
Assigned to: Ramil Kalimullin Target Version:

[4 Apr 2005 16: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 17: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 10: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 15:14] Ramil Kalimullin 
Fixed in 4.1.15.
The behaviour changed only for have_innodb variable.
[1 Sep 2005 4:12] Paul DuBois 
Noted in 4.1.15 changelog.