#NEWLINE# def test_join_projection_subquery_broken_alias( self ) : #NEWLINE# #INDENT# expr = self . _case_join_projection_subquery_bug ( ) #NEWLINE# result = to_sql ( expr ) #NEWLINE# expected = 'SELECT t1.*, t0.*\nFROM (\n  SELECT t2.`n_nationkey`, t2.`n_name` AS `nation`, t3.`r_name` AS `region`\n  FROM nation t2\n    INNER JOIN region t3\n      ON t2.`n_regionkey` = t3.`r_regionkey`\n) t0\n  INNER JOIN customer t1\n    ON t0.`n_nationkey` = t1.`c_nationkey`' #NEWLINE# assert ( result == expected )