Function TestParser_IntervalExpression_Simple

pkg/sql/parser/interval_test.go:28–76

TestParser_IntervalExpression_Simple tests basic INTERVAL expression parsing

(t *testing.T)

// TestParser_IntervalExpression_Simple tests basic INTERVAL expression parsing
func TestParser_IntervalExpression_Simple(t *testing.T) {
	sql := "SELECT INTERVAL '1 day'"

	// Tokenize the SQL
	tkz := tokenizer.GetTokenizer()
	defer tokenizer.PutTokenizer(tkz)

	tokens, err := tkz.Tokenize([]byte(sql))
	if err != nil {
		t.Fatalf("tokenizer error: %v", err)
	}

	// Convert to parser tokens

	parser := NewParser()
	defer parser.Release()

	tree, err := parser.ParseFromModelTokens(tokens)
	if err != nil {
		t.Fatalf("unexpected error: %v", err)
	}
	defer ast.ReleaseAST(tree)

	if len(tree.Statements) != 1 {
		t.Fatalf("expected 1 statement, got %d", len(tree.Statements))
	}

	stmt, ok := tree.Statements[0].(*ast.SelectStatement)
	if !ok {
		t.Fatalf("expected SelectStatement, got %T", tree.Statements[0])
	}

	if len(stmt.Columns) != 1 {
		t.Fatalf("expected 1 column, got %d", len(stmt.Columns))
	}

	intervalExpr, ok := stmt.Columns[0].(*ast.IntervalExpression)
	if !ok {
		t.Fatalf("expected IntervalExpression, got %T", stmt.Columns[0])
	}

	if intervalExpr.Value != "1 day" {
		t.Errorf("expected interval value '1 day', got '%s'", intervalExpr.Value)
	}

	if intervalExpr.TokenLiteral() != "INTERVAL" {
		t.Errorf("expected TokenLiteral 'INTERVAL', got '%s'", intervalExpr.TokenLiteral())
	}
}

// TestParser_IntervalExpression_WithArithmetic tests INTERVAL in arithmetic expressions
func TestParser_IntervalExpression_WithArithmetic(t *testing.T) {