NXP-14930 update sql directory unit test to switch on redis cache