param_cast_oid_test.go 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. package pgserver
  2. import (
  3. "context"
  4. "testing"
  5. )
  6. // A bound parameter is inlined as a literal, but that literal is not a
  7. // user-written constant: casts over parameters must keep the carrier OID so
  8. // result metadata does not depend on the bound value.
  9. func TestParameterCastKeepsCarrierOID(t *testing.T) {
  10. conn := connectPGX(t)
  11. defer conn.Close(context.Background())
  12. cases := []struct {
  13. query string
  14. arg any
  15. want uint32
  16. }{
  17. {"SELECT $1::SMALLINT", int16(1), 20},
  18. {"SELECT $1::SMALLINT", int64(40000), 20},
  19. {"SELECT $1::INTEGER", int32(1), 20},
  20. {"SELECT $1::REAL", float32(1.5), 701},
  21. }
  22. for _, tc := range cases {
  23. rows, err := conn.Query(context.Background(), tc.query, tc.arg)
  24. if err != nil {
  25. t.Fatalf("%s: %v", tc.query, err)
  26. }
  27. fields := rows.FieldDescriptions()
  28. if len(fields) != 1 || fields[0].DataTypeOID != tc.want {
  29. t.Fatalf("%s: got %v, want OID %d", tc.query, fields, tc.want)
  30. }
  31. rows.Close()
  32. }
  33. // User-written literals still report their exact width.
  34. rows, err := conn.Query(context.Background(), "SELECT 1::SMALLINT")
  35. if err != nil {
  36. t.Fatal(err)
  37. }
  38. if got := rows.FieldDescriptions()[0].DataTypeOID; got != 21 {
  39. t.Fatalf("literal SMALLINT cast OID = %d, want 21", got)
  40. }
  41. rows.Close()
  42. }