Function compareViews

backend/plugin/schema/differ.go:1500–1570

compareViews compares views between two schemas.

(engine storepb.Engine, diff *MetadataDiff, schemaName string, oldSchema, newSchema *model.SchemaMetadata)

// compareViews compares views between two schemas.
func compareViews(engine storepb.Engine, diff *MetadataDiff, schemaName string, oldSchema, newSchema *model.SchemaMetadata) {
	// Get the engine-specific view comparer
	comparer := GetViewComparer(engine)
	// Check for dropped views
	for _, viewName := range oldSchema.ListViewNames() {
		if newSchema.GetView(viewName) == nil {
			oldView := oldSchema.GetView(viewName)
			if oldView != nil && !oldView.SkipDump {
				diff.ViewChanges = append(diff.ViewChanges, &ViewDiff{
					Action:     MetadataDiffActionDrop,
					SchemaName: schemaName,
					ViewName:   viewName,
					OldView:    oldView,
				})
			}
		}
	}

	// Check for new and modified views
	for _, viewName := range newSchema.ListViewNames() {
		newView := newSchema.GetView(viewName)
		if newView == nil || newView.SkipDump {
			continue
		}

		oldView := oldSchema.GetView(viewName)
		if oldView == nil {
			diff.ViewChanges = append(diff.ViewChanges, &ViewDiff{
				Action:     MetadataDiffActionCreate,
				SchemaName: schemaName,
				ViewName:   viewName,
				NewView:    newView,
			})
		} else if !oldView.SkipDump {
			// Use engine-specific comparison
			changes, err := comparer.CompareView(oldView, newView)
			if err != nil {
				// Fallback to simple definition comparison on error
				if oldView.Definition != newView.Definition {
					diff.ViewChanges = append(diff.ViewChanges, &ViewDiff{
						Action:     MetadataDiffActionAlter,
						SchemaName: schemaName,
						ViewName:   viewName,
						OldView:    oldView,
						NewView:    newView,
					})
				}
			} else if len(changes) > 0 {
				// Check if any change requires recreation
				requiresRecreation := false
				for _, change := range changes {
					if change.RequiresRecreation {
						requiresRecreation = true
						break
					}
				}

				if requiresRecreation {