#NEWLINE# @ testing . requires . intersect #NEWLINE# def test_composite_alias( self ) : #NEWLINE# #INDENT# ua = intersect ( select ( [ t2 . c . col3 , t2 . c . col4 ] ) , union ( select ( [ t1 . c . col3 , t1 . c . col4 ] ) , select ( [ t2 . c . col3 , t2 . c . col4 ] ) , select ( [ t3 . c . col3 , t3 . c . col4 ] ) ) . alias ( ) . select ( ) ) . alias ( ) #NEWLINE# wanted = [ ( 'aaa' , 'bbb' ) , ( 'bbb' , 'ccc' ) , ( 'ccc' , 'aaa' ) ] #NEWLINE# found = self . _fetchall_sorted ( ua . select ( ) . execute ( ) ) #NEWLINE# eq_ ( self , wanted )