components/python/sqlparse/test/results-all.master

   1 ============================= test session starts ==============================
   2 platform sunos5 -- Python $(PYTHON_VERSION).X -- $(PYTHON)
   3 cachedir: .pytest_cache
   4 rootdir: $(@D)
   5 configfile: pyproject.toml
   6 collecting ... collected 464 items
   7
   8 tests/test_cli.py::test_cli_main_empty PASSED
   9 tests/test_cli.py::test_parser_empty PASSED
  10 tests/test_cli.py::test_main_help PASSED
  11 tests/test_cli.py::test_valid_args PASSED
  12 tests/test_cli.py::test_invalid_choice PASSED
  13 tests/test_cli.py::test_invalid_args PASSED
  14 tests/test_cli.py::test_invalid_infile PASSED
  15 tests/test_cli.py::test_invalid_outfile PASSED
  16 tests/test_cli.py::test_stdout PASSED
  17 tests/test_cli.py::test_script PASSED
  18 tests/test_cli.py::test_encoding_stdout[encoding_utf8.sql-utf-8] PASSED
  19 tests/test_cli.py::test_encoding_stdout[encoding_gbk.sql-gbk] PASSED
  20 tests/test_cli.py::test_encoding_output_file[encoding_utf8.sql-utf-8] PASSED
  21 tests/test_cli.py::test_encoding_output_file[encoding_gbk.sql-gbk] PASSED
  22 tests/test_cli.py::test_encoding_stdin[encoding_utf8.sql-utf-8] PASSED
  23 tests/test_cli.py::test_encoding_stdin[encoding_gbk.sql-gbk] PASSED
  24 tests/test_cli.py::test_encoding PASSED
  25 tests/test_format.py::TestFormat::test_keywordcase PASSED
  26 tests/test_format.py::TestFormat::test_keywordcase_invalid_option PASSED
  27 tests/test_format.py::TestFormat::test_identifiercase PASSED
  28 tests/test_format.py::TestFormat::test_identifiercase_invalid_option PASSED
  29 tests/test_format.py::TestFormat::test_identifiercase_quotes PASSED
  30 tests/test_format.py::TestFormat::test_strip_comments_single PASSED
  31 tests/test_format.py::TestFormat::test_strip_comments_invalid_option PASSED
  32 tests/test_format.py::TestFormat::test_strip_comments_multi PASSED
  33 tests/test_format.py::TestFormat::test_strip_comments_preserves_linebreak PASSED
  34 tests/test_format.py::TestFormat::test_strip_comments_preserves_whitespace PASSED
  35 tests/test_format.py::TestFormat::test_strip_comments_preserves_hint PASSED
  36 tests/test_format.py::TestFormat::test_strip_ws PASSED
  37 tests/test_format.py::TestFormat::test_strip_ws_invalid_option PASSED
  38 tests/test_format.py::TestFormat::test_preserve_ws PASSED
  39 tests/test_format.py::TestFormat::test_notransform_of_quoted_crlf PASSED
  40 tests/test_format.py::TestFormatReindentAligned::test_basic PASSED
  41 tests/test_format.py::TestFormatReindentAligned::test_joins PASSED
  42 tests/test_format.py::TestFormatReindentAligned::test_case_statement PASSED
  43 tests/test_format.py::TestFormatReindentAligned::test_case_statement_with_between PASSED
  44 tests/test_format.py::TestFormatReindentAligned::test_group_by PASSED
  45 tests/test_format.py::TestFormatReindentAligned::test_group_by_subquery PASSED
  46 tests/test_format.py::TestFormatReindentAligned::test_window_functions PASSED
  47 tests/test_format.py::TestSpacesAroundOperators::test_basic PASSED
  48 tests/test_format.py::TestSpacesAroundOperators::test_bools PASSED
  49 tests/test_format.py::TestSpacesAroundOperators::test_nested PASSED
  50 tests/test_format.py::TestSpacesAroundOperators::test_wildcard_vs_mult PASSED
  51 tests/test_format.py::TestFormatReindent::test_option PASSED
  52 tests/test_format.py::TestFormatReindent::test_stmts PASSED
  53 tests/test_format.py::TestFormatReindent::test_keywords PASSED
  54 tests/test_format.py::TestFormatReindent::test_keywords_between PASSED
  55 tests/test_format.py::TestFormatReindent::test_parenthesis PASSED
  56 tests/test_format.py::TestFormatReindent::test_where PASSED
  57 tests/test_format.py::TestFormatReindent::test_join PASSED
  58 tests/test_format.py::TestFormatReindent::test_identifier_list PASSED
  59 tests/test_format.py::TestFormatReindent::test_identifier_list_with_wrap_after PASSED
  60 tests/test_format.py::TestFormatReindent::test_identifier_list_comment_first PASSED
  61 tests/test_format.py::TestFormatReindent::test_identifier_list_with_functions PASSED
  62 tests/test_format.py::TestFormatReindent::test_long_identifier_list_with_functions PASSED
  63 tests/test_format.py::TestFormatReindent::test_case PASSED
  64 tests/test_format.py::TestFormatReindent::test_case2 PASSED
  65 tests/test_format.py::TestFormatReindent::test_nested_identifier_list PASSED
  66 tests/test_format.py::TestFormatReindent::test_duplicate_linebreaks PASSED
  67 tests/test_format.py::TestFormatReindent::test_keywordfunctions PASSED
  68 tests/test_format.py::TestFormatReindent::test_identifier_and_functions PASSED
  69 tests/test_format.py::TestFormatReindent::test_insert_values PASSED
  70 tests/test_format.py::TestOutputFormat::test_python PASSED
  71 tests/test_format.py::TestOutputFormat::test_python_multiple_statements PASSED
  72 tests/test_format.py::TestOutputFormat::test_python_multiple_statements_with_formatting XFAIL
  73 tests/test_format.py::TestOutputFormat::test_php PASSED
  74 tests/test_format.py::TestOutputFormat::test_sql PASSED
  75 tests/test_format.py::TestOutputFormat::test_invalid_option PASSED
  76 tests/test_format.py::test_format_column_ordering PASSED
  77 tests/test_format.py::test_truncate_strings PASSED
  78 tests/test_format.py::test_truncate_strings_invalid_option2[bar] PASSED
  79 tests/test_format.py::test_truncate_strings_invalid_option2[-1] PASSED
  80 tests/test_format.py::test_truncate_strings_invalid_option2[0] PASSED
  81 tests/test_format.py::test_truncate_strings_doesnt_truncate_identifiers[select verrrylongcolumn from foo] PASSED
  82 tests/test_format.py::test_truncate_strings_doesnt_truncate_identifiers[select "verrrylongcolumn" from "foo"] PASSED
  83 tests/test_format.py::test_having_produces_newline PASSED
  84 tests/test_format.py::test_format_right_margin_invalid_option[ten] PASSED
  85 tests/test_format.py::test_format_right_margin_invalid_option[2] PASSED
  86 tests/test_format.py::test_format_right_margin XFAIL (Needs fixing)
  87 tests/test_format.py::test_format_json_ops PASSED
  88 tests/test_format.py::test_compact[case when foo then 1 else bar end-case\n    when foo then 1\n    else bar\nend-case when foo then 1 else bar end] PASSED
  89 tests/test_format.py::test_strip_ws_removes_trailing_ws_in_groups PASSED
  90 tests/test_grouping.py::test_grouping_parenthesis PASSED
  91 tests/test_grouping.py::test_grouping_assignment[foo := 1;] PASSED
  92 tests/test_grouping.py::test_grouping_assignment[foo := 1] PASSED
  93 tests/test_grouping.py::test_grouping_typed_literal[x > DATE '2020-01-01'] PASSED
  94 tests/test_grouping.py::test_grouping_typed_literal[x > TIMESTAMP '2020-01-01 00:00:00'] PASSED
  95 tests/test_grouping.py::test_compare_expr[select a from b where c < d + e-Identifier-Identifier] PASSED
  96 tests/test_grouping.py::test_compare_expr[select a from b where c < d + interval '1 day'-Identifier-TypedLiteral] PASSED
  97 tests/test_grouping.py::test_compare_expr[select a from b where c < d + interval '6' month-Identifier-TypedLiteral] PASSED
  98 tests/test_grouping.py::test_compare_expr[select a from b where c < current_timestamp - interval '1 day'-Token-TypedLiteral] PASSED
  99 tests/test_grouping.py::test_grouping_identifiers PASSED
 100 tests/test_grouping.py::test_simple_identifiers[1 as f] PASSED
 101 tests/test_grouping.py::test_simple_identifiers[foo as f] PASSED
 102 tests/test_grouping.py::test_simple_identifiers[foo f] PASSED
 103 tests/test_grouping.py::test_simple_identifiers[1/2 as f] PASSED
 104 tests/test_grouping.py::test_simple_identifiers[1/2 f] PASSED
 105 tests/test_grouping.py::test_simple_identifiers[1<2 as f] PASSED
 106 tests/test_grouping.py::test_simple_identifiers[1<2 f] PASSED
 107 tests/test_grouping.py::test_group_identifier_list[foo, bar] PASSED
 108 tests/test_grouping.py::test_group_identifier_list[sum(a), sum(b)] PASSED
 109 tests/test_grouping.py::test_group_identifier_list[sum(a) as x, b as y] PASSED
 110 tests/test_grouping.py::test_group_identifier_list[sum(a)::integer, b] PASSED
 111 tests/test_grouping.py::test_group_identifier_list[sum(a)/count(b) as x, y] PASSED
 112 tests/test_grouping.py::test_group_identifier_list[sum(a)::integer as x, y] PASSED
 113 tests/test_grouping.py::test_group_identifier_list[sum(a)::integer/count(b) as x, y] PASSED
 114 tests/test_grouping.py::test_grouping_identifier_wildcard PASSED
 115 tests/test_grouping.py::test_grouping_identifier_name_wildcard PASSED
 116 tests/test_grouping.py::test_grouping_identifier_invalid PASSED
 117 tests/test_grouping.py::test_grouping_identifier_invalid_in_middle PASSED
 118 tests/test_grouping.py::test_grouping_identifer_as[foo as (select *)] PASSED
 119 tests/test_grouping.py::test_grouping_identifer_as[foo as(select *)] PASSED
 120 tests/test_grouping.py::test_grouping_identifier_as_invalid PASSED
 121 tests/test_grouping.py::test_grouping_identifier_function PASSED
 122 tests/test_grouping.py::test_grouping_operation[foo+100] PASSED
 123 tests/test_grouping.py::test_grouping_operation[foo + 100] PASSED
 124 tests/test_grouping.py::test_grouping_operation[foo*100] PASSED
 125 tests/test_grouping.py::test_grouping_identifier_list PASSED
 126 tests/test_grouping.py::test_grouping_identifier_list_subquery PASSED
 127 tests/test_grouping.py::test_grouping_identifier_list_case PASSED
 128 tests/test_grouping.py::test_grouping_identifier_list_other PASSED
 129 tests/test_grouping.py::test_grouping_identifier_list_with_inline_comments PASSED
 130 tests/test_grouping.py::test_grouping_identifiers_with_operators PASSED
 131 tests/test_grouping.py::test_grouping_identifier_list_with_order PASSED
 132 tests/test_grouping.py::test_grouping_nested_identifier_with_order PASSED
 133 tests/test_grouping.py::test_grouping_where PASSED
 134 tests/test_grouping.py::test_grouping_where_union[select 1 where 1 = 2 union select 2] PASSED
 135 tests/test_grouping.py::test_grouping_where_union[select 1 where 1 = 2 union all select 2] PASSED
 136 tests/test_grouping.py::test_returning_kw_ends_where_clause PASSED
 137 tests/test_grouping.py::test_into_kw_ends_where_clause PASSED
 138 tests/test_grouping.py::test_grouping_typecast[select foo::integer from bar-integer] PASSED
 139 tests/test_grouping.py::test_grouping_typecast[select (current_database())::information_schema.sql_identifier-information_schema.sql_identifier] PASSED
 140 tests/test_grouping.py::test_grouping_alias PASSED
 141 tests/test_grouping.py::test_grouping_alias_case PASSED
 142 tests/test_grouping.py::test_grouping_alias_ctas PASSED
 143 tests/test_grouping.py::test_grouping_subquery_no_parens PASSED
 144 tests/test_grouping.py::test_grouping_alias_returns_none[foo.bar] PASSED
 145 tests/test_grouping.py::test_grouping_alias_returns_none[x, y] PASSED
 146 tests/test_grouping.py::test_grouping_alias_returns_none[x > y] PASSED
 147 tests/test_grouping.py::test_grouping_alias_returns_none[x / y] PASSED
 148 tests/test_grouping.py::test_grouping_idlist_function PASSED
 149 tests/test_grouping.py::test_grouping_comparison_exclude PASSED
 150 tests/test_grouping.py::test_grouping_function PASSED
 151 tests/test_grouping.py::test_grouping_function_not_in PASSED
 152 tests/test_grouping.py::test_grouping_varchar PASSED
 153 tests/test_grouping.py::test_statement_get_type PASSED
 154 tests/test_grouping.py::test_identifier_with_operators PASSED
 155 tests/test_grouping.py::test_identifier_with_op_trailing_ws PASSED
 156 tests/test_grouping.py::test_identifier_with_string_literals PASSED
 157 tests/test_grouping.py::test_identifier_consumes_ordering PASSED
 158 tests/test_grouping.py::test_comparison_with_keywords PASSED
 159 tests/test_grouping.py::test_comparison_with_floats PASSED
 160 tests/test_grouping.py::test_comparison_with_parenthesis PASSED
 161 tests/test_grouping.py::test_comparison_with_strings[=] PASSED
 162 tests/test_grouping.py::test_comparison_with_strings[!=] PASSED
 163 tests/test_grouping.py::test_comparison_with_strings[>] PASSED
 164 tests/test_grouping.py::test_comparison_with_strings[<] PASSED
 165 tests/test_grouping.py::test_comparison_with_strings[<=] PASSED
 166 tests/test_grouping.py::test_comparison_with_strings[>=] PASSED
 167 tests/test_grouping.py::test_comparison_with_strings[~] PASSED
 168 tests/test_grouping.py::test_comparison_with_strings[~~] PASSED
 169 tests/test_grouping.py::test_comparison_with_strings[!~~] PASSED
 170 tests/test_grouping.py::test_comparison_with_strings[LIKE] PASSED
 171 tests/test_grouping.py::test_comparison_with_strings[NOT LIKE] PASSED
 172 tests/test_grouping.py::test_comparison_with_strings[ILIKE] PASSED
 173 tests/test_grouping.py::test_comparison_with_strings[NOT ILIKE] PASSED
 174 tests/test_grouping.py::test_like_and_ilike_comparison PASSED
 175 tests/test_grouping.py::test_comparison_with_functions PASSED
 176 tests/test_grouping.py::test_comparison_with_typed_literal PASSED
 177 tests/test_grouping.py::test_forloops[FOR] PASSED
 178 tests/test_grouping.py::test_forloops[FOREACH] PASSED
 179 tests/test_grouping.py::test_nested_for PASSED
 180 tests/test_grouping.py::test_begin PASSED
 181 tests/test_grouping.py::test_keyword_followed_by_parenthesis PASSED
 182 tests/test_grouping.py::test_nested_begin PASSED
 183 tests/test_grouping.py::test_aliased_column_without_as PASSED
 184 tests/test_grouping.py::test_qualified_function PASSED
 185 tests/test_grouping.py::test_aliased_function_without_as PASSED
 186 tests/test_grouping.py::test_aliased_literal_without_as PASSED
 187 tests/test_grouping.py::test_grouping_as_cte PASSED
 188 tests/test_grouping.py::test_grouping_create_table PASSED
 189 tests/test_keywords.py::TestSQLREGEX::test_float_numbers[1.0] PASSED
 190 tests/test_keywords.py::TestSQLREGEX::test_float_numbers[-1.0] PASSED
 191 tests/test_keywords.py::TestSQLREGEX::test_float_numbers[1.] PASSED
 192 tests/test_keywords.py::TestSQLREGEX::test_float_numbers[-1.] PASSED
 193 tests/test_keywords.py::TestSQLREGEX::test_float_numbers[.1] PASSED
 194 tests/test_keywords.py::TestSQLREGEX::test_float_numbers[-.1] PASSED
 195 tests/test_parse.py::test_parse_tokenize PASSED
 196 tests/test_parse.py::test_parse_multistatement PASSED
 197 tests/test_parse.py::test_parse_newlines[select\n*from foo;] PASSED
 198 tests/test_parse.py::test_parse_newlines[select\r\n*from foo] PASSED
 199 tests/test_parse.py::test_parse_newlines[select\r*from foo] PASSED
 200 tests/test_parse.py::test_parse_newlines[select\r\n*from foo\n] PASSED
 201 tests/test_parse.py::test_parse_within PASSED
 202 tests/test_parse.py::test_parse_child_of PASSED
 203 tests/test_parse.py::test_parse_has_ancestor PASSED
 204 tests/test_parse.py::test_parse_float[.5] PASSED
 205 tests/test_parse.py::test_parse_float[.51] PASSED
 206 tests/test_parse.py::test_parse_float[1.5] PASSED
 207 tests/test_parse.py::test_parse_float[12.5] PASSED
 208 tests/test_parse.py::test_parse_placeholder[select * from foo where user = ?-?] PASSED
 209 tests/test_parse.py::test_parse_placeholder[select * from foo where user = :1-:1] PASSED
 210 tests/test_parse.py::test_parse_placeholder[select * from foo where user = :name-:name] PASSED
 211 tests/test_parse.py::test_parse_placeholder[select * from foo where user = %s-%s] PASSED
 212 tests/test_parse.py::test_parse_placeholder[select * from foo where user = $a-$a] PASSED
 213 tests/test_parse.py::test_parse_modulo_not_placeholder PASSED
 214 tests/test_parse.py::test_parse_access_symbol PASSED
 215 tests/test_parse.py::test_parse_square_brackets_notation_isnt_too_greedy PASSED
 216 tests/test_parse.py::test_parse_square_brackets_notation_isnt_too_greedy2 PASSED
 217 tests/test_parse.py::test_parse_keyword_like_identifier PASSED
 218 tests/test_parse.py::test_parse_function_parameter PASSED
 219 tests/test_parse.py::test_parse_function_param_single_literal PASSED
 220 tests/test_parse.py::test_parse_nested_function PASSED
 221 tests/test_parse.py::test_parse_casted_params PASSED
 222 tests/test_parse.py::test_parse_div_operator PASSED
 223 tests/test_parse.py::test_quoted_identifier PASSED
 224 tests/test_parse.py::test_valid_identifier_names[foo] PASSED
 225 tests/test_parse.py::test_valid_identifier_names[_foo] PASSED
 226 tests/test_parse.py::test_valid_identifier_names[1_data] PASSED
 227 tests/test_parse.py::test_valid_identifier_names[\u696d\u8005\u540d\u7a31] PASSED
 228 tests/test_parse.py::test_psql_quotation_marks PASSED
 229 tests/test_parse.py::test_double_precision_is_builtin PASSED
 230 tests/test_parse.py::test_placeholder[?] PASSED
 231 tests/test_parse.py::test_placeholder[:1] PASSED
 232 tests/test_parse.py::test_placeholder[:foo] PASSED
 233 tests/test_parse.py::test_placeholder[%s] PASSED
 234 tests/test_parse.py::test_placeholder[%(foo)s] PASSED
 235 tests/test_parse.py::test_scientific_numbers[6.67428E-8-expected0] PASSED
 236 tests/test_parse.py::test_scientific_numbers[1.988e33-expected1] PASSED
 237 tests/test_parse.py::test_scientific_numbers[1e-12-expected2] PASSED
 238 tests/test_parse.py::test_scientific_numbers[e1-None] PASSED
 239 tests/test_parse.py::test_single_quotes_are_strings PASSED
 240 tests/test_parse.py::test_double_quotes_are_identifiers PASSED
 241 tests/test_parse.py::test_single_quotes_with_linebreaks PASSED
 242 tests/test_parse.py::test_sqlite_identifiers PASSED
 243 tests/test_parse.py::test_simple_1d_array_index PASSED
 244 tests/test_parse.py::test_2d_array_index PASSED
 245 tests/test_parse.py::test_array_index_function_result PASSED
 246 tests/test_parse.py::test_schema_qualified_array_index PASSED
 247 tests/test_parse.py::test_aliased_array_index PASSED
 248 tests/test_parse.py::test_array_literal PASSED
 249 tests/test_parse.py::test_typed_array_definition PASSED
 250 tests/test_parse.py::test_single_line_comments[select 1 -- foo] PASSED
 251 tests/test_parse.py::test_single_line_comments[select 1 # foo] PASSED
 252 tests/test_parse.py::test_names_and_special_names[foo] PASSED
 253 tests/test_parse.py::test_names_and_special_names[@foo] PASSED
 254 tests/test_parse.py::test_names_and_special_names[#foo] PASSED
 255 tests/test_parse.py::test_names_and_special_names[##foo] PASSED
 256 tests/test_parse.py::test_get_token_at_offset PASSED
 257 tests/test_parse.py::test_pprint PASSED
 258 tests/test_parse.py::test_wildcard_multiplication PASSED
 259 tests/test_parse.py::test_stmt_tokens_parents PASSED
 260 tests/test_parse.py::test_dbldollar_as_literal[$$foo$$-True] PASSED
 261 tests/test_parse.py::test_dbldollar_as_literal[$_$foo$_$-True] PASSED
 262 tests/test_parse.py::test_dbldollar_as_literal[$token$ foo $token$-True] PASSED
 263 tests/test_parse.py::test_dbldollar_as_literal[$_$ foo $token$bar$token$ baz$_$-True] PASSED
 264 tests/test_parse.py::test_dbldollar_as_literal[$A$ foo $B$-False] PASSED
 265 tests/test_parse.py::test_non_ascii PASSED
 266 tests/test_parse.py::test_get_real_name PASSED
 267 tests/test_parse.py::test_from_subquery PASSED
 268 tests/test_parse.py::test_parenthesis PASSED
 269 tests/test_parse.py::test_configurable_keywords PASSED
 270 tests/test_parse.py::test_configurable_regex PASSED
 271 tests/test_parse.py::test_json_operators[->] PASSED
 272 tests/test_parse.py::test_json_operators[->>] PASSED
 273 tests/test_parse.py::test_json_operators[#>] PASSED
 274 tests/test_parse.py::test_json_operators[#>>] PASSED
 275 tests/test_parse.py::test_json_operators[@>] PASSED
 276 tests/test_parse.py::test_json_operators[<@] PASSED
 277 tests/test_parse.py::test_json_operators[||] PASSED
 278 tests/test_parse.py::test_json_operators[-] PASSED
 279 tests/test_parse.py::test_json_operators[#-] PASSED
 280 tests/test_regressions.py::test_issue9 PASSED
 281 tests/test_regressions.py::test_issue13 PASSED
 282 tests/test_regressions.py::test_issue26[--hello] PASSED
 283 tests/test_regressions.py::test_issue26[-- hello] PASSED
 284 tests/test_regressions.py::test_issue26[--hello\n] PASSED
 285 tests/test_regressions.py::test_issue26[--] PASSED
 286 tests/test_regressions.py::test_issue26[--\n] PASSED
 287 tests/test_regressions.py::test_issue34[create] PASSED
 288 tests/test_regressions.py::test_issue34[CREATE] PASSED
 289 tests/test_regressions.py::test_issue35 PASSED
 290 tests/test_regressions.py::test_issue38 PASSED
 291 tests/test_regressions.py::test_issue39 PASSED
 292 tests/test_regressions.py::test_issue40 PASSED
 293 tests/test_regressions.py::test_issue78[get_name-z-select x.y::text as z from foo] PASSED
 294 tests/test_regressions.py::test_issue78[get_name-z-select x.y::text as "z" from foo] PASSED
 295 tests/test_regressions.py::test_issue78[get_name-z-select x."y"::text as z from foo] PASSED
 296 tests/test_regressions.py::test_issue78[get_name-z-select x."y"::text as "z" from foo] PASSED
 297 tests/test_regressions.py::test_issue78[get_name-z-select "x".y::text as z from foo] PASSED
 298 tests/test_regressions.py::test_issue78[get_name-z-select "x".y::text as "z" from foo] PASSED
 299 tests/test_regressions.py::test_issue78[get_name-z-select "x"."y"::text as z from foo] PASSED
 300 tests/test_regressions.py::test_issue78[get_name-z-select "x"."y"::text as "z" from foo] PASSED
 301 tests/test_regressions.py::test_issue78[get_real_name-y-select x.y::text as z from foo] PASSED
 302 tests/test_regressions.py::test_issue78[get_real_name-y-select x.y::text as "z" from foo] PASSED
 303 tests/test_regressions.py::test_issue78[get_real_name-y-select x."y"::text as z from foo] PASSED
 304 tests/test_regressions.py::test_issue78[get_real_name-y-select x."y"::text as "z" from foo] PASSED
 305 tests/test_regressions.py::test_issue78[get_real_name-y-select "x".y::text as z from foo] PASSED
 306 tests/test_regressions.py::test_issue78[get_real_name-y-select "x".y::text as "z" from foo] PASSED
 307 tests/test_regressions.py::test_issue78[get_real_name-y-select "x"."y"::text as z from foo] PASSED
 308 tests/test_regressions.py::test_issue78[get_real_name-y-select "x"."y"::text as "z" from foo] PASSED
 309 tests/test_regressions.py::test_issue78[get_parent_name-x-select x.y::text as z from foo] PASSED
 310 tests/test_regressions.py::test_issue78[get_parent_name-x-select x.y::text as "z" from foo] PASSED
 311 tests/test_regressions.py::test_issue78[get_parent_name-x-select x."y"::text as z from foo] PASSED
 312 tests/test_regressions.py::test_issue78[get_parent_name-x-select x."y"::text as "z" from foo] PASSED
 313 tests/test_regressions.py::test_issue78[get_parent_name-x-select "x".y::text as z from foo] PASSED
 314 tests/test_regressions.py::test_issue78[get_parent_name-x-select "x".y::text as "z" from foo] PASSED
 315 tests/test_regressions.py::test_issue78[get_parent_name-x-select "x"."y"::text as z from foo] PASSED
 316 tests/test_regressions.py::test_issue78[get_parent_name-x-select "x"."y"::text as "z" from foo] PASSED
 317 tests/test_regressions.py::test_issue78[get_alias-z-select x.y::text as z from foo] PASSED
 318 tests/test_regressions.py::test_issue78[get_alias-z-select x.y::text as "z" from foo] PASSED
 319 tests/test_regressions.py::test_issue78[get_alias-z-select x."y"::text as z from foo] PASSED
 320 tests/test_regressions.py::test_issue78[get_alias-z-select x."y"::text as "z" from foo] PASSED
 321 tests/test_regressions.py::test_issue78[get_alias-z-select "x".y::text as z from foo] PASSED
 322 tests/test_regressions.py::test_issue78[get_alias-z-select "x".y::text as "z" from foo] PASSED
 323 tests/test_regressions.py::test_issue78[get_alias-z-select "x"."y"::text as z from foo] PASSED
 324 tests/test_regressions.py::test_issue78[get_alias-z-select "x"."y"::text as "z" from foo] PASSED
 325 tests/test_regressions.py::test_issue78[get_typecast-text-select x.y::text as z from foo] PASSED
 326 tests/test_regressions.py::test_issue78[get_typecast-text-select x.y::text as "z" from foo] PASSED
 327 tests/test_regressions.py::test_issue78[get_typecast-text-select x."y"::text as z from foo] PASSED
 328 tests/test_regressions.py::test_issue78[get_typecast-text-select x."y"::text as "z" from foo] PASSED
 329 tests/test_regressions.py::test_issue78[get_typecast-text-select "x".y::text as z from foo] PASSED
 330 tests/test_regressions.py::test_issue78[get_typecast-text-select "x".y::text as "z" from foo] PASSED
 331 tests/test_regressions.py::test_issue78[get_typecast-text-select "x"."y"::text as z from foo] PASSED
 332 tests/test_regressions.py::test_issue78[get_typecast-text-select "x"."y"::text as "z" from foo] PASSED
 333 tests/test_regressions.py::test_issue83 PASSED
 334 tests/test_regressions.py::test_comment_encoding_when_reindent PASSED
 335 tests/test_regressions.py::test_parse_sql_with_binary PASSED
 336 tests/test_regressions.py::test_dont_alias_keywords PASSED
 337 tests/test_regressions.py::test_format_accepts_encoding PASSED
 338 tests/test_regressions.py::test_stream PASSED
 339 tests/test_regressions.py::test_issue90 PASSED
 340 tests/test_regressions.py::test_except_formatting PASSED
 341 tests/test_regressions.py::test_null_with_as PASSED
 342 tests/test_regressions.py::test_issue190_open_file PASSED
 343 tests/test_regressions.py::test_issue193_splitting_function PASSED
 344 tests/test_regressions.py::test_issue194_splitting_function PASSED
 345 tests/test_regressions.py::test_issue186_get_type PASSED
 346 tests/test_regressions.py::test_issue212_py2unicode PASSED
 347 tests/test_regressions.py::test_issue213_leadingws PASSED
 348 tests/test_regressions.py::test_issue227_gettype_cte PASSED
 349 tests/test_regressions.py::test_issue207_runaway_format PASSED
 350 tests/test_regressions.py::test_token_next_doesnt_ignore_skip_cm PASSED
 351 tests/test_regressions.py::test_issue284_as_grouping[SELECT x AS] PASSED
 352 tests/test_regressions.py::test_issue284_as_grouping[AS] PASSED
 353 tests/test_regressions.py::test_issue315_utf8_by_default PASSED
 354 tests/test_regressions.py::test_issue322_concurrently_is_keyword PASSED
 355 tests/test_regressions.py::test_issue359_index_error_assignments[SELECT @min_price:=MIN(price), @max_price:=MAX(price) FROM shop;] PASSED
 356 tests/test_regressions.py::test_issue359_index_error_assignments[SELECT @min_price:=MIN(price), @max_price:=MAX(price) FROM shop] PASSED
 357 tests/test_regressions.py::test_issue469_copy_as_psql_command PASSED
 358 tests/test_regressions.py::test_issue484_comments_and_newlines XPASS
 359 tests/test_regressions.py::test_issue485_split_multi PASSED
 360 tests/test_regressions.py::test_issue489_tzcasts PASSED
 361 tests/test_regressions.py::test_issue562_tzcasts PASSED
 362 tests/test_regressions.py::test_as_in_parentheses_indents PASSED
 363 tests/test_regressions.py::test_format_invalid_where_clause PASSED
 364 tests/test_regressions.py::test_splitting_at_and_backticks_issue588 PASSED
 365 tests/test_regressions.py::test_comment_between_cte_clauses_issue632 PASSED
 366 tests/test_regressions.py::test_copy_issue672 PASSED
 367 tests/test_regressions.py::test_primary_key_issue740 PASSED
 368 tests/test_regressions.py::test_max_recursion PASSED
 369 tests/test_split.py::test_split_semicolon PASSED
 370 tests/test_split.py::test_split_backslash PASSED
 371 tests/test_split.py::test_split_create_function[function.sql] PASSED
 372 tests/test_split.py::test_split_create_function[function_psql.sql] PASSED
 373 tests/test_split.py::test_split_create_function[function_psql2.sql] PASSED
 374 tests/test_split.py::test_split_create_function[function_psql3.sql] PASSED
 375 tests/test_split.py::test_split_create_function[function_psql4.sql] PASSED
 376 tests/test_split.py::test_split_dashcomments PASSED
 377 tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment\n] PASSED
 378 tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment\r] PASSED
 379 tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment\r\n] PASSED
 380 tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment] PASSED
 381 tests/test_split.py::test_split_begintag PASSED
 382 tests/test_split.py::test_split_begintag_2 PASSED
 383 tests/test_split.py::test_split_dropif PASSED
 384 tests/test_split.py::test_split_comment_with_umlaut PASSED
 385 tests/test_split.py::test_split_comment_end_of_line PASSED
 386 tests/test_split.py::test_split_casewhen PASSED
 387 tests/test_split.py::test_split_casewhen_procedure PASSED
 388 tests/test_split.py::test_split_cursor_declare PASSED
 389 tests/test_split.py::test_split_if_function PASSED
 390 tests/test_split.py::test_split_stream PASSED
 391 tests/test_split.py::test_split_encoding_parsestream PASSED
 392 tests/test_split.py::test_split_unicode_parsestream PASSED
 393 tests/test_split.py::test_split_simple PASSED
 394 tests/test_split.py::test_split_ignores_empty_newlines PASSED
 395 tests/test_split.py::test_split_quotes_with_new_line PASSED
 396 tests/test_split.py::test_split_mysql_handler_for PASSED
 397 tests/test_split.py::test_split_strip_semicolon[select * from foo;-expected0] PASSED
 398 tests/test_split.py::test_split_strip_semicolon[select * from foo-expected1] PASSED
 399 tests/test_split.py::test_split_strip_semicolon[select * from foo; select * from bar;-expected2] PASSED
 400 tests/test_split.py::test_split_strip_semicolon[  select * from foo;\n\nselect * from bar;\n\n\n\n-expected3] PASSED
 401 tests/test_split.py::test_split_strip_semicolon[select * from foo\n\n;  bar-expected4] PASSED
 402 tests/test_split.py::test_split_strip_semicolon_procedure PASSED
 403 tests/test_split.py::test_split_go[USE foo;\nGO\nSELECT 1;\nGO-4] PASSED
 404 tests/test_split.py::test_split_go[SELECT * FROM foo;\nGO-2] PASSED
 405 tests/test_split.py::test_split_go[USE foo;\nGO 2\nSELECT 1;-3] PASSED
 406 tests/test_split.py::test_split_multiple_case_in_begin PASSED
 407 tests/test_tokenize.py::test_tokenize_simple PASSED
 408 tests/test_tokenize.py::test_tokenize_backticks PASSED
 409 tests/test_tokenize.py::test_tokenize_linebreaks[foo\nbar\n] PASSED
 410 tests/test_tokenize.py::test_tokenize_linebreaks[foo\rbar\r] PASSED
 411 tests/test_tokenize.py::test_tokenize_linebreaks[foo\r\nbar\r\n] PASSED
 412 tests/test_tokenize.py::test_tokenize_linebreaks[foo\r\nbar\n] PASSED
 413 tests/test_tokenize.py::test_tokenize_inline_keywords PASSED
 414 tests/test_tokenize.py::test_tokenize_negative_numbers PASSED
 415 tests/test_tokenize.py::test_token_str PASSED
 416 tests/test_tokenize.py::test_token_repr PASSED
 417 tests/test_tokenize.py::test_token_flatten PASSED
 418 tests/test_tokenize.py::test_tokenlist_repr PASSED
 419 tests/test_tokenize.py::test_single_quotes PASSED
 420 tests/test_tokenize.py::test_tokenlist_first PASSED
 421 tests/test_tokenize.py::test_tokenlist_token_matching PASSED
 422 tests/test_tokenize.py::test_stream_simple PASSED
 423 tests/test_tokenize.py::test_stream_error PASSED
 424 tests/test_tokenize.py::test_parse_join[JOIN] PASSED
 425 tests/test_tokenize.py::test_parse_join[LEFT JOIN] PASSED
 426 tests/test_tokenize.py::test_parse_join[LEFT OUTER JOIN] PASSED
 427 tests/test_tokenize.py::test_parse_join[FULL OUTER JOIN] PASSED
 428 tests/test_tokenize.py::test_parse_join[NATURAL JOIN] PASSED
 429 tests/test_tokenize.py::test_parse_join[CROSS JOIN] PASSED
 430 tests/test_tokenize.py::test_parse_join[STRAIGHT JOIN] PASSED
 431 tests/test_tokenize.py::test_parse_join[INNER JOIN] PASSED
 432 tests/test_tokenize.py::test_parse_join[LEFT INNER JOIN] PASSED
 433 tests/test_tokenize.py::test_parse_union PASSED
 434 tests/test_tokenize.py::test_parse_endifloop[END IF] PASSED
 435 tests/test_tokenize.py::test_parse_endifloop[END   IF] PASSED
 436 tests/test_tokenize.py::test_parse_endifloop[END\t\nIF] PASSED
 437 tests/test_tokenize.py::test_parse_endifloop[END LOOP] PASSED
 438 tests/test_tokenize.py::test_parse_endifloop[END   LOOP] PASSED
 439 tests/test_tokenize.py::test_parse_endifloop[END\t\nLOOP] PASSED
 440 tests/test_tokenize.py::test_parse_order[ASC] PASSED
 441 tests/test_tokenize.py::test_parse_order[DESC] PASSED
 442 tests/test_tokenize.py::test_parse_order[NULLS FIRST] PASSED
 443 tests/test_tokenize.py::test_parse_order[NULLS LAST] PASSED
 444 tests/test_tokenize.py::test_parse_order[ASC NULLS FIRST] PASSED
 445 tests/test_tokenize.py::test_parse_order[ASC NULLS LAST] PASSED
 446 tests/test_tokenize.py::test_parse_order[DESC NULLS FIRST] PASSED
 447 tests/test_tokenize.py::test_parse_order[DESC NULLS LAST] PASSED
 448 tests/test_tokenize.py::test_parse_identifiers[foo] PASSED
 449 tests/test_tokenize.py::test_parse_identifiers[Foo] PASSED
 450 tests/test_tokenize.py::test_parse_identifiers[FOO] PASSED
 451 tests/test_tokenize.py::test_parse_identifiers[v$name] PASSED
 452 tests/test_tokenize.py::test_parse_group_by PASSED
 453 tests/test_tokenize.py::test_parse_order_by PASSED
 454 tests/test_tokenize.py::test_parse_window_as PASSED
 455 tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[LIKE] PASSED
 456 tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[ILIKE] PASSED
 457 tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT LIKE] PASSED
 458 tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT ILIKE] PASSED
 459 tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT   LIKE] PASSED
 460 tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT    ILIKE] PASSED
 461 tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[LIKEaaa] PASSED
 462 tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[bILIKE] PASSED
 463 tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[aaILIKEbb] PASSED
 464 tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[NOTLIKE] PASSED
 465 tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[NOTILIKE] PASSED
 466 tests/test_tokenize.py::test_parse_tzcast[AT TIME ZONE 'UTC'] PASSED
 467 tests/test_tokenize.py::test_cli_commands PASSED
 468 tests/test_utils.py::test_remove_quotes[None-None] PASSED
 469 tests/test_utils.py::test_remove_quotes['foo'-foo] PASSED
 470 tests/test_utils.py::test_remove_quotes["foo"-foo] PASSED
 471 tests/test_utils.py::test_remove_quotes[`foo`-foo] PASSED
 472
 473 ======== 461 passed, 2 xfailed, 1 xpassed ========