Bug #69918 Please add 'bit depth' to version string

• Submitted: 3 Aug 2013 10:47
• Modified: 3 Aug 2013 13:32
• Reporter: Peter Laursen (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: any
• OS: Windows
• CPU Architecture: Any

[3 Aug 2013 10:47] Peter Laursen

Description:
After experiencing this: http://bugs.mysql.com/bug.php?id=69917

.. it would be nice if the version string was exposed in 'version' server variable. 

How to repeat:
select version()
.. returns "5.5.33".

Suggested fix:
include bit-depth in version string like

"5.5.33 64 bit" or "5.5.33 x64"

[3 Aug 2013 12:26] MySQL Verification Team

Hello Peter,

Thank you for the feature request.
Since we have already "version" and "version_compile_machine" variables which could also provide the information which you are looking for.
For example:

mysql> SHOW VARIABLES WHERE Variable_Name LIKE 'version' OR Variable_Name LIKE '%compile%';
+-------------------------+----------------+
| Variable_name           | Value          |
+-------------------------+----------------+
| version                 | 5.6.13-log     |
| version_compile_machine | x86_64         |
| version_compile_os      | linux-glibc2.5 |
+-------------------------+----------------+
3 rows in set (0.00 sec)

// Or in SELECT statement:

mysql> select concat(@@global.version,'-',@@global.version_compile_machine) Version;
+-------------------+
| Version           |
+-------------------+
| 5.6.13-log-x86_64 |
+-------------------+
1 row in set (0.00 sec)

Thanks,
Umesh

[3 Aug 2013 13:32] Peter Laursen

OK .. not aware of that.

version_compile_os does the trick. So that is fine.  Closing!