fix(tests): avoid using df logical optimizer as possible (#240)

fix(tests): avoid using df logical optimizer as possible (#240) #679