Function collectCTENames

backend/plugin/parser/mysql/backup.go:280–286

collectCTENames extracts CTE names from the SQL text before the statement Loc. MySQL's UPDATE/DELETE CTEs are not in the omni AST, so we parse the prefix.

(fullSQL string, stmtLoc ast.Loc)

// collectCTENames extracts CTE names from the SQL text before the statement Loc.
// MySQL's UPDATE/DELETE CTEs are not in the omni AST, so we parse the prefix.
func collectCTENames(fullSQL string, stmtLoc ast.Loc) map[string]bool {
	result := make(map[string]bool)
	for _, cte := range parseCTEPrefix(fullSQL, stmtLoc) {
		result[cte.Name] = true
	}
	return result
}

// extractCTE extracts the CTE (WITH clause) text from the SQL before the statement.
func extractCTE(fullSQL string, stmtLoc ast.Loc) string {