turn on HA_PRIMARY_KEY_REQUIRED_FOR_POSITION