[verifier] model.patch applied (46481 bytes)
[verifier] Resetting files touched by test.patch
[verifier] Applying test.patch
[verifier] base pytest rc=0; new pytest rc=1
===== raw suite output: base.log =====
........................................................................ [  5%]
........................................................................ [ 11%]
........................................................................ [ 17%]
........................................................................ [ 23%]
........................................................................ [ 28%]
........................................................................ [ 34%]
........................................................................ [ 40%]
........................................................................ [ 46%]
........................................................................ [ 51%]
........................................................................ [ 57%]
........................................................................ [ 63%]
........................................................................ [ 69%]
........................................................................ [ 75%]
........................................................................ [ 80%]
........................................................................ [ 86%]
........................................................................ [ 92%]
........................................................................ [ 98%]
.......................                                                  [100%]
=============================== warnings summary ===============================
tests/functional_tests/test_end_to_end.py: 68 warnings
tests/unit_tests/test_api.py: 134 warnings
tests/unit_tests/test_cli.py: 32 warnings
  /usr/local/lib/python3.12/multiprocessing/popen_fork.py:66: DeprecationWarning: This process (pid=49) is multi-threaded, use of fork() may lead to deadlocks in the child.
    self.pid = os.fork()

-- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html
1247 passed, 2 deselected, 234 warnings in 18.87s
===== raw suite output: new.log =====
============================= test session starts ==============================
platform linux -- Python 3.12.12, pytest-9.0.3, pluggy-1.6.0 -- /usr/local/bin/python3
rootdir: /app
configfile: pyproject.toml
plugins: timeout-2.4.0, anyio-4.12.0
timeout: 60.0s
timeout method: signal
timeout func_only: False
collecting ... collected 79 items

tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[200] FAILED [  1%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[201] FAILED [  2%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[202] FAILED [  3%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[203] FAILED [  5%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[200] FAILED [  6%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[201] FAILED [  7%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[202] FAILED [  8%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[203] FAILED [ 10%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_is_idempotent[200] PASSED [ 11%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_is_idempotent[201] PASSED [ 12%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_is_idempotent[202] PASSED [ 13%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_is_idempotent[203] PASSED [ 15%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_structure[200] PASSED [ 16%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_structure[201] PASSED [ 17%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_structure[202] PASSED [ 18%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_fixture_structure[203] PASSED [ 20%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableEdgeCases::test_nested_struct_type_preserved PASSED [ 21%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableEdgeCases::test_column_name_matching_keyword_not_misclassified PASSED [ 22%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableEdgeCases::test_if_not_exists_variant PASSED [ 24%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableEdgeCases::test_default_with_function_call PASSED [ 25%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableEdgeCases::test_multiple_columns_not_merged_onto_one_line PASSED [ 26%]
tests/functional_tests/test_create_table_functional.py::TestCreateTableEdgeCases::test_semicolon_on_own_line PASSED [ 27%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_create_table_not_a_noop PASSED [ 29%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_array_type_on_same_line_as_column PASSED [ 30%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_nested_array_struct_type_on_same_line PASSED [ 31%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_column_definitions_have_trailing_commas PASSED [ 32%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_normal_columns_within_line_length PASSED [ 34%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_column_definitions_indented PASSED [ 35%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_closing_paren_at_depth_0 PASSED [ 36%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_semicolon_on_own_line_at_depth_0 PASSED [ 37%]
tests/unit_tests/test_create_table.py::TestCreateTableStructure::test_opening_paren_on_same_line_as_table_name PASSED [ 39%]
tests/unit_tests/test_create_table.py::TestCreateTableInlineConstraints::test_not_null_on_same_line_as_column PASSED [ 40%]
tests/unit_tests/test_create_table.py::TestCreateTableInlineConstraints::test_default_expression_on_same_line PASSED [ 41%]
tests/unit_tests/test_create_table.py::TestCreateTableInlineConstraints::test_references_on_same_line_as_column PASSED [ 43%]
tests/unit_tests/test_create_table.py::TestCreateTableTableConstraints::test_primary_key_on_own_line PASSED [ 44%]
tests/unit_tests/test_create_table.py::TestCreateTableTableConstraints::test_unique_constraint_on_own_line PASSED [ 45%]
tests/unit_tests/test_create_table.py::TestCreateTableTableConstraints::test_check_constraint_on_own_line PASSED [ 46%]
tests/unit_tests/test_create_table.py::TestCreateTableTableConstraints::test_foreign_key_on_own_line PASSED [ 48%]
tests/unit_tests/test_create_table.py::TestCreateTableTableConstraints::test_bare_check_on_own_line_short_table PASSED [ 49%]
tests/unit_tests/test_create_table.py::TestCreateTableTableConstraints::test_named_constraint_on_own_line_short_table PASSED [ 50%]
tests/unit_tests/test_create_table.py::TestCreateTableTableOptions::test_partition_by_at_depth_0 PASSED [ 51%]
tests/unit_tests/test_create_table.py::TestCreateTableTableOptions::test_options_clause_at_depth_0 PASSED [ 53%]
tests/unit_tests/test_create_table.py::TestCreateTableTableOptions::test_options_with_partition_by_on_separate_lines PASSED [ 54%]
tests/unit_tests/test_create_table.py::TestCreateTableTableOptions::test_cluster_by_at_depth_0 PASSED [ 55%]
tests/unit_tests/test_create_table.py::TestCreateTableEdgeCases::test_create_table_as_select_is_noop PASSED [ 56%]
tests/unit_tests/test_create_table.py::TestCreateTableEdgeCases::test_create_table_like_is_noop PASSED [ 58%]
tests/unit_tests/test_create_table.py::TestCreateTableEdgeCases::test_long_column_definition_not_truncated PASSED [ 59%]
tests/unit_tests/test_create_table.py::TestCreateTableEdgeCases::test_post_body_clause_args_exceeding_line_length PASSED [ 60%]
tests/unit_tests/test_create_table.py::TestCreateTableSafetyCheck::test_safety_check_passes_for_basic_create_table PASSED [ 62%]
tests/unit_tests/test_create_table.py::TestCreateTableSafetyCheck::test_safety_check_passes_for_nested_types PASSED [ 63%]
tests/unit_tests/test_create_table.py::TestCreateTableIdempotency::test_already_formatted_is_unchanged PASSED [ 64%]
tests/unit_tests/test_create_table.py::TestCreateTableIdempotency::test_unformatted_reaches_fixed_point_in_two_passes PASSED [ 65%]
tests/unit_tests/test_create_table.py::TestCreateTableIdempotency::test_keywords_lowercased PASSED [ 67%]
tests/unit_tests/test_create_table.py::TestDmlFormattingNotBroken::test_insert_is_idempotent PASSED [ 68%]
tests/unit_tests/test_create_table.py::TestDmlFormattingNotBroken::test_update_is_idempotent PASSED [ 69%]
tests/unit_tests/test_create_table.py::TestDmlFormattingNotBroken::test_delete_is_idempotent PASSED [ 70%]
tests/unit_tests/test_create_table.py::TestSelectFormattingNotBroken::test_simple_select_is_idempotent PASSED [ 72%]
tests/unit_tests/test_create_table.py::TestSelectFormattingNotBroken::test_cte_formatting_unchanged PASSED [ 73%]
tests/unit_tests/test_create_table.py::TestSelectFormattingNotBroken::test_comparison_operators_not_broken PASSED [ 74%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_returns_ddl_table PASSED [ 75%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_table_name PASSED [ 77%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_column_count PASSED [ 78%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_constraint_count PASSED [ 79%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_constraint_keywords PASSED [ 81%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_column_names PASSED [ 82%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_constrained_columns PASSED [ 83%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_unconstrained_columns PASSED [ 84%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_returns_none_for_select PASSED [ 86%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_ddl_column_str PASSED [ 87%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_ddl_table_constraint_count_zero PASSED [ 88%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_value_based_equality PASSED [ 89%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_ddl_column_type_name_excludes_constraint_tokens PASSED [ 91%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_parameterized_type_name PASSED [ 92%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_named_table_constraint PASSED [ 93%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_bare_check_constraint PASSED [ 94%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_equality_independent_of_source_position PASSED [ 96%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_type_name_preserves_original_spacing PASSED [ 97%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_parse_ddl_table_on_single_line_input PASSED [ 98%]
tests/unit_tests/test_create_table.py::TestDdlUtilities::test_type_name_lowercased_from_uppercase_source PASSED [100%]

=================================== FAILURES ===================================
_ TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[200] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7455e2150>
fixture_id = 200
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_preformatted_fixture_is_unchanged(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        The preformatted fixture must come through format_string byte-for-byte
        unchanged (idempotency requirement).
        At base commit: fixtures 202/203 don't exist → FAIL.
        After solution: all pass.
        """
        path = _require_fixture("preformatted", fixture_id)
        source = path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == source, (
            f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
            f"Expected:\n{source}\nGot:\n{result}"
        )
E       AssertionError: Fixture 200 (200_create_table.sql) changed after re-formatting.
E         Expected:
E         create table orders (
E             order_id int64 not null,
E             customer_id int64,
E             status string default 'pending',
E             email string references users(email),
E             tags array<string>,
E             properties array<struct<key string, value string>>,
E             primary key (order_id),
E             foreign key (customer_id) references customers(id)
E         )
E         partition by date(created_at)
E         ;
E         
E         Got:
E         create table orders(
E             order_id int64 not null,
E             customer_id int64,
E             status string default 'pending',
E             email string references users(email),
E             tags array<string>,
E             properties array<struct<key string, value string>>,
E             primary key (order_id),
E             foreign key (customer_id) references customers(id)
E         )
E         partition by date(created_at)
E         ;
E         
E       assert 'create table...ated_at)\n;\n' == 'create table...ated_at)\n;\n'
E         
E         - create table orders (
E         ?                    -
E         + create table orders(
E               order_id int64 not null,
E               customer_id int64,
E               status string default 'pending',...
E         
E         ...Full output truncated (8 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:68: AssertionError
_ TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[201] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457272c0>
fixture_id = 201
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_preformatted_fixture_is_unchanged(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        The preformatted fixture must come through format_string byte-for-byte
        unchanged (idempotency requirement).
        At base commit: fixtures 202/203 don't exist → FAIL.
        After solution: all pass.
        """
        path = _require_fixture("preformatted", fixture_id)
        source = path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == source, (
            f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
            f"Expected:\n{source}\nGot:\n{result}"
        )
E       AssertionError: Fixture 201 (201_create_table_comprehensive.sql) changed after re-formatting.
E         Expected:
E         create table inventory (
E             item_id int64 not null,
E             warehouse_id int64 not null,
E             sku string not null,
E             description string,
E             quantity int64 default 0,
E             unit_price numeric(10, 2) not null,
E             weight_kg float64,
E             is_active bool default true,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             attributes array<struct<key string, value string>>,
E             external_id string constraint uq_external_id unique,
E             status string constraint chk_status check (status in('active', 'inactive')),
E             primary key (item_id, warehouse_id),
E             foreign key (warehouse_id) references warehouses(id),
E             unique (sku, warehouse_id),
E             check (quantity >= 0)
E         )
E         partition by date(created_at)
E         cluster by warehouse_id, sku
E         ;
E         
E         Got:
E         create table inventory(
E             item_id int64 not null,
E             warehouse_id int64 not null,
E             sku string not null,
E             description string,
E             quantity int64 default 0,
E             unit_price numeric(10, 2) not null,
E             weight_kg float64,
E             is_active bool default true,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             attributes array<struct<key string, value string>>,
E             external_id string constraint uq_external_id unique,
E             status string constraint chk_status check (status in ('active', 'inactive')),
E             primary key (item_id, warehouse_id),
E             foreign key (warehouse_id) references warehouses(id),
E             unique (sku, warehouse_id),
E             check (quantity >= 0)
E         )
E         partition by date(created_at)
E         cluster by warehouse_id, sku
E         ;
E         
E       assert 'create table..._id, sku\n;\n' == 'create table..._id, sku\n;\n'
E         
E         - create table inventory (
E         ?                       -
E         + create table inventory(
E               item_id int64 not null,
E               warehouse_id int64 not null,
E               sku string not null,...
E         
E         ...Full output truncated (21 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:68: AssertionError
_ TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[202] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae745727560>
fixture_id = 202
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_preformatted_fixture_is_unchanged(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        The preformatted fixture must come through format_string byte-for-byte
        unchanged (idempotency requirement).
        At base commit: fixtures 202/203 don't exist → FAIL.
        After solution: all pass.
        """
        path = _require_fixture("preformatted", fixture_id)
        source = path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == source, (
            f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
            f"Expected:\n{source}\nGot:\n{result}"
        )
E       AssertionError: Fixture 202 (202_create_table_products.sql) changed after re-formatting.
E         Expected:
E         create table products (
E             product_id int64 not null,
E             category_id int64 not null,
E             seller_id int64,
E             sku string not null,
E             name string not null,
E             slug string not null,
E             description string,
E             price numeric(10, 2) not null,
E             compare_at_price numeric(10, 2),
E             cost_price numeric(10, 2),
E             discount_pct numeric(5, 2) default 0,
E             stock_qty int64 default 0 not null,
E             weight_g int64,
E             length_mm int64,
E             width_mm int64,
E             height_mm int64,
E             is_active bool default true not null,
E             is_featured bool default false,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             specs array<struct<attr string, val string>>,
E             primary key (product_id),
E             foreign key (category_id) references categories(id),
E             foreign key (seller_id) references sellers(id),
E             unique (sku),
E             unique (slug),
E             check (price > 0),
E             check (discount_pct >= 0)
E         )
E         partition by date(created_at)
E         cluster by category_id, seller_id
E         ;
E         
E         Got:
E         create table products(
E             product_id int64 not null,
E             category_id int64 not null,
E             seller_id int64,
E             sku string not null,
E             name string not null,
E             slug string not null,
E             description string,
E             price numeric(10, 2) not null,
E             compare_at_price numeric(10, 2),
E             cost_price numeric(10, 2),
E             discount_pct numeric(5, 2) default 0,
E             stock_qty int64 default 0 not null,
E             weight_g int64,
E             length_mm int64,
E             width_mm int64,
E             height_mm int64,
E             is_active bool default true not null,
E             is_featured bool default false,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             specs array<struct<attr string, val string>>,
E             primary key (product_id),
E             foreign key (category_id) references categories(id),
E             foreign key (seller_id) references sellers(id),
E             unique (sku),
E             unique (slug),
E             check (price > 0),
E             check (discount_pct >= 0)
E         )
E         partition by date(created_at)
E         cluster by category_id, seller_id
E         ;
E         
E       assert 'create table...eller_id\n;\n' == 'create table...eller_id\n;\n'
E         
E         - create table products (
E         ?                      -
E         + create table products(
E               product_id int64 not null,
E               category_id int64 not null,
E               seller_id int64,...
E         
E         ...Full output truncated (30 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:68: AssertionError
_ TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[203] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457275f0>
fixture_id = 203
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_preformatted_fixture_is_unchanged(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        The preformatted fixture must come through format_string byte-for-byte
        unchanged (idempotency requirement).
        At base commit: fixtures 202/203 don't exist → FAIL.
        After solution: all pass.
        """
        path = _require_fixture("preformatted", fixture_id)
        source = path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == source, (
            f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
            f"Expected:\n{source}\nGot:\n{result}"
        )
E       AssertionError: Fixture 203 (203_create_table_audit_log.sql) changed after re-formatting.
E         Expected:
E         create table audit_log (
E             log_id int64 not null,
E             tenant_id int64 not null,
E             table_name string not null,
E             schema_name string default 'public' not null,
E             operation string not null,
E             actor_id int64 not null,
E             actor_name string,
E             record_id string not null,
E             record_type string,
E             old_values string,
E             new_values string,
E             diff_values string,
E             ip_address string,
E             user_agent string,
E             session_id string,
E             request_id string,
E             changed_by string,
E             change_reason string,
E             environment string default 'production',
E             correlation_id string,
E             occurred_at timestamp not null,
E             constraint chk_operation check (operation in('insert', 'update', 'delete')),
E             primary key (log_id),
E             foreign key (actor_id) references users(id)
E         )
E         partition by date(occurred_at)
E         ;
E         
E         Got:
E         create table audit_log(
E             log_id int64 not null,
E             tenant_id int64 not null,
E             table_name string not null,
E             schema_name string default 'public' not null,
E             operation string not null,
E             actor_id int64 not null,
E             actor_name string,
E             record_id string not null,
E             record_type string,
E             old_values string,
E             new_values string,
E             diff_values string,
E             ip_address string,
E             user_agent string,
E             session_id string,
E             request_id string,
E             changed_by string,
E             change_reason string,
E             environment string default 'production',
E             correlation_id string,
E             occurred_at timestamp not null,
E             constraint chk_operation check (operation in ('insert', 'update', 'delete')),
E             primary key (log_id),
E             foreign key (actor_id) references users(id)
E         )
E         partition by date(occurred_at)
E         ;
E         
E       assert 'create table...rred_at)\n;\n' == 'create table...rred_at)\n;\n'
E         
E         - create table audit_log (
E         ?                       -
E         + create table audit_log(
E               log_id int64 not null,
E               tenant_id int64 not null,
E               table_name string not null,...
E         
E         ...Full output truncated (26 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:68: AssertionError
__ TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[200] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae745727860>
fixture_id = 200
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_unformatted_reaches_preformatted(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        Formatting the unformatted fixture must produce the preformatted fixture
        exactly.
        At base commit: FAILS (no DDL implementation).
        """
        pre_path = _require_fixture("preformatted", fixture_id)
        unf_path = _require_fixture("unformatted", fixture_id)
        expected = pre_path.read_text(encoding="utf-8")
        source = unf_path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == expected, (
            f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
            f"Expected:\n{expected}\nGot:\n{result}"
        )
E       AssertionError: Fixture 200: unformatted → preformatted failed.
E         Expected:
E         create table orders (
E             order_id int64 not null,
E             customer_id int64,
E             status string default 'pending',
E             email string references users(email),
E             tags array<string>,
E             properties array<struct<key string, value string>>,
E             primary key (order_id),
E             foreign key (customer_id) references customers(id)
E         )
E         partition by date(created_at)
E         ;
E         
E         Got:
E         create table orders(
E             order_id int64 not null,
E             customer_id int64,
E             status string default 'pending',
E             email string references users(email),
E             tags array<string>,
E             properties array<struct<key string, value string>>,
E             primary key (order_id),
E             foreign key (customer_id) references customers(id)
E         )
E         partition by date(created_at)
E         ;
E         
E       assert 'create table...ated_at)\n;\n' == 'create table...ated_at)\n;\n'
E         
E         - create table orders (
E         ?                    -
E         + create table orders(
E               order_id int64 not null,
E               customer_id int64,
E               status string default 'pending',...
E         
E         ...Full output truncated (8 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:89: AssertionError
__ TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[201] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457279b0>
fixture_id = 201
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_unformatted_reaches_preformatted(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        Formatting the unformatted fixture must produce the preformatted fixture
        exactly.
        At base commit: FAILS (no DDL implementation).
        """
        pre_path = _require_fixture("preformatted", fixture_id)
        unf_path = _require_fixture("unformatted", fixture_id)
        expected = pre_path.read_text(encoding="utf-8")
        source = unf_path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == expected, (
            f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
            f"Expected:\n{expected}\nGot:\n{result}"
        )
E       AssertionError: Fixture 201: unformatted → preformatted failed.
E         Expected:
E         create table inventory (
E             item_id int64 not null,
E             warehouse_id int64 not null,
E             sku string not null,
E             description string,
E             quantity int64 default 0,
E             unit_price numeric(10, 2) not null,
E             weight_kg float64,
E             is_active bool default true,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             attributes array<struct<key string, value string>>,
E             external_id string constraint uq_external_id unique,
E             status string constraint chk_status check (status in('active', 'inactive')),
E             primary key (item_id, warehouse_id),
E             foreign key (warehouse_id) references warehouses(id),
E             unique (sku, warehouse_id),
E             check (quantity >= 0)
E         )
E         partition by date(created_at)
E         cluster by warehouse_id, sku
E         ;
E         
E         Got:
E         create table inventory(
E             item_id int64 not null,
E             warehouse_id int64 not null,
E             sku string not null,
E             description string,
E             quantity int64 default 0,
E             unit_price numeric(10, 2) not null,
E             weight_kg float64,
E             is_active bool default true,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             attributes array<struct<key string, value string>>,
E             external_id string constraint uq_external_id unique,
E             status string constraint chk_status check (status in ('active', 'inactive')),
E             primary key (item_id, warehouse_id),
E             foreign key (warehouse_id) references warehouses(id),
E             unique (sku, warehouse_id),
E             check (quantity >= 0)
E         )
E         partition by date(created_at)
E         cluster by warehouse_id, sku
E         ;
E         
E       assert 'create table..._id, sku\n;\n' == 'create table..._id, sku\n;\n'
E         
E         - create table inventory (
E         ?                       -
E         + create table inventory(
E               item_id int64 not null,
E               warehouse_id int64 not null,
E               sku string not null,...
E         
E         ...Full output truncated (21 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:89: AssertionError
__ TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[202] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae74569d9d0>
fixture_id = 202
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_unformatted_reaches_preformatted(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        Formatting the unformatted fixture must produce the preformatted fixture
        exactly.
        At base commit: FAILS (no DDL implementation).
        """
        pre_path = _require_fixture("preformatted", fixture_id)
        unf_path = _require_fixture("unformatted", fixture_id)
        expected = pre_path.read_text(encoding="utf-8")
        source = unf_path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == expected, (
            f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
            f"Expected:\n{expected}\nGot:\n{result}"
        )
E       AssertionError: Fixture 202: unformatted → preformatted failed.
E         Expected:
E         create table products (
E             product_id int64 not null,
E             category_id int64 not null,
E             seller_id int64,
E             sku string not null,
E             name string not null,
E             slug string not null,
E             description string,
E             price numeric(10, 2) not null,
E             compare_at_price numeric(10, 2),
E             cost_price numeric(10, 2),
E             discount_pct numeric(5, 2) default 0,
E             stock_qty int64 default 0 not null,
E             weight_g int64,
E             length_mm int64,
E             width_mm int64,
E             height_mm int64,
E             is_active bool default true not null,
E             is_featured bool default false,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             specs array<struct<attr string, val string>>,
E             primary key (product_id),
E             foreign key (category_id) references categories(id),
E             foreign key (seller_id) references sellers(id),
E             unique (sku),
E             unique (slug),
E             check (price > 0),
E             check (discount_pct >= 0)
E         )
E         partition by date(created_at)
E         cluster by category_id, seller_id
E         ;
E         
E         Got:
E         create table products(
E             product_id int64 not null,
E             category_id int64 not null,
E             seller_id int64,
E             sku string not null,
E             name string not null,
E             slug string not null,
E             description string,
E             price numeric(10, 2) not null,
E             compare_at_price numeric(10, 2),
E             cost_price numeric(10, 2),
E             discount_pct numeric(5, 2) default 0,
E             stock_qty int64 default 0 not null,
E             weight_g int64,
E             length_mm int64,
E             width_mm int64,
E             height_mm int64,
E             is_active bool default true not null,
E             is_featured bool default false,
E             created_at timestamp not null,
E             updated_at timestamp,
E             tags array<string>,
E             specs array<struct<attr string, val string>>,
E             primary key (product_id),
E             foreign key (category_id) references categories(id),
E             foreign key (seller_id) references sellers(id),
E             unique (sku),
E             unique (slug),
E             check (price > 0),
E             check (discount_pct >= 0)
E         )
E         partition by date(created_at)
E         cluster by category_id, seller_id
E         ;
E         
E       assert 'create table...eller_id\n;\n' == 'create table...eller_id\n;\n'
E         
E         - create table products (
E         ?                      -
E         + create table products(
E               product_id int64 not null,
E               category_id int64 not null,
E               seller_id int64,...
E         
E         ...Full output truncated (30 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:89: AssertionError
__ TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[203] __

self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457276e0>
fixture_id = 203
default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)

    def test_unformatted_reaches_preformatted(
        self, fixture_id: int, default_mode: Mode
    ) -> None:
        """
        Formatting the unformatted fixture must produce the preformatted fixture
        exactly.
        At base commit: FAILS (no DDL implementation).
        """
        pre_path = _require_fixture("preformatted", fixture_id)
        unf_path = _require_fixture("unformatted", fixture_id)
        expected = pre_path.read_text(encoding="utf-8")
        source = unf_path.read_text(encoding="utf-8")
        result = format_string(source, default_mode)
>       assert result == expected, (
            f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
            f"Expected:\n{expected}\nGot:\n{result}"
        )
E       AssertionError: Fixture 203: unformatted → preformatted failed.
E         Expected:
E         create table audit_log (
E             log_id int64 not null,
E             tenant_id int64 not null,
E             table_name string not null,
E             schema_name string default 'public' not null,
E             operation string not null,
E             actor_id int64 not null,
E             actor_name string,
E             record_id string not null,
E             record_type string,
E             old_values string,
E             new_values string,
E             diff_values string,
E             ip_address string,
E             user_agent string,
E             session_id string,
E             request_id string,
E             changed_by string,
E             change_reason string,
E             environment string default 'production',
E             correlation_id string,
E             occurred_at timestamp not null,
E             constraint chk_operation check (operation in('insert', 'update', 'delete')),
E             primary key (log_id),
E             foreign key (actor_id) references users(id)
E         )
E         partition by date(occurred_at)
E         ;
E         
E         Got:
E         create table audit_log(
E             log_id int64 not null,
E             tenant_id int64 not null,
E             table_name string not null,
E             schema_name string default 'public' not null,
E             operation string not null,
E             actor_id int64 not null,
E             actor_name string,
E             record_id string not null,
E             record_type string,
E             old_values string,
E             new_values string,
E             diff_values string,
E             ip_address string,
E             user_agent string,
E             session_id string,
E             request_id string,
E             changed_by string,
E             change_reason string,
E             environment string default 'production',
E             correlation_id string,
E             occurred_at timestamp not null,
E             constraint chk_operation check (operation in ('insert', 'update', 'delete')),
E             primary key (log_id),
E             foreign key (actor_id) references users(id)
E         )
E         partition by date(occurred_at)
E         ;
E         
E       assert 'create table...rred_at)\n;\n' == 'create table...rred_at)\n;\n'
E         
E         - create table audit_log (
E         ?                       -
E         + create table audit_log(
E               log_id int64 not null,
E               tenant_id int64 not null,
E               table_name string not null,...
E         
E         ...Full output truncated (26 lines hidden), use '-vv' to show

tests/functional_tests/test_create_table_functional.py:89: AssertionError
------------------ generated xml file: /logs/verifier/new.xml ------------------
=========================== short test summary info ============================
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[200]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[201]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[202]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_preformatted_fixture_is_unchanged[203]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[200]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[201]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[202]
FAILED tests/functional_tests/test_create_table_functional.py::TestCreateTableFixtureRoundTrip::test_unformatted_reaches_preformatted[203]
========================= 8 failed, 71 passed in 0.62s =========================
===== grade =====
[verifier] ===== FAILURES (8) =====
[verifier] ✗ [p2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[200]
    AssertionError: Fixture 200 (200_create_table.sql) changed after re-formatting.
      Expected:
      create table orders (
          order_id int64 not null,
          customer_id int64,
          status string default 'pending',
          email string references users(email),
          tags array<string>,
          properties array<struct<key string, value string>>,
          primary key (order_id),
          foreign key (customer_id) references customers(id)
      )
      partition by date(created_at)
      ;
      
      Got:
      create table orders(
          order_id int64 not null,
          customer_id int64,
          status string default 'pending',
          email string references users(email),
          tags array<string>,
          properties array<struct<key string, value string>>,
          primary key (order_id),
          foreign key (customer_id) references customers(id)
      )
      partition by date(created_at)
      ;
      
    assert 'create table...ated_at)\n;\n' == 'create table...ated_at)\n;\n'
      
      - create table orders (
      ?                    -
      + create table orders(
            order_id int64 not null,
            customer_id int64,
            status string default 'pending',...
      
      ...Full output truncated (8 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7455e2150>
    fixture_id = 200
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_preformatted_fixture_is_unchanged(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            The preformatted fixture must come through format_string byte-for-byte
            unchanged (idempotency requirement).
            At base commit: fixtures 202/203 don't exist → FAIL.
            After solution: all pass.
            """
            path = _require_fixture("preformatted", fixture_id)
            source = path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == source, (
                f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
                f"Expected:\n{source}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 200 (200_create_table.sql) changed after re-formatting.
    E         Expected:
    E         create table orders (
    E             order_id int64 not null,
    E             customer_id int64,
    E             status string default 'pending',
    E             email string references users(email),
    E             tags array<string>,
    E             properties array<struct<key string, value string>>,
    E             primary key (order_id),
    E             foreign key (customer_id) references customers(id)
    E         )
    E         partition by date(created_at)
    E         ;
    E         
    E         Got:
    E         create table orders(
    E             order_id int64 not null,
    E             customer_id int64,
    E             status string default 'pending',
    E             email string references users(email),
    E             tags array<string>,
    E             properties array<struct<key string, value string>>,
    E             primary key (order_id),
    E             foreign key (customer_id) references customers(id)
    E         )
    E         partition by date(created_at)
    E         ;
    E         
    E       assert 'create table...ated_at)\n;\n' == 'create table...ated_at)\n;\n'
    E         
    E         - create table orders (
    E         ?                    -
    E         + create table orders(
    E               order_id int64 not null,
    E               customer_id int64,
    E               status string default 'pending',...
    E         
    E         ...Full output truncated (8 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:68: AssertionError
[verifier] ✗ [p2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[201]
    AssertionError: Fixture 201 (201_create_table_comprehensive.sql) changed after re-formatting.
      Expected:
      create table inventory (
          item_id int64 not null,
          warehouse_id int64 not null,
          sku string not null,
          description string,
          quantity int64 default 0,
          unit_price numeric(10, 2) not null,
          weight_kg float64,
          is_active bool default true,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          attributes array<struct<key string, value string>>,
          external_id string constraint uq_external_id unique,
          status string constraint chk_status check (status in('active', 'inactive')),
          primary key (item_id, warehouse_id),
          foreign key (warehouse_id) references warehouses(id),
          unique (sku, warehouse_id),
          check (quantity >= 0)
      )
      partition by date(created_at)
      cluster by warehouse_id, sku
      ;
      
      Got:
      create table inventory(
          item_id int64 not null,
          warehouse_id int64 not null,
          sku string not null,
          description string,
          quantity int64 default 0,
          unit_price numeric(10, 2) not null,
          weight_kg float64,
          is_active bool default true,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          attributes array<struct<key string, value string>>,
          external_id string constraint uq_external_id unique,
          status string constraint chk_status check (status in ('active', 'inactive')),
          primary key (item_id, warehouse_id),
          foreign key (warehouse_id) references warehouses(id),
          unique (sku, warehouse_id),
          check (quantity >= 0)
      )
      partition by date(created_at)
      cluster by warehouse_id, sku
      ;
      
    assert 'create table..._id, sku\n;\n' == 'create table..._id, sku\n;\n'
      
      - create table inventory (
      ?                       -
      + create table inventory(
            item_id int64 not null,
            warehouse_id int64 not null,
            sku string not null,...
      
      ...Full output truncated (21 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457272c0>
    fixture_id = 201
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_preformatted_fixture_is_unchanged(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            The preformatted fixture must come through format_string byte-for-byte
            unchanged (idempotency requirement).
            At base commit: fixtures 202/203 don't exist → FAIL.
            After solution: all pass.
            """
            path = _require_fixture("preformatted", fixture_id)
            source = path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == source, (
                f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
                f"Expected:\n{source}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 201 (201_create_table_comprehensive.sql) changed after re-formatting.
    E         Expected:
    E         create table inventory (
    E             item_id int64 not null,
    E             warehouse_id int64 not null,
    E             sku string not null,
    E             description string,
    E             quantity int64 default 0,
    E             unit_price numeric(10, 2) not null,
    E             weight_kg float64,
    E             is_active bool default true,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             attributes array<struct<key string, value string>>,
    E             external_id string constraint uq_external_id unique,
    E             status string constraint chk_status check (status in('active', 'inactive')),
    E             primary key (item_id, warehouse_id),
    E             foreign key (warehouse_id) references warehouses(id),
    E             unique (sku, warehouse_id),
    E             check (quantity >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by warehouse_id, sku
    E         ;
    E         
    E         Got:
    E         create table inventory(
    E             item_id int64 not null,
    E             warehouse_id int64 not null,
    E             sku string not null,
    E             description string,
    E             quantity int64 default 0,
    E             unit_price numeric(10, 2) not null,
    E             weight_kg float64,
    E             is_active bool default true,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             attributes array<struct<key string, value string>>,
    E             external_id string constraint uq_external_id unique,
    E             status string constraint chk_status check (status in ('active', 'inactive')),
    E             primary key (item_id, warehouse_id),
    E             foreign key (warehouse_id) references warehouses(id),
    E             unique (sku, warehouse_id),
    E             check (quantity >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by warehouse_id, sku
    E         ;
    E         
    E       assert 'create table..._id, sku\n;\n' == 'create table..._id, sku\n;\n'
    E         
    E         - create table inventory (
    E         ?                       -
    E         + create table inventory(
    E               item_id int64 not null,
    E               warehouse_id int64 not null,
    E               sku string not null,...
    E         
    E         ...Full output truncated (21 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:68: AssertionError
[verifier] ✗ [p2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[202]
    AssertionError: Fixture 202 (202_create_table_products.sql) changed after re-formatting.
      Expected:
      create table products (
          product_id int64 not null,
          category_id int64 not null,
          seller_id int64,
          sku string not null,
          name string not null,
          slug string not null,
          description string,
          price numeric(10, 2) not null,
          compare_at_price numeric(10, 2),
          cost_price numeric(10, 2),
          discount_pct numeric(5, 2) default 0,
          stock_qty int64 default 0 not null,
          weight_g int64,
          length_mm int64,
          width_mm int64,
          height_mm int64,
          is_active bool default true not null,
          is_featured bool default false,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          specs array<struct<attr string, val string>>,
          primary key (product_id),
          foreign key (category_id) references categories(id),
          foreign key (seller_id) references sellers(id),
          unique (sku),
          unique (slug),
          check (price > 0),
          check (discount_pct >= 0)
      )
      partition by date(created_at)
      cluster by category_id, seller_id
      ;
      
      Got:
      create table products(
          product_id int64 not null,
          category_id int64 not null,
          seller_id int64,
          sku string not null,
          name string not null,
          slug string not null,
          description string,
          price numeric(10, 2) not null,
          compare_at_price numeric(10, 2),
          cost_price numeric(10, 2),
          discount_pct numeric(5, 2) default 0,
          stock_qty int64 default 0 not null,
          weight_g int64,
          length_mm int64,
          width_mm int64,
          height_mm int64,
          is_active bool default true not null,
          is_featured bool default false,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          specs array<struct<attr string, val string>>,
          primary key (product_id),
          foreign key (category_id) references categories(id),
          foreign key (seller_id) references sellers(id),
          unique (sku),
          unique (slug),
          check (price > 0),
          check (discount_pct >= 0)
      )
      partition by date(created_at)
      cluster by category_id, seller_id
      ;
      
    assert 'create table...eller_id\n;\n' == 'create table...eller_id\n;\n'
      
      - create table products (
      ?                      -
      + create table products(
            product_id int64 not null,
            category_id int64 not null,
            seller_id int64,...
      
      ...Full output truncated (30 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae745727560>
    fixture_id = 202
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_preformatted_fixture_is_unchanged(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            The preformatted fixture must come through format_string byte-for-byte
            unchanged (idempotency requirement).
            At base commit: fixtures 202/203 don't exist → FAIL.
            After solution: all pass.
            """
            path = _require_fixture("preformatted", fixture_id)
            source = path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == source, (
                f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
                f"Expected:\n{source}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 202 (202_create_table_products.sql) changed after re-formatting.
    E         Expected:
    E         create table products (
    E             product_id int64 not null,
    E             category_id int64 not null,
    E             seller_id int64,
    E             sku string not null,
    E             name string not null,
    E             slug string not null,
    E             description string,
    E             price numeric(10, 2) not null,
    E             compare_at_price numeric(10, 2),
    E             cost_price numeric(10, 2),
    E             discount_pct numeric(5, 2) default 0,
    E             stock_qty int64 default 0 not null,
    E             weight_g int64,
    E             length_mm int64,
    E             width_mm int64,
    E             height_mm int64,
    E             is_active bool default true not null,
    E             is_featured bool default false,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             specs array<struct<attr string, val string>>,
    E             primary key (product_id),
    E             foreign key (category_id) references categories(id),
    E             foreign key (seller_id) references sellers(id),
    E             unique (sku),
    E             unique (slug),
    E             check (price > 0),
    E             check (discount_pct >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by category_id, seller_id
    E         ;
    E         
    E         Got:
    E         create table products(
    E             product_id int64 not null,
    E             category_id int64 not null,
    E             seller_id int64,
    E             sku string not null,
    E             name string not null,
    E             slug string not null,
    E             description string,
    E             price numeric(10, 2) not null,
    E             compare_at_price numeric(10, 2),
    E             cost_price numeric(10, 2),
    E             discount_pct numeric(5, 2) default 0,
    E             stock_qty int64 default 0 not null,
    E             weight_g int64,
    E             length_mm int64,
    E             width_mm int64,
    E             height_mm int64,
    E             is_active bool default true not null,
    E             is_featured bool default false,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             specs array<struct<attr string, val string>>,
    E             primary key (product_id),
    E             foreign key (category_id) references categories(id),
    E             foreign key (seller_id) references sellers(id),
    E             unique (sku),
    E             unique (slug),
    E             check (price > 0),
    E             check (discount_pct >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by category_id, seller_id
    E         ;
    E         
    E       assert 'create table...eller_id\n;\n' == 'create table...eller_id\n;\n'
    E         
    E         - create table products (
    E         ?                      -
    E         + create table products(
    E               product_id int64 not null,
    E               category_id int64 not null,
    E               seller_id int64,...
    E         
    E         ...Full output truncated (30 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:68: AssertionError
[verifier] ✗ [p2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_preformatted_fixture_is_unchanged[203]
    AssertionError: Fixture 203 (203_create_table_audit_log.sql) changed after re-formatting.
      Expected:
      create table audit_log (
          log_id int64 not null,
          tenant_id int64 not null,
          table_name string not null,
          schema_name string default 'public' not null,
          operation string not null,
          actor_id int64 not null,
          actor_name string,
          record_id string not null,
          record_type string,
          old_values string,
          new_values string,
          diff_values string,
          ip_address string,
          user_agent string,
          session_id string,
          request_id string,
          changed_by string,
          change_reason string,
          environment string default 'production',
          correlation_id string,
          occurred_at timestamp not null,
          constraint chk_operation check (operation in('insert', 'update', 'delete')),
          primary key (log_id),
          foreign key (actor_id) references users(id)
      )
      partition by date(occurred_at)
      ;
      
      Got:
      create table audit_log(
          log_id int64 not null,
          tenant_id int64 not null,
          table_name string not null,
          schema_name string default 'public' not null,
          operation string not null,
          actor_id int64 not null,
          actor_name string,
          record_id string not null,
          record_type string,
          old_values string,
          new_values string,
          diff_values string,
          ip_address string,
          user_agent string,
          session_id string,
          request_id string,
          changed_by string,
          change_reason string,
          environment string default 'production',
          correlation_id string,
          occurred_at timestamp not null,
          constraint chk_operation check (operation in ('insert', 'update', 'delete')),
          primary key (log_id),
          foreign key (actor_id) references users(id)
      )
      partition by date(occurred_at)
      ;
      
    assert 'create table...rred_at)\n;\n' == 'create table...rred_at)\n;\n'
      
      - create table audit_log (
      ?                       -
      + create table audit_log(
            log_id int64 not null,
            tenant_id int64 not null,
            table_name string not null,...
      
      ...Full output truncated (26 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457275f0>
    fixture_id = 203
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_preformatted_fixture_is_unchanged(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            The preformatted fixture must come through format_string byte-for-byte
            unchanged (idempotency requirement).
            At base commit: fixtures 202/203 don't exist → FAIL.
            After solution: all pass.
            """
            path = _require_fixture("preformatted", fixture_id)
            source = path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == source, (
                f"Fixture {fixture_id} ({path.name}) changed after re-formatting.\n"
                f"Expected:\n{source}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 203 (203_create_table_audit_log.sql) changed after re-formatting.
    E         Expected:
    E         create table audit_log (
    E             log_id int64 not null,
    E             tenant_id int64 not null,
    E             table_name string not null,
    E             schema_name string default 'public' not null,
    E             operation string not null,
    E             actor_id int64 not null,
    E             actor_name string,
    E             record_id string not null,
    E             record_type string,
    E             old_values string,
    E             new_values string,
    E             diff_values string,
    E             ip_address string,
    E             user_agent string,
    E             session_id string,
    E             request_id string,
    E             changed_by string,
    E             change_reason string,
    E             environment string default 'production',
    E             correlation_id string,
    E             occurred_at timestamp not null,
    E             constraint chk_operation check (operation in('insert', 'update', 'delete')),
    E             primary key (log_id),
    E             foreign key (actor_id) references users(id)
    E         )
    E         partition by date(occurred_at)
    E         ;
    E         
    E         Got:
    E         create table audit_log(
    E             log_id int64 not null,
    E             tenant_id int64 not null,
    E             table_name string not null,
    E             schema_name string default 'public' not null,
    E             operation string not null,
    E             actor_id int64 not null,
    E             actor_name string,
    E             record_id string not null,
    E             record_type string,
    E             old_values string,
    E             new_values string,
    E             diff_values string,
    E             ip_address string,
    E             user_agent string,
    E             session_id string,
    E             request_id string,
    E             changed_by string,
    E             change_reason string,
    E             environment string default 'production',
    E             correlation_id string,
    E             occurred_at timestamp not null,
    E             constraint chk_operation check (operation in ('insert', 'update', 'delete')),
    E             primary key (log_id),
    E             foreign key (actor_id) references users(id)
    E         )
    E         partition by date(occurred_at)
    E         ;
    E         
    E       assert 'create table...rred_at)\n;\n' == 'create table...rred_at)\n;\n'
    E         
    E         - create table audit_log (
    E         ?                       -
    E         + create table audit_log(
    E               log_id int64 not null,
    E               tenant_id int64 not null,
    E               table_name string not null,...
    E         
    E         ...Full output truncated (26 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:68: AssertionError
[verifier] ✗ [f2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[200]
    AssertionError: Fixture 200: unformatted → preformatted failed.
      Expected:
      create table orders (
          order_id int64 not null,
          customer_id int64,
          status string default 'pending',
          email string references users(email),
          tags array<string>,
          properties array<struct<key string, value string>>,
          primary key (order_id),
          foreign key (customer_id) references customers(id)
      )
      partition by date(created_at)
      ;
      
      Got:
      create table orders(
          order_id int64 not null,
          customer_id int64,
          status string default 'pending',
          email string references users(email),
          tags array<string>,
          properties array<struct<key string, value string>>,
          primary key (order_id),
          foreign key (customer_id) references customers(id)
      )
      partition by date(created_at)
      ;
      
    assert 'create table...ated_at)\n;\n' == 'create table...ated_at)\n;\n'
      
      - create table orders (
      ?                    -
      + create table orders(
            order_id int64 not null,
            customer_id int64,
            status string default 'pending',...
      
      ...Full output truncated (8 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae745727860>
    fixture_id = 200
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_unformatted_reaches_preformatted(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            Formatting the unformatted fixture must produce the preformatted fixture
            exactly.
            At base commit: FAILS (no DDL implementation).
            """
            pre_path = _require_fixture("preformatted", fixture_id)
            unf_path = _require_fixture("unformatted", fixture_id)
            expected = pre_path.read_text(encoding="utf-8")
            source = unf_path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == expected, (
                f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
                f"Expected:\n{expected}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 200: unformatted → preformatted failed.
    E         Expected:
    E         create table orders (
    E             order_id int64 not null,
    E             customer_id int64,
    E             status string default 'pending',
    E             email string references users(email),
    E             tags array<string>,
    E             properties array<struct<key string, value string>>,
    E             primary key (order_id),
    E             foreign key (customer_id) references customers(id)
    E         )
    E         partition by date(created_at)
    E         ;
    E         
    E         Got:
    E         create table orders(
    E             order_id int64 not null,
    E             customer_id int64,
    E             status string default 'pending',
    E             email string references users(email),
    E             tags array<string>,
    E             properties array<struct<key string, value string>>,
    E             primary key (order_id),
    E             foreign key (customer_id) references customers(id)
    E         )
    E         partition by date(created_at)
    E         ;
    E         
    E       assert 'create table...ated_at)\n;\n' == 'create table...ated_at)\n;\n'
    E         
    E         - create table orders (
    E         ?                    -
    E         + create table orders(
    E               order_id int64 not null,
    E               customer_id int64,
    E               status string default 'pending',...
    E         
    E         ...Full output truncated (8 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:89: AssertionError
[verifier] ✗ [f2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[201]
    AssertionError: Fixture 201: unformatted → preformatted failed.
      Expected:
      create table inventory (
          item_id int64 not null,
          warehouse_id int64 not null,
          sku string not null,
          description string,
          quantity int64 default 0,
          unit_price numeric(10, 2) not null,
          weight_kg float64,
          is_active bool default true,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          attributes array<struct<key string, value string>>,
          external_id string constraint uq_external_id unique,
          status string constraint chk_status check (status in('active', 'inactive')),
          primary key (item_id, warehouse_id),
          foreign key (warehouse_id) references warehouses(id),
          unique (sku, warehouse_id),
          check (quantity >= 0)
      )
      partition by date(created_at)
      cluster by warehouse_id, sku
      ;
      
      Got:
      create table inventory(
          item_id int64 not null,
          warehouse_id int64 not null,
          sku string not null,
          description string,
          quantity int64 default 0,
          unit_price numeric(10, 2) not null,
          weight_kg float64,
          is_active bool default true,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          attributes array<struct<key string, value string>>,
          external_id string constraint uq_external_id unique,
          status string constraint chk_status check (status in ('active', 'inactive')),
          primary key (item_id, warehouse_id),
          foreign key (warehouse_id) references warehouses(id),
          unique (sku, warehouse_id),
          check (quantity >= 0)
      )
      partition by date(created_at)
      cluster by warehouse_id, sku
      ;
      
    assert 'create table..._id, sku\n;\n' == 'create table..._id, sku\n;\n'
      
      - create table inventory (
      ?                       -
      + create table inventory(
            item_id int64 not null,
            warehouse_id int64 not null,
            sku string not null,...
      
      ...Full output truncated (21 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457279b0>
    fixture_id = 201
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_unformatted_reaches_preformatted(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            Formatting the unformatted fixture must produce the preformatted fixture
            exactly.
            At base commit: FAILS (no DDL implementation).
            """
            pre_path = _require_fixture("preformatted", fixture_id)
            unf_path = _require_fixture("unformatted", fixture_id)
            expected = pre_path.read_text(encoding="utf-8")
            source = unf_path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == expected, (
                f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
                f"Expected:\n{expected}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 201: unformatted → preformatted failed.
    E         Expected:
    E         create table inventory (
    E             item_id int64 not null,
    E             warehouse_id int64 not null,
    E             sku string not null,
    E             description string,
    E             quantity int64 default 0,
    E             unit_price numeric(10, 2) not null,
    E             weight_kg float64,
    E             is_active bool default true,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             attributes array<struct<key string, value string>>,
    E             external_id string constraint uq_external_id unique,
    E             status string constraint chk_status check (status in('active', 'inactive')),
    E             primary key (item_id, warehouse_id),
    E             foreign key (warehouse_id) references warehouses(id),
    E             unique (sku, warehouse_id),
    E             check (quantity >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by warehouse_id, sku
    E         ;
    E         
    E         Got:
    E         create table inventory(
    E             item_id int64 not null,
    E             warehouse_id int64 not null,
    E             sku string not null,
    E             description string,
    E             quantity int64 default 0,
    E             unit_price numeric(10, 2) not null,
    E             weight_kg float64,
    E             is_active bool default true,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             attributes array<struct<key string, value string>>,
    E             external_id string constraint uq_external_id unique,
    E             status string constraint chk_status check (status in ('active', 'inactive')),
    E             primary key (item_id, warehouse_id),
    E             foreign key (warehouse_id) references warehouses(id),
    E             unique (sku, warehouse_id),
    E             check (quantity >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by warehouse_id, sku
    E         ;
    E         
    E       assert 'create table..._id, sku\n;\n' == 'create table..._id, sku\n;\n'
    E         
    E         - create table inventory (
    E         ?                       -
    E         + create table inventory(
    E               item_id int64 not null,
    E               warehouse_id int64 not null,
    E               sku string not null,...
    E         
    E         ...Full output truncated (21 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:89: AssertionError
[verifier] ✗ [f2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[202]
    AssertionError: Fixture 202: unformatted → preformatted failed.
      Expected:
      create table products (
          product_id int64 not null,
          category_id int64 not null,
          seller_id int64,
          sku string not null,
          name string not null,
          slug string not null,
          description string,
          price numeric(10, 2) not null,
          compare_at_price numeric(10, 2),
          cost_price numeric(10, 2),
          discount_pct numeric(5, 2) default 0,
          stock_qty int64 default 0 not null,
          weight_g int64,
          length_mm int64,
          width_mm int64,
          height_mm int64,
          is_active bool default true not null,
          is_featured bool default false,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          specs array<struct<attr string, val string>>,
          primary key (product_id),
          foreign key (category_id) references categories(id),
          foreign key (seller_id) references sellers(id),
          unique (sku),
          unique (slug),
          check (price > 0),
          check (discount_pct >= 0)
      )
      partition by date(created_at)
      cluster by category_id, seller_id
      ;
      
      Got:
      create table products(
          product_id int64 not null,
          category_id int64 not null,
          seller_id int64,
          sku string not null,
          name string not null,
          slug string not null,
          description string,
          price numeric(10, 2) not null,
          compare_at_price numeric(10, 2),
          cost_price numeric(10, 2),
          discount_pct numeric(5, 2) default 0,
          stock_qty int64 default 0 not null,
          weight_g int64,
          length_mm int64,
          width_mm int64,
          height_mm int64,
          is_active bool default true not null,
          is_featured bool default false,
          created_at timestamp not null,
          updated_at timestamp,
          tags array<string>,
          specs array<struct<attr string, val string>>,
          primary key (product_id),
          foreign key (category_id) references categories(id),
          foreign key (seller_id) references sellers(id),
          unique (sku),
          unique (slug),
          check (price > 0),
          check (discount_pct >= 0)
      )
      partition by date(created_at)
      cluster by category_id, seller_id
      ;
      
    assert 'create table...eller_id\n;\n' == 'create table...eller_id\n;\n'
      
      - create table products (
      ?                      -
      + create table products(
            product_id int64 not null,
            category_id int64 not null,
            seller_id int64,...
      
      ...Full output truncated (30 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae74569d9d0>
    fixture_id = 202
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_unformatted_reaches_preformatted(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            Formatting the unformatted fixture must produce the preformatted fixture
            exactly.
            At base commit: FAILS (no DDL implementation).
            """
            pre_path = _require_fixture("preformatted", fixture_id)
            unf_path = _require_fixture("unformatted", fixture_id)
            expected = pre_path.read_text(encoding="utf-8")
            source = unf_path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == expected, (
                f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
                f"Expected:\n{expected}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 202: unformatted → preformatted failed.
    E         Expected:
    E         create table products (
    E             product_id int64 not null,
    E             category_id int64 not null,
    E             seller_id int64,
    E             sku string not null,
    E             name string not null,
    E             slug string not null,
    E             description string,
    E             price numeric(10, 2) not null,
    E             compare_at_price numeric(10, 2),
    E             cost_price numeric(10, 2),
    E             discount_pct numeric(5, 2) default 0,
    E             stock_qty int64 default 0 not null,
    E             weight_g int64,
    E             length_mm int64,
    E             width_mm int64,
    E             height_mm int64,
    E             is_active bool default true not null,
    E             is_featured bool default false,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             specs array<struct<attr string, val string>>,
    E             primary key (product_id),
    E             foreign key (category_id) references categories(id),
    E             foreign key (seller_id) references sellers(id),
    E             unique (sku),
    E             unique (slug),
    E             check (price > 0),
    E             check (discount_pct >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by category_id, seller_id
    E         ;
    E         
    E         Got:
    E         create table products(
    E             product_id int64 not null,
    E             category_id int64 not null,
    E             seller_id int64,
    E             sku string not null,
    E             name string not null,
    E             slug string not null,
    E             description string,
    E             price numeric(10, 2) not null,
    E             compare_at_price numeric(10, 2),
    E             cost_price numeric(10, 2),
    E             discount_pct numeric(5, 2) default 0,
    E             stock_qty int64 default 0 not null,
    E             weight_g int64,
    E             length_mm int64,
    E             width_mm int64,
    E             height_mm int64,
    E             is_active bool default true not null,
    E             is_featured bool default false,
    E             created_at timestamp not null,
    E             updated_at timestamp,
    E             tags array<string>,
    E             specs array<struct<attr string, val string>>,
    E             primary key (product_id),
    E             foreign key (category_id) references categories(id),
    E             foreign key (seller_id) references sellers(id),
    E             unique (sku),
    E             unique (slug),
    E             check (price > 0),
    E             check (discount_pct >= 0)
    E         )
    E         partition by date(created_at)
    E         cluster by category_id, seller_id
    E         ;
    E         
    E       assert 'create table...eller_id\n;\n' == 'create table...eller_id\n;\n'
    E         
    E         - create table products (
    E         ?                      -
    E         + create table products(
    E               product_id int64 not null,
    E               category_id int64 not null,
    E               seller_id int64,...
    E         
    E         ...Full output truncated (30 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:89: AssertionError
[verifier] ✗ [f2p] tests.functional_tests.test_create_table_functional.TestCreateTableFixtureRoundTrip.test_unformatted_reaches_preformatted[203]
    AssertionError: Fixture 203: unformatted → preformatted failed.
      Expected:
      create table audit_log (
          log_id int64 not null,
          tenant_id int64 not null,
          table_name string not null,
          schema_name string default 'public' not null,
          operation string not null,
          actor_id int64 not null,
          actor_name string,
          record_id string not null,
          record_type string,
          old_values string,
          new_values string,
          diff_values string,
          ip_address string,
          user_agent string,
          session_id string,
          request_id string,
          changed_by string,
          change_reason string,
          environment string default 'production',
          correlation_id string,
          occurred_at timestamp not null,
          constraint chk_operation check (operation in('insert', 'update', 'delete')),
          primary key (log_id),
          foreign key (actor_id) references users(id)
      )
      partition by date(occurred_at)
      ;
      
      Got:
      create table audit_log(
          log_id int64 not null,
          tenant_id int64 not null,
          table_name string not null,
          schema_name string default 'public' not null,
          operation string not null,
          actor_id int64 not null,
          actor_name string,
          record_id string not null,
          record_type string,
          old_values string,
          new_values string,
          diff_values string,
          ip_address string,
          user_agent string,
          session_id string,
          request_id string,
          changed_by string,
          change_reason string,
          environment string default 'production',
          correlation_id string,
          occurred_at timestamp not null,
          constraint chk_operation check (operation in ('insert', 'update', 'delete')),
          primary key (log_id),
          foreign key (actor_id) references users(id)
      )
      partition by date(occurred_at)
      ;
      
    assert 'create table...rred_at)\n;\n' == 'create table...rred_at)\n;\n'
      
      - create table audit_log (
      ?                       -
      + create table audit_log(
            log_id int64 not null,
            tenant_id int64 not null,
            table_name string not null,...
      
      ...Full output truncated (26 lines hidden), use '-vv' to show
    self = <test_create_table_functional.TestCreateTableFixtureRoundTrip object at 0x2ae7457276e0>
    fixture_id = 203
    default_mode = Mode(SQL_EXTENSIONS=['.sql', '.sql.jinja'], dialect_name='polyglot', line_length=88, check=False, diff=False, exclude=...jinjafmt=False, reset_cache=False, verbose=False, quiet=False, no_progressbar=False, no_color=False, force_color=False)
    
        def test_unformatted_reaches_preformatted(
            self, fixture_id: int, default_mode: Mode
        ) -> None:
            """
            Formatting the unformatted fixture must produce the preformatted fixture
            exactly.
            At base commit: FAILS (no DDL implementation).
            """
            pre_path = _require_fixture("preformatted", fixture_id)
            unf_path = _require_fixture("unformatted", fixture_id)
            expected = pre_path.read_text(encoding="utf-8")
            source = unf_path.read_text(encoding="utf-8")
            result = format_string(source, default_mode)
    >       assert result == expected, (
                f"Fixture {fixture_id}: unformatted → preformatted failed.\n"
                f"Expected:\n{expected}\nGot:\n{result}"
            )
    E       AssertionError: Fixture 203: unformatted → preformatted failed.
    E         Expected:
    E         create table audit_log (
    E             log_id int64 not null,
    E             tenant_id int64 not null,
    E             table_name string not null,
    E             schema_name string default 'public' not null,
    E             operation string not null,
    E             actor_id int64 not null,
    E             actor_name string,
    E             record_id string not null,
    E             record_type string,
    E             old_values string,
    E             new_values string,
    E             diff_values string,
    E             ip_address string,
    E             user_agent string,
    E             session_id string,
    E             request_id string,
    E             changed_by string,
    E             change_reason string,
    E             environment string default 'production',
    E             correlation_id string,
    E             occurred_at timestamp not null,
    E             constraint chk_operation check (operation in('insert', 'update', 'delete')),
    E             primary key (log_id),
    E             foreign key (actor_id) references users(id)
    E         )
    E         partition by date(occurred_at)
    E         ;
    E         
    E         Got:
    E         create table audit_log(
    E             log_id int64 not null,
    E             tenant_id int64 not null,
    E             table_name string not null,
    E             schema_name string default 'public' not null,
    E             operation string not null,
    E             actor_id int64 not null,
    E             actor_name string,
    E             record_id string not null,
    E             record_type string,
    E             old_values string,
    E             new_values string,
    E             diff_values string,
    E             ip_address string,
    E             user_agent string,
    E             session_id string,
    E             request_id string,
    E             changed_by string,
    E             change_reason string,
    E             environment string default 'production',
    E             correlation_id string,
    E             occurred_at timestamp not null,
    E             constraint chk_operation check (operation in ('insert', 'update', 'delete')),
    E             primary key (log_id),
    E             foreign key (actor_id) references users(id)
    E         )
    E         partition by date(occurred_at)
    E         ;
    E         
    E       assert 'create table...rred_at)\n;\n' == 'create table...rred_at)\n;\n'
    E         
    E         - create table audit_log (
    E         ?                       -
    E         + create table audit_log(
    E               log_id int64 not null,
    E               tenant_id int64 not null,
    E               table_name string not null,...
    E         
    E         ...Full output truncated (26 lines hidden), use '-vv' to show
    
    tests/functional_tests/test_create_table_functional.py:89: AssertionError
P2P 1269/1273 pass 4 fail; F2P 28/32 pass 4 fail; PARTIAL 0.9938697318007663; BINARY 0
[verifier] reward.json={"reward": 0, "f2p_total": 32, "f2p_passed": 28, "p2p_total": 1273, "p2p_passed": 1269, "f2p": 0.875, "p2p": 0.9968578161822467, "partial": 0.9938697318007663}
