Bug #52565 _ and - interchangeable for variables/options, though not everywhere
| Submitted: | 2 Apr 2010 22:36 | Modified: | 6 Apr 2010 4:40 |
|---|---|---|---|
| Reporter: | Roel Van de Paar | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | 5.0+ | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[2 Apr 2010 22:36]
Roel Van de Paar
[5 Apr 2010 20:21]
Roel Van de Paar
The issue is this: mysql> show global variables like 'log-warnings'; Empty set (0.00 sec)
[6 Apr 2010 4:40]
Valeriy Kravchuk
I can agree with this as a feature request for SHOW VARIABLES to "normalize" variable name and check for '_' even when user asks for '-'. Still, there is a workaround: mysql> show variables like 'log%warnings%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | log_warnings | 1 | +---------------+-------+ 1 row in set (0.00 sec)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.040 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.