`pgtype.JSONB.Set` does not throw error on unsupported data types for `interface{}` fields but fails on `reflect.DeepEqual`

[bohrasankalp]

When attempting to use pgtype.JSONB.Set to assign interface{} data that is JSON-like (such as a map or a struct) but does not conform to JSONB’s expected format, Set completes successfully, implying compatibility. However, checking with reflect.DeepEqual reveals that the data has not been assigned correctly. The expected behavior would be for Set to return an error when encountering incompatible data structures, as this would make troubleshooting simpler and avoid silent errors in JSONB assignments.

Sample snippet

func CreatePageContent(ctx context.Context, conn *pgx.Conn, pageID int64, data interface{}) (PageContent, error) {
    QTAG := "Q_CREATE_PAGE_CONTENT"

    // Initialize JSONB object
    details := &pgtype.JSONB{}

    // Attempt to set data in JSONB
    if err := details.Set(data); err != nil {
        return PageContent{}, errors.Wrapf(err, "query error (qtag=%s)", QTAG)
    }

    // Use DeepEqual to verify
    if !reflect.DeepEqual(details, data) {
        // Expecting Set to fail, but it does not
        fmt.Printf("Set succeeded, but data was not equivalent. details: %v, data: %v\n", details, data)
    }

    return PageContent{}, nil
}

data is like {"data":"some complex string read from files, could have new line\n, tabs \t or white space character or any indefinite character, whatever possible case."}