Function TEST_F

test/api/drop_index_test.cpp:45–76

Drop the default hash PK index after inserting data; the index should disappear from storage while rows remain queryable through the PK-scan fallback.

// Drop the default hash PK index after inserting data; the index should disappear from storage
// while rows remain queryable through the PK-scan fallback.
TEST_F(DropIndexTest, DropDefaultHashIndex) {
    auto& con = *conn;
    assertQuery(*con.query("CREATE NODE TABLE diperson(ID INT64, name STRING, PRIMARY KEY(ID))"));
    const auto& pkIndexName = PK_INDEX_NAME;
    // The default hash PK index should be present.
    ASSERT_TRUE(getNodeTable("diperson").tryGetPKIndex() != nullptr);

    assertQuery(*con.query("CREATE (:diperson {ID: 1, name: 'Alice'})"));
    assertQuery(*con.query("CREATE (:diperson {ID: 2, name: 'Bob'})"));
    assertQuery(*con.query("CREATE (:diperson {ID: 3, name: 'Carol'})"));

    auto dropResult = con.query(std::format("DROP INDEX diperson.{}", pkIndexName));
    assertQuery(*dropResult);
    EXPECT_EQ(TestHelper::convertResultToString(*dropResult),
        std::vector<std::string>{std::format("Index {} has been dropped.", pkIndexName)});

    // Index is gone from both storage and catalog.
    EXPECT_EQ(getNodeTable("diperson").tryGetPKIndex(), nullptr);
    auto* catalog = database->getCatalog();
    auto* entry = catalog->getTableCatalogEntry(&DUMMY_CHECKPOINT_TRANSACTION, "diperson")
                      ->ptrCast<NodeTableCatalogEntry>();
    EXPECT_FALSE(
        catalog->containsIndex(&DUMMY_CHECKPOINT_TRANSACTION, entry->getTableID(), pkIndexName));

    // Rows are still queryable via the PK-scan fallback (no index).
    auto res = con.query("MATCH (p:diperson) WHERE p.ID = 2 RETURN p.name");
    assertQuery(*res);
    EXPECT_EQ(TestHelper::convertResultToString(*res), std::vector<std::string>{"Bob"});
    auto countRes = con.query("MATCH (p:diperson) RETURN COUNT(*)");
    assertQuery(*countRes);
    EXPECT_EQ(TestHelper::convertResultToString(*countRes), std::vector<std::string>{"3"});
}

// Dropping a non-existent index without IF EXISTS must error.
TEST_F(DropIndexTest, DropNonExistentIndexThrows) {