mysql tests added ad valid_types fixed