Bug #69284 mysqluc:show variables don't work on long names: ValueError: Sign not allowed in

• Submitted: 20 May 2013 3:25
• Modified: 11 Jul 2013 22:11
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Closed
• Category: MySQL Utilities
• Severity: S3 (Non-critical)
• Version: 1.3.1
• OS: Windows
• CPU Architecture: Any

[20 May 2013 3:25] Shane Bester

Description:
mysqluc> show variables

Traceback (most recent call last):
  File "C:\Python27\lib\site-packages\cx_Freeze\initscripts\Console.py", line 27, in <module>
  File "scripts\mysqluc.py", line 143, in <module>
  File ".\mysql\utilities\common\console.py", line 913, in run_console
  File ".\mysql\utilities\common\console.py", line 706, in _do_command
  File ".\mysql\utilities\common\variables.py", line 104, in show_variables
  File ".\mysql\utilities\common\format.py", line 235, in print_dictionary_list
ValueError: Sign not allowed in string format specifier

How to repeat:
mysqluc.exe aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa=1
show variables

Suggested fix:
if you want :)  i doubt anybody use such long variables anyway, or maybe cobol programmers might?

[11 Jul 2013 22:11] Philip Olson

Fixed as of MySQL Utilities 1.2.4/1.3.3, and here's the changelog entry:

Using long variables names in "mysqluc" would throw an unhandled exception
when executing "SHOW variables". The variable names are now truncated if
their width exceeds the maximum allowable width. 

Support for passing in multiple variables to the "mysqluc" utility was 
also fixed.

Thank you for the bug report.