Method convertAggregateFuncExpr

internal/engine/dolphin/convert.go:739–786

(n *pcast.AggregateFuncExpr)

}

func (c *cc) convertAggregateFuncExpr(n *pcast.AggregateFuncExpr) *ast.FuncCall {
	name := strings.ToLower(n.F)
	fn := &ast.FuncCall{
		Func: &ast.FuncName{
			Name: name,
		},
		Funcname: &ast.List{
			Items: []ast.Node{
				NewIdentifier(name),
			},
		},
		Args:     &ast.List{},
		AggOrder: &ast.List{},
	}

	// GROUP_CONCAT has special handling:
	// TiDB always adds the separator as the last argument
	// We need to extract it and use SEPARATOR syntax
	args := n.Args
	var separator string
	if name == "group_concat" && len(args) >= 2 {
		// The last arg is always the separator
		if value, ok := args[len(args)-1].(*driver.ValueExpr); ok {
			separator = value.GetString()
			args = args[:len(args)-1]
		}
	}

	for _, a := range args {
		if value, ok := a.(*driver.ValueExpr); ok {
			if value.GetInt64() == int64(1) {
				fn.AggStar = true
				continue
			}
		}
		fn.Args.Items = append(fn.Args.Items, c.convert(a))
	}
	if n.Distinct {
		fn.AggDistinct = true
	}

	// Store separator for GROUP_CONCAT (only if non-default)
	if name == "group_concat" && separator != "" && separator != "," {
		fn.Separator = &separator
	}

	return fn
}

func (c *cc) convertAlterDatabaseStmt(n *pcast.AlterDatabaseStmt) ast.Node {
	return todo(n)