make the select from mysql.proc stable and independent from
previous operations on the table.

also, remove redundant drops.