Bug #27603 Autocommit is not available in either SHOW STATUS or SHOW VARIABLES

Description:
Trying to view the status of the autocommit variable. It is not listed in either SHOW VARIABLES, SHOW STATUS, or SHOW GLOBAL STATUS. This is clearly a variable, because you can set it, and as such should appear along with all of the other variables in the SHOW VARIABLES report.

Being available by way of the query "SELECT @@autocommit;" does not count as it is a variable and should be in the SHOW VARIABLES report.

How to repeat:
Look at the output from SHOW VARIABLES, SHOW STATUS, or SHOW GLOBAL STATUS for the value of autocommit.

Suggested fix:
Add autocommit to the SHOW VARIABLES report.

This doesn't look like a documentation request to me. I've changed the bug category to Server:Parser.

The problem described in this bug report is true for pretty much every session-only variable. Try to use SHOW to get any of the variables listed here:

http://dev.mysql.com/doc/refman/5.0/en/set-option.html

I can't repeat it:
mysql> show session variables like '%autocommit%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| autocommit    | ON    | 
+---------------+-------+
1 row in set (0.00 sec)

mysql> select @@version;
+--------------------------------+
| @@version                      |
+--------------------------------+
| 6.0.8-alpha-valgrind-max-debug | 
+--------------------------------+
1 row in set (0.00 sec)

This is implemented in MySQL 5.1 already:

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.1.39-community |
+------------------+
1 row in set (0.00 sec)

mysql> show session variables like '%auto%';
+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| auto_increment_increment    | 1     |
| auto_increment_offset       | 1     |
| autocommit                  | ON    |
| automatic_sp_privileges     | ON    |
| innodb_autoextend_increment | 8     |
| innodb_autoinc_lock_mode    | 1     |
| sql_auto_is_null            | ON    |
+-----------------------------+-------+
7 rows in set (0.00 sec)