bringing sql test up to date