Function TestPutSelectStatementWithContent

pkg/sql/ast/coverage_test.go:579–605

TestPutSelectStatementWithContent tests returning SELECT statements to pool

(t *testing.T)

// TestPutSelectStatementWithContent tests returning SELECT statements to pool
func TestPutSelectStatementWithContent(t *testing.T) {
	sel := GetSelectStatement()
	sel.Distinct = true
	sel.Columns = []Expression{
		&Identifier{Name: "id"},
		&FunctionCall{Name: "COUNT", Arguments: []Expression{&Identifier{Name: "*"}}},
	}
	sel.From = []TableReference{
		{Name: "users"},
	}
	sel.Where = &BinaryExpression{
		Left:     &Identifier{Name: "active"},
		Right:    &LiteralValue{Value: true},
		Operator: "=",
	}
	sel.GroupBy = []Expression{&Identifier{Name: "department"}}
	sel.Having = &BinaryExpression{
		Left:     &FunctionCall{Name: "COUNT", Arguments: []Expression{&Identifier{Name: "*"}}},
		Right:    &LiteralValue{Value: 10},
		Operator: ">=",
	}
	sel.OrderBy = []OrderByExpression{
		{Expression: &Identifier{Name: "name"}, Ascending: true},
	}

	PutSelectStatement(sel)
}

// TestPutIdentifierWithContent tests returning Identifiers to pool
func TestPutIdentifierWithContent(t *testing.T) {