Materialize/test/sqllogictest/serial-ddl.slt

# Copyright Materialize, Inc. and contributors. All rights reserved.
#
# Use of this software is governed by the Business Source License
# included in the LICENSE file at the root of this repository.
#
# As of the Change Date specified in that file, in accordance with
# the Business Source License, use of this software will be governed
# by the Apache License, Version 2.0.

# Test that delayed single statement DDL doesn't block other DDLs while mid transaction.

mode cockroach

simple conn=conn1
BEGIN;
CREATE VIEW serial_ddl_v AS SELECT 1;
----
COMPLETE 0
COMPLETE 0

# While conn1 has an open txn and is in single statement delayed txn mode, execute a DDL in another
# connection which should not be blocked and succeed.

simple conn=conn2
BEGIN;
CREATE VIEW serial_ddl_w AS SELECT 1;
----
COMPLETE 0
COMPLETE 0

simple conn=conn1
COMMIT;
----
COMPLETE 0