Function TestByteaOutputFormats

encode_test.go:331–366

(t *testing.T)

}

func TestByteaOutputFormats(t *testing.T) {
	t.Parallel()
	db := pqtest.MustDB(t)
	for _, format := range []string{"hex", "escape"} {
		t.Run("", func(t *testing.T) {
			// Use transaction to avoid relying on getting the same connection
			tx := pqtest.Begin(t, db)
			pqtest.Exec(t, tx, `set local bytea_output to `+format)

			rows := pqtest.Query[[]byte](t, tx, `select decode('5c7800ff6162630108', 'hex')`)
			want := []byte("\x5c\x78\x00\xff\x61\x62\x63\x01\x08")
			if !bytes.Equal(rows[0]["decode"], want) {
				t.Errorf("\nhave: %v\nwant: %v", rows[0]["decode"], want)
			}

			{ // Same but with Prepare
				stmt := pqtest.Prepare(t, tx, `select decode('5c7800ff6162630108', 'hex')`, db)
				rows, err := stmt.Query()
				if err != nil {
					t.Fatal(err)
				}
				if !rows.Next() {
					t.Fatal(rows.Err())
				}
				var have []byte
				err = rows.Scan(&have)
				if err != nil {
					t.Fatal(err)
				}
				if !bytes.Equal(have, want) {
					t.Errorf("\nhave: %v\nwant: %v", have, want)
				}
			}
		})
	}
}

func TestAppendEncodedText(t *testing.T) {
	must := func(buf []byte, x any) []byte {