fixed bug in IN/ALL/ANY subqeries with HAVING clause (BUG#9350)

into sanja.is.com.ua:/home/bell/mysql/bk/work-4.1

into mysql.com:/home/bkroot/mysql-4.1

into mysql.com:/home/bkroot/mysql-4.1

not always correct for NULL values.
Now they always result a non NULL value even
the argument is NULL. It is more usefull for 
debugging purposes.

fixed result_field support of Item_ref

into mysql.com:/home/bkroot/mysql-4.1

into mysql.com:/home/bkroot/mysql-4.1

into mysql.com:/usr/home/bar/mysql-4.1-bug8785

into mysql.com:/home/bkroot/mysql-4.1

into mysql.com:/usr/local/home/marty/MySQL/mysql-4.1

sql_show.cc:
  changed strdup to thd->memdup per Serg's advice

into mysql.com:/usr/local/home/marty/MySQL/mysql-4.1

into mdk10.(none):/home/reggie/bk/mysql-4.1

This is a modifiction of my previous patch after receiving feedback. This is a better way to fix the problem.  With this patch, data directory and index directory will use only forward slashes (/) when on Windows.

mysqldump.c:
  Removed fixPaths routine.  Was improper fix for bug #6660
sql_show.cc:
  Changed append_directory to convert backslashes to foward slashes when on Windows.

then this must be properly quoted when sent to 
SHOW TABLES LIKE ...

character set conversion of a string constant.

into hundin.mysql.fi:/home/marko/mysql-4.1

into mysql.com:/space/my/mysql-4.1

into mysql.com:/space/my/mysql-4.1-build

  "mysql-pro-gpl-cert" packages as well (thanks to Kent for the suggestion)

Applied some changes to the mysql.server init script that are already shipped as an additional patch
in the 4.1.10a RPMs for SLES9/RHEL3:

- small improvement: use LSB functions to display startup success and failure, if available.
  Fall back to more primitive builtin functions otherwise.
- joined two pieces of code performing the same functionality into one "wait_for_pid" function
- added a "reload" function (LSB requirement)

into mysql.com:/usr/home/ram/work/4.1.b8799

into hundin.mysql.fi:/home/marko/mysql-4.1

  Add diagnostics to track why ut_a(block->state == BUF_BLOCK_FILE_PAGE) failed in buf_flush_ready_for_replace() for a user

into mysql.com:/home/psergey/mysql-4.1-bug8510

into snake-hub.snake.net:/src/extern/MySQL/bk/mysql-4.1

into snake-hub.snake.net:/src/extern/MySQL/bk/merge-4.1

  Fix path that needs no parameterization.

into mysql.com:/home/psergey/mysql-4.1-bug8510

This really should not happen on Windows and part of the problem not fixed here is why show create table includes data directory when being run on Windows.  However, this patch fixes the bug in mysqldump.c

mysqldump.c:
  Added fixPaths function to convert \ to / in data directory and index directory entries only on Windows

"Access denied to database mysql" was actually not just misleading, but
also wrong.

Bug#7905.

 - Moved static variables defined inside of function to file scope to avoid this linking problem on FC3