Skip to content

Bytea Literal Format Incompatible with PostgreSQL #32

@richardwooding

Description

@richardwooding

Summary

Generated bytea literals use invalid PostgreSQL syntax.

Location

cel2sql.go:1008-1011

Issue

Code generates bytea literals as b"..." which PostgreSQL doesn't recognize. PostgreSQL expects hex format or escape format.

Impact

High - Queries with byte values will fail with syntax errors.

Recommendation

Use hex format:

import "encoding/hex"

case *exprpb.Constant_BytesValue:
    b := c.GetBytesValue()
    con.str.WriteString("'\\x")
    con.str.WriteString(hex.EncodeToString(b))
    con.str.WriteString("'")

Metadata

Metadata

Assignees

No one assigned

    Labels

    category::correctnessSQL correctness and PostgreSQL compatibilityseverity::highImportant issues that significantly impact functionality

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions