#NEWLINE# def test_union( self ) : #NEWLINE# #INDENT# union1 = self . _case_union ( ) #NEWLINE# result = to_sql ( union1 ) #NEWLINE# expected = 'SELECT `string_col` AS `key`, CAST(`float_col` AS double) AS `value`\nFROM functional_alltypes\nWHERE `int_col` > 0\nUNION ALL\nSELECT `string_col` AS `key`, `double_col` AS `value`\nFROM functional_alltypes\nWHERE `int_col` <= 0' #NEWLINE# assert ( result == expected )