Interleaved scopes could interfere

CREATE SCOPE test.test;

USE test.test;

CREATE COLLECTION MyCollection PRIMARY KEY (id:int); 

CREATE SCOPE test; 

USE test;

CREATE COLLECTION MyCollection PRIMARY KEY (id:int); 

DROP SCOPE test;

-- After this, files of both scopes "test" and "test.test" are deleted

-- Metadata datasets still hold information about "test.test" as if it exists

DROP SCOPE test.test;

-- This throws an error:

-- Resource does not exist for storage/partition_3/test/^test/MyCollection/0/MyCollection