Changes for the second 1/3 of dlenevs review comments chunk 2.

Test fixes in partition_locking (including in moving out tests to
partition_default_functions.inc)

Removed duplicate warnings from insert pruning.

warns if PARTITION () clause is used on temporary tables.

Fixed default functions in insert pruning.

+ some cleanups