Function TestWindowFunctionSQL

pkg/sql/ast/sql_test.go:224–233

(t *testing.T)

}

func TestWindowFunctionSQL(t *testing.T) {
	stmt := &SelectStatement{
		Columns: []Expression{&FunctionCall{Name: "ROW_NUMBER", Over: &WindowSpec{PartitionBy: []Expression{&Identifier{Name: "dept_id"}}, OrderBy: []OrderByExpression{{Expression: &Identifier{Name: "salary"}, Ascending: false}}}}},
		From:    []TableReference{{Name: "employees"}},
	}
	want := "SELECT ROW_NUMBER() OVER (PARTITION BY dept_id ORDER BY salary DESC) FROM employees"
	if got := stmt.SQL(); got != want {
		t.Errorf("SQL() =\n  %s\nwant:\n  %s", got, want)
	}
}

func TestCTESQL(t *testing.T) {
	inner := &SelectStatement{Columns: []Expression{&Identifier{Name: "*"}}, From: []TableReference{{Name: "orders"}}, Where: &BinaryExpression{Left: &Identifier{Name: "total"}, Operator: ">", Right: &LiteralValue{Value: 100, Type: "INTEGER"}}}