MySQL Bugs: #56486: Even if "--console" is set the mysqld.err will be generated.

Bug #56486	Even if "--console" is set the mysqld.err will be generated.
Submitted:	2 Sep 2010 9:35	Modified:	7 Sep 2010 10:26
Reporter:	Horst Hunger	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Options	Severity:	S3 (Non-critical)
Version:	5.1-bugteam	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any

Description:
The sys_vars test "myisam_data_pointer_size_func" generates a table full error, which will be noticed in "mysqld.err". In case of giving "--console" in a corresponding -master.opt that should not more happen, instead the error should be written on the terminal. See user manual "5.2.2. The Error Log": 
...
If you do not specify --log-error, or (on Windows) if you use the --console option, errors are written to stderr, the standard error output. Usually this is your terminal.

On Windows, error output is always written to the .err file if --console is not given.
...
What happens with the file given in "--log_error", is it ignored? I haven't found one in "var".
This needs to be described better or what I would prefer better implemented, e.g. like it is working on Linux.

How to repeat:
Insert "--console" in "myisam_data_pointer_size_func-master.opt" and run the corresonding test in 5.1-bugteam.

Suggested fix:
Implement the behaviour of "--log_error" like it like it is working on Linux.

Thank you for the report.

Is it repeatable only with MTR?

I only tried it with mtr as my interest is to make the sys_vars test suite stable. But, as it is on the server side it should also be reproduced with e.g. mysql.exe and a started mysqld.exe having the mentioned option(s).

Thank you for the feedback.

This is not repeatable with mysqld itself. It is MTR who adds this option. So this is either not a bug or feature request for MTR "don't create error log file if --console is used". But in case of feature request I don't know how MTR should work if one calls 2 tests: one with --console option and another with default options.