DRILL-738: Add test for left, right and replace function from sql