Function TestBetweenExpression

pkg/sql/ast/nodes_test.go:1075–1125

Test BetweenExpression node

(t *testing.T)

// Test BetweenExpression node
func TestBetweenExpression(t *testing.T) {
	tests := []struct {
		name         string
		betweenExpr  *BetweenExpression
		wantLiteral  string
		wantChildren int
	}{
		{
			name: "simple BETWEEN expression",
			betweenExpr: &BetweenExpression{
				Expr:  &Identifier{Name: "age"},
				Lower: &LiteralValue{Value: "18"},
				Upper: &LiteralValue{Value: "65"},
				Not:   false,
			},
			wantLiteral:  "BETWEEN",
			wantChildren: 3,
		},
		{
			name: "NOT BETWEEN expression",
			betweenExpr: &BetweenExpression{
				Expr:  &Identifier{Name: "price"},
				Lower: &LiteralValue{Value: "100"},
				Upper: &LiteralValue{Value: "500"},
				Not:   true,
			},
			wantLiteral:  "BETWEEN",
			wantChildren: 3,
		},
	}

	for _, tt := range tests {
		tt := tt // G601: Create local copy to avoid memory aliasing
		t.Run(tt.name, func(t *testing.T) {
			// Test TokenLiteral
			if got := tt.betweenExpr.TokenLiteral(); got != tt.wantLiteral {
				t.Errorf("BetweenExpression.TokenLiteral() = %v, want %v", got, tt.wantLiteral)
			}

			// Test Children
			children := tt.betweenExpr.Children()
			if len(children) != tt.wantChildren {
				t.Errorf("BetweenExpression.Children() count = %d, want %d", len(children), tt.wantChildren)
			}

			// Test that it implements Expression interface
			var _ Expression = tt.betweenExpr
			tt.betweenExpr.expressionNode()
		})
	}
}

// Test UnaryExpression node
func TestUnaryExpression(t *testing.T) {