Method DropMaterializedViewIndex

backend/store/model/database.go:750–779

DropMaterializedViewIndex drops an index from a materialized view.

(viewName, indexName string)

// DropMaterializedViewIndex drops an index from a materialized view.
func (s *SchemaMetadata) DropMaterializedViewIndex(viewName, indexName string) error {
	mv := s.GetMaterializedView(viewName)
	if mv == nil {
		return errors.Errorf("materialized view %q does not exist in schema %q", viewName, s.proto.Name)
	}

	// Remove from indexes
	newIndexes := make([]*storepb.IndexMetadata, 0, len(mv.Indexes))
	found := false
	for _, idx := range mv.Indexes {
		if s.isObjectCaseSensitive {
			if idx.Name != indexName {
				newIndexes = append(newIndexes, idx)
			} else {
				found = true
			}
		} else {
			if !strings.EqualFold(idx.Name, indexName) {
				newIndexes = append(newIndexes, idx)
			} else {
				found = true
			}
		}
	}
	if !found {
		return errors.Errorf("index %q does not exist on materialized view %q", indexName, viewName)
	}
	mv.Indexes = newIndexes
	return nil
}

// GetDependentViews returns all views that depend on the given table and column.
// This is used to check if a column can be dropped or if a table can be dropped.