Function compareInVsAnyValues

backend/plugin/schema/differ.go:1207–1244

compareInVsAnyValues compares the values in IN syntax vs ANY syntax

(inExpr, anyExpr string)

// compareInVsAnyValues compares the values in IN syntax vs ANY syntax
func compareInVsAnyValues(inExpr, anyExpr string) bool {
	// Extract values from IN expression: "column IN('A', 'B')"
	inValues := extractInValues(inExpr)
	if inValues == nil {
		return false
	}

	// Extract values from ANY expression: "(column = ANY (ARRAY['A'::text, 'B'::text]))"
	anyValues := extractAnyValues(anyExpr)
	if anyValues == nil {
		return false
	}

	// Compare the value sets
	if len(inValues) != len(anyValues) {
		return false
	}

	// Convert both to maps for comparison (order doesn't matter)
	inMap := make(map[string]bool)
	for _, v := range inValues {
		inMap[v] = true
	}

	anyMap := make(map[string]bool)
	for _, v := range anyValues {
		anyMap[v] = true
	}

	// Check if they contain the same values
	for v := range inMap {
		if !anyMap[v] {
			return false
		}
	}

	return true
}

// extractInValues extracts values from "column IN('A', 'B')" format
func extractInValues(expr string) []string {