added range conditions test and sql test, ref #90