Function extractAnyValues

backend/plugin/schema/differ.go:1287–1319

extractAnyValues extracts values from "(column = ANY (ARRAY['A'::text, 'B'::text]))" format

(expr string)

// extractAnyValues extracts values from "(column = ANY (ARRAY['A'::text, 'B'::text]))" format
func extractAnyValues(expr string) []string {
	// Find the ARRAY part
	arrayIndex := strings.Index(expr, "ARRAY[")
	if arrayIndex == -1 {
		return nil
	}

	// Find the closing bracket
	closeBracket := strings.Index(expr[arrayIndex:], "]")
	if closeBracket == -1 {
		return nil
	}
	closeBracket += arrayIndex

	// Extract the values part
	valuesStr := expr[arrayIndex+6 : closeBracket] // Skip "ARRAY["

	// Split by comma and clean up
	var values []string
	parts := strings.Split(valuesStr, ",")
	for _, part := range parts {
		part = strings.TrimSpace(part)
		// Remove ::text suffix and quotes
		part = strings.TrimSuffix(part, "::text")
		if (part[0] == '\'' && part[len(part)-1] == '\'') ||
			(part[0] == '"' && part[len(part)-1] == '"') {
			part = part[1 : len(part)-1]
		}
		values = append(values, part)
	}

	return values
}

// comparePartitions compares two lists of partitions.
func comparePartitions(engine storepb.Engine, oldPartitions, newPartitions []*storepb.TablePartitionMetadata) []*PartitionDiff {