Bug #40988 log_output_basic.test succeeded though syntactically false.

• Submitted: 24 Nov 2008 17:25
• Modified: 23 Apr 2010 1:51
• Reporter: Horst Hunger
• Status: Closed
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.1.30, 6.0.7, 6.0.9-alpha-debug
• OS: Linux (suse-linux-gnu on i686)
• CPU Architecture: Any
• Tags: disabled

[24 Nov 2008 17:25] Horst Hunger

Description:
Though SET @@global.log_output = ', '; is not correct, the statement secceeded.

main.log_output_basic          [ fail ]

mysqltest: At line 136: query 'SET @@global.log_output = ', '' succeeded - should have failed with errno 1231...

The result from queries just before the failure was:
< snip >
SET @@global.log_output = 'TABLE,,FILE,,,';
SELECT @@global.log_output;
@@global.log_output
FILE,TABLE
'#--------------------FN_DYNVARS_065_04-------------------------#'
SET @@global.log_output = -1;
ERROR 42000: Variable 'log_output' can't be set to the value of '-1'
SET @@global.log_output = TAB;
ERROR 42000: Variable 'log_output' can't be set to the value of 'TAB'
SET @@global.log_output = NIL;
ERROR 42000: Variable 'log_output' can't be set to the value of 'NIL'
SET @@global.log_output = 'FIL';
ERROR 42000: Variable 'log_output' can't be set to the value of 'FIL'
SET @@global.log_output = 'T';
ERROR 42000: Variable 'log_output' can't be set to the value of 'T'
SET @@global.log_output = 'TABLE, FILE';
ERROR 42000: Variable 'log_output' can't be set to the value of ' FILE'
SET @@global.log_output = ' TABLE,FILE';
ERROR 42000: Variable 'log_output' can't be set to the value of ' TABLE'
SET @@global.log_output = ', ';

More results from queries before failure can be found in /work/bzr/mysql-6.0-bug/mysql-test/var/log/log_output_basic.log

How to repeat:
./mtr log_output_basic

[24 Nov 2008 19:20] Valeriy Kravchuk

Thank you for a bug report. Verified just as described, also with 5.1.30:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -proot -P3310 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.30-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SET @@global.log_output = ', ';
Query OK, 0 rows affected (0.02 sec)

Manual (http://dev.mysql.com/doc/refman/5.1/en/server-options.html) clearly says:

"The option value can be given as one or more of the words TABLE, FILE, or NONE."

[6 Mar 2010 11:00] Bugs System

Pushed into 5.5.3-m3 (revid:[e-mail]-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@fedora12-20091225154921-x25a5pyw1pxiwobv) (merge vers: 5.5.99) (pib:16)

[23 Apr 2010 1:51] Paul DuBois

Noted in 5.5.3 changelog.

System variables could be set to invalid values.