@pytest.mark.parametrize('sep', [None, ' sep '])
def test_str_cat(sep):
 if (sep is None):
  expr = t_str_cat.name.str_cat(t_str_cat.comment)
  expected = '\n                   SELECT accounts2.name || accounts2.comment\n                   AS anon_1 FROM accounts2\n                   '
 else:
  expr = t_str_cat.name.str_cat(t_str_cat.comment, sep=sep)
  expected = '\n                   SELECT accounts2.name || :name_1 || accounts2.comment\n                   AS anon_1 FROM accounts2\n                   '
 result = str(compute(expr, s_str_cat, return_type='native'))
 assert (normalize(result) == normalize(expected))

@ pytest . mark . parametrize ( 'sep' , [ None , ' sep ' ] ) def test_str_cat ( sep ) : if ( sep is None ) : expr = t_str_cat . name . str_cat ( t_str_cat . comment ) expected = '\n                   SELECT accounts2.name || accounts2.comment\n                   AS anon_1 FROM accounts2\n                   ' else : expr = t_str_cat . name . str_cat ( t_str_cat . comment , sep = sep ) expected = '\n                   SELECT accounts2.name || :name_1 || accounts2.comment\n                   AS anon_1 FROM accounts2\n                   ' result = str ( compute ( expr , s_str_cat , return_type = 'native' ) ) assert ( normalize ( result ) == normalize ( expected ) )
need at least two string columns to test str_cat .