Function TestProtocolDataTypes

tests/integration/protocol_test.go:391–474

TestProtocolDataTypes tests that various data types are correctly transmitted

(t *testing.T)

// TestProtocolDataTypes tests that various data types are correctly transmitted
func TestProtocolDataTypes(t *testing.T) {
	t.Run("integer", func(t *testing.T) {
		var val int64
		err := testHarness.DuckgresDB.QueryRow("SELECT 9223372036854775807").Scan(&val)
		if err != nil {
			t.Fatalf("Query failed: %v", err)
		}
		if val != 9223372036854775807 {
			t.Errorf("Expected 9223372036854775807, got %d", val)
		}
	})

	t.Run("float", func(t *testing.T) {
		var val float64
		err := testHarness.DuckgresDB.QueryRow("SELECT 3.14159265358979::DOUBLE PRECISION").Scan(&val)
		if err != nil {
			t.Fatalf("Query failed: %v", err)
		}
		if val < 3.14 || val > 3.15 {
			t.Errorf("Expected ~3.14, got %f", val)
		}
	})

	t.Run("boolean_true", func(t *testing.T) {
		var val bool
		err := testHarness.DuckgresDB.QueryRow("SELECT TRUE").Scan(&val)
		if err != nil {
			t.Fatalf("Query failed: %v", err)
		}
		if !val {
			t.Error("Expected true")
		}
	})

	t.Run("boolean_false", func(t *testing.T) {
		var val bool
		err := testHarness.DuckgresDB.QueryRow("SELECT FALSE").Scan(&val)
		if err != nil {
			t.Fatalf("Query failed: %v", err)
		}
		if val {
			t.Error("Expected false")
		}
	})

	t.Run("text", func(t *testing.T) {
		var val string
		err := testHarness.DuckgresDB.QueryRow("SELECT 'hello, world!'::TEXT").Scan(&val)
		if err != nil {
			t.Fatalf("Query failed: %v", err)
		}
		if val != "hello, world!" {
			t.Errorf("Expected 'hello, world!', got %q", val)
		}
	})

	t.Run("bytes", func(t *testing.T) {
		skipIfKnown(t)