#NEWLINE# @ testing . fails_on ( 'firebird' , 'FIXME: unknown' ) #NEWLINE# @ testing . fails_on ( 'mssql' , 'AVG produces an average as the original column type on mssql.' ) #NEWLINE# def test_aggregate_2( self ) : #NEWLINE# #INDENT# foo = self . tables . foo #NEWLINE# query = create_session ( ) . query ( func . avg ( foo . c . bar ) ) #NEWLINE# avg = query . filter ( ( foo . c . bar < 30 ) ) . one ( ) [ 0 ] #NEWLINE# eq_ ( float ( round ( avg , 1 ) ) , 14.5 )