#NEWLINE# def test_self_reference_in_not_exists( self ) : #NEWLINE# #INDENT# ( semi , anti ) = self . _case_self_reference_in_exists ( ) #NEWLINE# s1 = self . sa_alltypes . alias ( 't0' ) #NEWLINE# s2 = self . sa_alltypes . alias ( 't1' ) #NEWLINE# cond = sa . exists ( [ L ( 1 ) ] ) . select_from ( s1 ) . where ( ( s1 . c . string_col == s2 . c . string_col ) ) #NEWLINE# ex_semi = sa . select ( [ s1 ] ) . where ( cond ) #NEWLINE# ex_anti = sa . select ( [ s1 ] ) . where ( ( ~ cond ) ) #NEWLINE# self . _compare_sqla ( ex_anti , ex_semi ) #NEWLINE# self . _compare_sqla ( anti , ex_anti )