MySQL Bugs: #40988: log_output_basic.test succeeded though syntactically false.

Bug #40988	log_output_basic.test succeeded though syntactically false.
Submitted:	24 Nov 2008 18:25	Modified:	13 Nov 10:42
Reporter:	Horst Hunger
Status:	Patch pending
Category:	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)
Assigned to:	Sergei Golubchik	Target Version:
Tags:	disabled
Triage:	Triaged: D2 (Serious)

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

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."