| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- package pgserver
- import (
- "context"
- "strconv"
- "testing"
- )
- // TestPGXNumericScalarIsFloat8 pins the chosen scalar NUMERIC contract: a
- // NUMERIC column and a NUMERIC cast are reported as float8 (701), so pgx scans
- // them as float64 and loses digits beyond float64 precision. NUMERIC[] keeps
- // exact element text and reports numeric[] (1231).
- func TestPGXNumericScalarIsFloat8(t *testing.T) {
- conn := connectPGX(t)
- ctx := context.Background()
- for _, sql := range []string{
- `CREATE TABLE amounts (id INTEGER PRIMARY KEY, amount NUMERIC, history NUMERIC[])`,
- `INSERT INTO amounts VALUES (1, '12345678901234567890.50', '{12345678901234567890.50,1.10}')`,
- } {
- if _, err := conn.Exec(ctx, sql); err != nil {
- t.Fatalf("%s: %v", sql, err)
- }
- }
- rows, err := conn.Query(ctx, `SELECT amount FROM amounts WHERE id = 1`)
- if err != nil {
- t.Fatalf("query: %v", err)
- }
- if oid := rows.FieldDescriptions()[0].DataTypeOID; oid != 701 {
- t.Fatalf("numeric column OID = %d, want 701 (float8)", oid)
- }
- if !rows.Next() {
- t.Fatal("no row returned")
- }
- var amount float64
- if err := rows.Scan(&amount); err != nil {
- t.Fatalf("scan numeric as float64: %v", err)
- }
- want, err := strconv.ParseFloat("12345678901234567890.50", 64)
- if err != nil {
- t.Fatalf("parse expected value: %v", err)
- }
- if amount != want {
- t.Fatalf("numeric value = %v, want the float64 rounding %v", amount, want)
- }
- if err := rows.Err(); err != nil {
- t.Fatalf("rows: %v", err)
- }
- rows.Close()
- rows, err = conn.Query(ctx, `SELECT 1::NUMERIC`)
- if err != nil {
- t.Fatalf("query cast: %v", err)
- }
- defer rows.Close()
- if oid := rows.FieldDescriptions()[0].DataTypeOID; oid != 701 {
- t.Fatalf("numeric cast OID = %d, want 701 (float8)", oid)
- }
- var cast float64
- if !rows.Next() {
- t.Fatal("no row returned for the cast")
- }
- if err := rows.Scan(&cast); err != nil || cast != 1 {
- t.Fatalf("numeric cast scan = %v, %v; want 1", cast, err)
- }
- }
- // TestPGXNumericArrayKeepsExactText is the other half of the contract: an array
- // of NUMERIC stays exact, so pgx reads back every digit and trailing zero.
- func TestPGXNumericArrayKeepsExactText(t *testing.T) {
- conn := connectPGX(t)
- ctx := context.Background()
- for _, sql := range []string{
- `CREATE TABLE amounts (id INTEGER PRIMARY KEY, history NUMERIC[])`,
- `INSERT INTO amounts VALUES (1, '{12345678901234567890.50,1.10}')`,
- } {
- if _, err := conn.Exec(ctx, sql); err != nil {
- t.Fatalf("%s: %v", sql, err)
- }
- }
- rows, err := conn.Query(ctx, `SELECT history FROM amounts WHERE id = 1`)
- if err != nil {
- t.Fatalf("query: %v", err)
- }
- defer rows.Close()
- if oid := rows.FieldDescriptions()[0].DataTypeOID; oid != 1231 {
- t.Fatalf("numeric[] OID = %d, want 1231", oid)
- }
- if !rows.Next() {
- t.Fatal("no row returned")
- }
- var history []string
- if err := rows.Scan(&history); err != nil {
- t.Fatalf("scan numeric[]: %v", err)
- }
- want := []string{"12345678901234567890.50", "1.10"}
- if len(history) != len(want) {
- t.Fatalf("numeric[] = %v, want %v", history, want)
- }
- for i := range want {
- if history[i] != want[i] {
- t.Fatalf("numeric[] = %v, want %v", history, want)
- }
- }
- }
|