pgx_numeric_test.go 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  1. package pgserver
  2. import (
  3. "context"
  4. "strconv"
  5. "testing"
  6. )
  7. // TestPGXNumericScalarIsFloat8 pins the chosen scalar NUMERIC contract: a
  8. // NUMERIC column and a NUMERIC cast are reported as float8 (701), so pgx scans
  9. // them as float64 and loses digits beyond float64 precision. NUMERIC[] keeps
  10. // exact element text and reports numeric[] (1231).
  11. func TestPGXNumericScalarIsFloat8(t *testing.T) {
  12. conn := connectPGX(t)
  13. ctx := context.Background()
  14. for _, sql := range []string{
  15. `CREATE TABLE amounts (id INTEGER PRIMARY KEY, amount NUMERIC, history NUMERIC[])`,
  16. `INSERT INTO amounts VALUES (1, '12345678901234567890.50', '{12345678901234567890.50,1.10}')`,
  17. } {
  18. if _, err := conn.Exec(ctx, sql); err != nil {
  19. t.Fatalf("%s: %v", sql, err)
  20. }
  21. }
  22. rows, err := conn.Query(ctx, `SELECT amount FROM amounts WHERE id = 1`)
  23. if err != nil {
  24. t.Fatalf("query: %v", err)
  25. }
  26. if oid := rows.FieldDescriptions()[0].DataTypeOID; oid != 701 {
  27. t.Fatalf("numeric column OID = %d, want 701 (float8)", oid)
  28. }
  29. if !rows.Next() {
  30. t.Fatal("no row returned")
  31. }
  32. var amount float64
  33. if err := rows.Scan(&amount); err != nil {
  34. t.Fatalf("scan numeric as float64: %v", err)
  35. }
  36. want, err := strconv.ParseFloat("12345678901234567890.50", 64)
  37. if err != nil {
  38. t.Fatalf("parse expected value: %v", err)
  39. }
  40. if amount != want {
  41. t.Fatalf("numeric value = %v, want the float64 rounding %v", amount, want)
  42. }
  43. if err := rows.Err(); err != nil {
  44. t.Fatalf("rows: %v", err)
  45. }
  46. rows.Close()
  47. rows, err = conn.Query(ctx, `SELECT 1::NUMERIC`)
  48. if err != nil {
  49. t.Fatalf("query cast: %v", err)
  50. }
  51. defer rows.Close()
  52. if oid := rows.FieldDescriptions()[0].DataTypeOID; oid != 701 {
  53. t.Fatalf("numeric cast OID = %d, want 701 (float8)", oid)
  54. }
  55. var cast float64
  56. if !rows.Next() {
  57. t.Fatal("no row returned for the cast")
  58. }
  59. if err := rows.Scan(&cast); err != nil || cast != 1 {
  60. t.Fatalf("numeric cast scan = %v, %v; want 1", cast, err)
  61. }
  62. }
  63. // TestPGXNumericArrayKeepsExactText is the other half of the contract: an array
  64. // of NUMERIC stays exact, so pgx reads back every digit and trailing zero.
  65. func TestPGXNumericArrayKeepsExactText(t *testing.T) {
  66. conn := connectPGX(t)
  67. ctx := context.Background()
  68. for _, sql := range []string{
  69. `CREATE TABLE amounts (id INTEGER PRIMARY KEY, history NUMERIC[])`,
  70. `INSERT INTO amounts VALUES (1, '{12345678901234567890.50,1.10}')`,
  71. } {
  72. if _, err := conn.Exec(ctx, sql); err != nil {
  73. t.Fatalf("%s: %v", sql, err)
  74. }
  75. }
  76. rows, err := conn.Query(ctx, `SELECT history FROM amounts WHERE id = 1`)
  77. if err != nil {
  78. t.Fatalf("query: %v", err)
  79. }
  80. defer rows.Close()
  81. if oid := rows.FieldDescriptions()[0].DataTypeOID; oid != 1231 {
  82. t.Fatalf("numeric[] OID = %d, want 1231", oid)
  83. }
  84. if !rows.Next() {
  85. t.Fatal("no row returned")
  86. }
  87. var history []string
  88. if err := rows.Scan(&history); err != nil {
  89. t.Fatalf("scan numeric[]: %v", err)
  90. }
  91. want := []string{"12345678901234567890.50", "1.10"}
  92. if len(history) != len(want) {
  93. t.Fatalf("numeric[] = %v, want %v", history, want)
  94. }
  95. for i := range want {
  96. if history[i] != want[i] {
  97. t.Fatalf("numeric[] = %v, want %v", history, want)
  98. }
  99. }
  100. }