#NEWLINE# def test_where_uncorrelated_subquery( self ) : #NEWLINE# #INDENT# expr = self . _case_where_uncorrelated_subquery ( ) #NEWLINE# result = to_sql ( expr ) #NEWLINE# expected = 'SELECT *\nFROM foo\nWHERE `job` IN (\n  SELECT `job`\n  FROM bar\n)' #NEWLINE# assert ( result == expected )