Update tests and result files after running with new mysqltest that better detects problems with test files

(Needed for "list of pushes" web page and autopush)

Cleanup the sideeffects from most of the  testcases with sideeffects.

to be in the query cache. (BUG#14652)

 - Packets out of order when reading cached data stored by a normal select from a ps or vice versa.
 - Add pkt_nr to query cache flags 

notembedded-specific part moved to the new test

temporary tables of subquery in the from clause just skipped during processing QC tables (BUG#11522)

function".

We should not cache queries using CURRENT_USER() function as we do it
for some other functions, e.g. USER() function.

in the query cache. (Bug #9549)

administrative statements that may alter the table, such
as REPAIR TABLE. (Bug #8480)

  added syntax:
  'show variables where', 'show status where', 'show open tables where'

fixed linking query_prealloc_size to query cache presence

Fixed output from mysqlbinlog when using --skip-comments
Fixed warnings from valgrind
Fixed ref_length when used with HEAP tables
More efficent need_conversion()
Fixed error handling in UPDATE with not updateable tables
Fixed bug in null handling in CAST to signed/unsigned

Deprecate the use of TYPE=... Preferred syntax is ENGINE=

added code covarage for functions convert(), nullif(), crc32(), is_used_lock(), char_lengtrh(), bit_xor()
added string length for more speed
made code covarage for print() method of Item
fixed printability of some items (SCRUM) (WL#1274)

  Character set variables test

removed server options

Move test that uses many tables (in query_cache.test) to separate test so that we can get it 'skipped' instead of 'failed' on system where we can't open many files.

removed unused field (now it is in variables)

Tests cleanup (put drop database first in tests)