Function remove_nonempty_table_fails

crates/engine/src/update.rs:935–966

()

    #[test]
    fn remove_nonempty_table_fails() -> anyhow::Result<()> {
        let auth_ctx = AuthCtx::for_testing();
        let stdb = TestDB::durable()?;

        let old = single_table_module();
        let new = empty_module();

        let mut tx = begin_mut_tx(&stdb);
        for def in old.tables() {
            create_table_from_def(&stdb, &mut tx, &old, def)?;
        }
        let table_id = stdb
            .table_id_from_name_mut(&tx, "droppable")?
            .expect("table should exist");
        insert(&stdb, &mut tx, table_id, &product![42u64])?;
        stdb.commit_tx(tx)?;

        let mut tx = begin_mut_tx(&stdb);
        let plan = ponder_migrate(&old, &new)?;
        let result = update_database(&stdb, &mut tx, auth_ctx, plan, &TestLogger);
        let err = result.err().expect("removing a non-empty table should fail");
        assert!(
            err.to_string().contains("table contains data"),
            "error should mention that the table contains data, got: {err}"
        );
        assert!(
            tx.pending_schema_changes().is_empty(),
            "failed migration should leave no pending schema changes: {:?}",
            tx.pending_schema_changes()
        );
        Ok(())
    }

    /// Verifies that `autoinc` sequence survives a schema migration that adds a column,
    /// and is also correctly persisted across database replay.