🧪 Npgsql PostgreSQL Wire Protocol Test Report

Generated: 2025-09-16 10:26:35

Boilstream Version: 0.7.13

Executive Summary

7
Test Suites
198
Total Tests
147
Passed
3
Failed
🦆 48
DuckDB Limitations

Overall Pass Rate: 98.0%

Test Index

Click to expand test index with reference numbers

ClientTypeParameter

  1. ✅ Binary format
  2. ✅ ClientType
  3. ✅ Complex query
  4. ✅ DATE comparison
  5. ✅ NULL parameters
  6. ✅ NUMERIC + BOOL
  7. ✅ TEXT + INT
  8. ✅ Type inference

DemoTypeTests

  1. ✅ bigint_samples
  2. ✅ blob_samples
  3. ✅ bool_samples
  4. ✅ date_samples
  5. ✅ decimal_samples
  6. ✅ double_samples
  7. ✅ enum_samples
  8. ✅ hugeint_samples
  9. ✅ int_samples
  10. ✅ interval_samples
  11. ✅ json_samples
  12. ✅ list_int_samples
  13. ✅ map_samples
  14. ✅ real_samples
  15. ✅ smallint_samples
  16. ✅ struct_samples
  17. ✅ time_samples
  18. ✅ timestamp_samples
  19. ✅ timestamptz_samples
  20. ✅ tinyint_samples
  21. ✅ ubigint_samples
  22. ✅ uinteger_samples
  23. ✅ usmallint_samples
  24. ✅ utinyint_samples
  25. ✅ uuid_samples
  26. ✅ varchar_samples

MetadataVerification

  1. ✅ ARRAY types
  2. ✅ BIT
  3. ✅ BLOB
  4. 🦆 CHAR with length
  5. ✅ DECIMAL with precision
  6. ✅ INTERVAL with precision
  7. ✅ NUMERIC with precision
  8. ✅ TIME
  9. ✅ TIMESTAMP
  10. 🦆 VARCHAR with length

ParameterTypeInference

  1. 🦆 "char"
  2. ✅ BIGINT
  3. 🦆 BIT VARYING(10)
  4. 🦆 BIT(8)
  5. ✅ BOOL
  6. ✅ BOOLEAN
  7. ✅ BOOLEAN[]
  8. 🦆 BOX
  9. ✅ BYTEA
  10. 🦆 CHAR(10)
  11. 🦆 CIDR
  12. 🦆 CIRCLE
  13. ✅ DATE
  14. 🦆 DATERANGE
  15. ✅ DOUBLE PRECISION
  16. ✅ HUGEINT
  17. 🦆 INET
  18. 🦆 INT4RANGE
  19. ✅ INTEGER
  20. ✅ INTEGER[]
  21. ✅ INTERVAL
  22. ✅ JSON
  23. ✅ JSONB
  24. 🦆 LINE
  25. 🦆 LSEG
  26. 🦆 MACADDR
  27. 🦆 MONEY
  28. ✅ NUMERIC
  29. 🦆 NUMRANGE
  30. 🦆 PATH
  31. 🦆 POINT
  32. 🦆 POLYGON
  33. ✅ REAL
  34. ❌ REGCLASS
  35. 🦆 REGTYPE
  36. ✅ SMALLINT
  37. ✅ TIME
  38. ✅ TIME WITH TIME ZONE
  39. ✅ TIMESTAMP
  40. ✅ TIMESTAMP WITH TIME ZONE
  41. 🦆 TSRANGE
  42. 🦆 TSTZRANGE
  43. ✅ UUID
  44. 🦆 XML

PostgresTypeCoverage

  1. ✅ BOOLEAN[]
  2. ✅ INTEGER[]
  3. ✅ NUMERIC[]
  4. ✅ TEXT[]
  5. ✅ BIT
  6. 🦆 BIT(8)
  7. ✅ BITSTRING
  8. ✅ BYTEA
  9. 🦆 VARBIT
  10. 🦆 VARBIT(16)
  11. ✅ BOOL
  12. ✅ BOOLEAN
  13. ✅ BIGINT
  14. ✅ BIGSERIAL
  15. ✅ DECIMAL
  16. ✅ DOUBLE PRECISION
  17. ✅ INTEGER
  18. ✅ NUMERIC
  19. ✅ NUMERIC(10,2)
  20. ✅ REAL
  21. ✅ SERIAL
  22. ✅ SMALLINT
  23. ✅ DATE
  24. ✅ INTERVAL
  25. ✅ TIME
  26. ✅ TIME WITH TIME ZONE
  27. ✅ TIMESTAMP
  28. ✅ TIMESTAMP WITH TIME ZONE
  29. 🦆 BOX
  30. 🦆 CIRCLE
  31. 🦆 LINE
  32. 🦆 LSEG
  33. 🦆 PATH
  34. 🦆 POINT
  35. 🦆 POLYGON
  36. ✅ JSON
  37. 🦆 JSONB
  38. 🦆 CIDR
  39. ❌ INET
  40. 🦆 MACADDR
  41. 🦆 MACADDR8
  42. ✅ FLOAT
  43. ✅ FLOAT4
  44. ✅ FLOAT8
  45. 🦆 MONEY
  46. ✅ OID
  47. 🦆 PG_LSN
  48. ✅ REGCLASS
  49. ✅ REGPROC
  50. 🦆 REGTYPE
  51. 🦆 TSQUERY
  52. 🦆 TSVECTOR
  53. 🦆 TXID_SNAPSHOT
  54. 🦆 XML
  55. ✅ BPCHAR
  56. ✅ CHAR
  57. ✅ CHAR(10)
  58. ✅ NAME
  59. ✅ TEXT
  60. ✅ VARCHAR
  61. ✅ VARCHAR(50)
  62. ✅ UUID

PreparedStatements

  1. ✅ Simple arithmetic with INTEGER parameters
  2. ✅ Binary: BOOLEAN[]
  3. ✅ Binary: DATE[]
  4. ✅ Binary: DOUBLE PRECISION[]
  5. ✅ Binary: INTEGER[]
  6. ❌ Binary: INTEGER[][] (2D)
  7. ✅ Binary: NUMERIC[]
  8. ✅ Binary: REAL[]
  9. ✅ Binary: TEXT[]
  10. ✅ Binary: TIMESTAMP[]
  11. ✅ Binary: UUID[]
  12. ✅ Binary: BOOLEAN (false)
  13. ✅ Binary: BOOLEAN (true)
  14. 🦆 Binary: BIT
  15. ✅ Binary: BYTEA
  16. ✅ Binary: DATE
  17. ✅ Binary: INTERVAL
  18. ✅ Binary: TIME
  19. ✅ Binary: TIMESTAMP
  20. ✅ Binary: TIMESTAMPTZ
  21. ✅ Binary: JSON
  22. ✅ Binary: JSONB
  23. 🦆 Binary: INET
  24. ✅ Binary: NULL INTEGER
  25. ✅ Binary: NULL TEXT
  26. ✅ Binary: NULL TIMESTAMP
  27. ✅ Binary: BIGINT
  28. ✅ Binary: DOUBLE PRECISION
  29. ✅ Binary: INTEGER
  30. ✅ Binary: NUMERIC
  31. ✅ Binary: NUMERIC(10,2)
  32. ✅ Binary: REAL
  33. ✅ Binary: SMALLINT
  34. 🦆 Binary: CHAR(10)
  35. ✅ Binary: NAME
  36. ✅ Binary: TEXT
  37. ✅ Binary: VARCHAR
  38. ✅ Binary: UUID
  39. ✅ DATE + INTERVAL
  40. ✅ REAL * DOUBLE
  41. ✅ SMALLINT + BIGINT
  42. ✅ TEXT || VARCHAR

WireProtocolMetadata

  1. ✅ Extended query protocol works without parameters
  2. ✅ TEXT parameter has no size limit (as expected)
  3. ✅ Schema implies correct typmod
  4. ✅ All critical metadata fields present after DISCARD ALL
  5. ✅ All values readable as System.Object
  6. ✅ Value readable

Suite Summary

Test SuiteTotalPassedFailedDuckDB LimitationsPass Rate
ClientTypeParameter 8 8 0 0 100.0%
DemoTypeTests 26 26 0 0 100.0%
WireProtocolMetadata 6 6 0 0 100.0%
MetadataVerification 10 8 0 2 100.0%
PostgresTypeCoverage 62 40 1 21 97.6%
PreparedStatements 42 38 1 3 97.4%
ParameterTypeInference 44 21 1 22 95.5%
Filter by status:

Test Suite Details

#Test NameStatusErrorDetails
1 Binary format ✅ passed -
  • output:
    • ✅ Binary format - NUMERIC prepared: 999.99 + 0.01 = 1000.0000000000
    • ✅ Binary format - INTEGER prepared: 100 * 3 = 300
2 ClientType ✅ passed -
  • output:
    • ✅ ClientType - NUMERIC without cast: 123.4500000000
    • ✅ ClientType - Arithmetic NUMERIC * 2: 50.5 * 2 = 101.0000000000
3 Complex query ✅ passed -
  • output: ✅ Complex query - filtered aggregation with 3 params:
4 DATE comparison ✅ passed -
  • output: ✅ DATE comparison: Result - True
5 NULL parameters ✅ passed -
  • output: ✅ NULL parameters - NUMERIC with COALESCE
6 NUMERIC + BOOL ✅ passed -
  • output: ✅ NUMERIC + BOOL: Result - 110.0000000000
7 TEXT + INT ✅ passed -
  • output: ✅ TEXT + INT: Result - Test-42
8 Type inference ✅ passed -
  • output:
    • ✅ Type inference - explicit NUMERIC division: 456.78 / 2 = 228.39
    • ✅ Type inference - CASE with NUMERIC param: 75 -> MEDIUM

General

#Test NameStatusErrorDetails
1 bigint_samples ✅ passed -
  • output:
    • ✅ bigint_samples: 10 rows
    • ✅ bigint_samples: Schema + 3 rows read successfully
    • ✅ bigint_samples: Schema + 3 rows read successfully
2 blob_samples ✅ passed -
  • output:
    • ✅ blob_samples: 10 rows
    • ✅ blob_samples: Schema + 3 rows read successfully
3 bool_samples ✅ passed -
  • output:
    • ✅ bool_samples: 10 rows
    • ✅ bool_samples: Schema + 3 rows read successfully
4 date_samples ✅ passed -
  • output:
    • ✅ date_samples: 10 rows
    • ✅ date_samples: Schema + 3 rows read successfully
5 decimal_samples ✅ passed -
  • output:
    • ✅ decimal_samples: 10 rows
    • ✅ decimal_samples: Schema + 3 rows read successfully
6 double_samples ✅ passed -
  • output:
    • ✅ double_samples: 10 rows
    • ✅ double_samples: Schema + 3 rows read successfully
7 enum_samples ✅ passed -
  • output:
    • ✅ enum_samples: 10 rows
    • ✅ enum_samples: Schema + 3 rows read successfully
8 hugeint_samples ✅ passed -
  • output:
    • ✅ hugeint_samples: 10 rows
    • ✅ hugeint_samples: Schema + 3 rows (HUGEINT: .NET Decimal limitation noted)
9 int_samples ✅ passed -
  • output:
    • ✅ int_samples: 10 rows
    • ✅ int_samples: Schema + 3 rows read successfully
10 interval_samples ✅ passed -
  • output:
    • ✅ interval_samples: 10 rows
    • ✅ interval_samples: Schema + 3 rows read successfully
11 json_samples ✅ passed -
  • output:
    • ✅ json_samples: 10 rows
    • ✅ json_samples: Schema + 3 rows read successfully
12 list_int_samples ✅ passed -
  • output:
    • ✅ list_int_samples: 10 rows
    • ✅ list_int_samples: Schema + 3 rows read successfully
13 map_samples ✅ passed -
  • output:
    • ✅ map_samples: 10 rows
    • ✅ map_samples: Schema + 3 rows read successfully
14 real_samples ✅ passed -
  • output:
    • ✅ real_samples: 10 rows
    • ✅ real_samples: Schema + 3 rows read successfully
15 smallint_samples ✅ passed -
  • output:
    • ✅ smallint_samples: 10 rows
    • ✅ smallint_samples: Schema + 3 rows read successfully
16 struct_samples ✅ passed -
  • output:
    • ✅ struct_samples: 10 rows
    • ✅ struct_samples: Schema + 3 rows read successfully
17 time_samples ✅ passed -
  • output:
    • ✅ time_samples: 10 rows
    • ✅ time_samples: Schema + 3 rows read successfully
18 timestamp_samples ✅ passed -
  • output:
    • ✅ timestamp_samples: 10 rows
    • ✅ timestamp_samples: Schema + 3 rows read successfully
19 timestamptz_samples ✅ passed -
  • output:
    • ✅ timestamptz_samples: 10 rows
    • ✅ timestamptz_samples: Schema + 3 rows read successfully
20 tinyint_samples ✅ passed -
  • output:
    • ✅ tinyint_samples: 10 rows
    • ✅ tinyint_samples: Schema + 3 rows read successfully
21 ubigint_samples ✅ passed -
  • output:
    • ✅ ubigint_samples: 10 rows
    • ✅ ubigint_samples: Schema + 3 rows read successfully
    • ✅ ubigint_samples: Schema + 3 rows read successfully
22 uinteger_samples ✅ passed -
  • output:
    • ✅ uinteger_samples: 10 rows
    • ✅ uinteger_samples: Schema + 3 rows read successfully
23 usmallint_samples ✅ passed -
  • output:
    • ✅ usmallint_samples: 10 rows
    • ✅ usmallint_samples: Schema + 3 rows read successfully
24 utinyint_samples ✅ passed -
  • output:
    • ✅ utinyint_samples: 10 rows
    • ✅ utinyint_samples: Schema + 3 rows read successfully
25 uuid_samples ✅ passed -
  • output:
    • ✅ uuid_samples: 10 rows
    • ✅ uuid_samples: Schema + 3 rows read successfully
26 varchar_samples ✅ passed -
  • output:
    • ✅ varchar_samples: 10 rows
    • ✅ varchar_samples: Schema + 3 rows read successfully

RowDescription Metadata

#Test NameStatusErrorDetails
1 ARRAY types ✅ passed -
  • query: SELECT ARRAY[1,2,3]::INT[] as int_array
2 BIT ✅ passed -
  • query: SELECT '101'::BIT as bit_col
3 BLOB ✅ passed -
  • query: SELECT '\xDEADBEEF'::BLOB as blob_col
4 CHAR with length 🦆 DuckDB Limitation DuckDB limitation: ColumnSize not supported for CHAR with length
  • query: SELECT 'test'::CHAR(10) as char_col
  • columnSize: -1
  • isDuckDBLimitation: True
5 DECIMAL with precision ✅ passed -
  • query: SELECT 123.45::DECIMAL(15,4) as decimal_col
6 INTERVAL with precision ✅ passed -
  • query: SELECT INTERVAL '1 day 2:03:04' as interval_col
7 NUMERIC with precision ✅ passed -
  • query: SELECT 123.45::NUMERIC(10,2) as numeric_col
8 TIME ✅ passed -
  • query: SELECT CURRENT_TIME as time_col
9 TIMESTAMP ✅ passed -
  • query: SELECT CURRENT_TIMESTAMP as timestamp_col
10 VARCHAR with length 🦆 DuckDB Limitation DuckDB limitation: ColumnSize not supported for VARCHAR with length
  • query: SELECT 'test'::VARCHAR(255) as varchar_col
  • columnSize: -1
  • isDuckDBLimitation: True

#Test NameStatusErrorDetails
1 "char" 🦆 DuckDB Limitation 🦆 "char" - DuckDB limitation: The NpgsqlDbType 'Char' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 "char" - DuckDB limitation: The NpgsqlDbType 'Char' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
2 BIGINT ✅ passed -
  • output: ✅ BIGINT - Parameter accepted, type: bigint
3 BIT VARYING(10) 🦆 DuckDB Limitation 🦆 BIT VARYING(10) - DuckDB limitation: The NpgsqlDbType 'Varbit' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 BIT VARYING(10) - DuckDB limitation: The NpgsqlDbType 'Varbit' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
4 BIT(8) 🦆 DuckDB Limitation 🦆 BIT(8) - DuckDB limitation: XX000: Prepared query execution failed: Failed to prepare statement: Parser Error: Type BIT does not support any modifiers!
  • output: 🦆 BIT(8) - DuckDB limitation: XX000: Prepared query execution failed: Failed to prepare statement: Parser Error: Type BIT does not support any modifiers!
  • isDuckDBLimitation: True
5 BOOL ✅ passed -
  • output: ✅ BOOL - Parameter accepted, type: boolean
6 BOOLEAN ✅ passed -
  • output: ✅ BOOLEAN - Parameter accepted, type: boolean
7 BOOLEAN[] ✅ passed -
  • output: ✅ BOOLEAN[] - Parameter accepted, type: boolean[]
8 BOX 🦆 DuckDB Limitation 🦆 BOX - DuckDB limitation: The NpgsqlDbType 'Box' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 BOX - DuckDB limitation: The NpgsqlDbType 'Box' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
9 BYTEA ✅ passed -
  • output: ✅ BYTEA - Parameter accepted, type: bytea
10 CHAR(10) 🦆 DuckDB Limitation 🦆 CHAR(10) - DuckDB limitation: The NpgsqlDbType 'Char' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 CHAR(10) - DuckDB limitation: The NpgsqlDbType 'Char' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
11 CIDR 🦆 DuckDB Limitation 🦆 CIDR - DuckDB limitation: The NpgsqlDbType 'Cidr' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 CIDR - DuckDB limitation: The NpgsqlDbType 'Cidr' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
12 CIRCLE 🦆 DuckDB Limitation 🦆 CIRCLE - DuckDB limitation: The NpgsqlDbType 'Circle' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 CIRCLE - DuckDB limitation: The NpgsqlDbType 'Circle' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
13 DATE ✅ passed -
  • output: ✅ DATE - Parameter accepted, type: date
14 DATERANGE 🦆 DuckDB Limitation 🦆 DATERANGE - DuckDB limitation: The NpgsqlDbType 'DateRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 DATERANGE - DuckDB limitation: The NpgsqlDbType 'DateRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
15 DOUBLE PRECISION ✅ passed -
  • output: ✅ DOUBLE PRECISION - Parameter accepted, type: double precision
16 HUGEINT ✅ passed -
  • output: ✅ HUGEINT - Parameter accepted, type: numeric
17 INET 🦆 DuckDB Limitation 🦆 INET - DuckDB limitation: The NpgsqlDbType 'Inet' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 INET - DuckDB limitation: The NpgsqlDbType 'Inet' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
18 INT4RANGE 🦆 DuckDB Limitation 🦆 INT4RANGE - DuckDB limitation: The NpgsqlDbType 'IntegerRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 INT4RANGE - DuckDB limitation: The NpgsqlDbType 'IntegerRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
19 INTEGER ✅ passed -
  • output: ✅ INTEGER - Parameter accepted, type: integer
20 INTEGER[] ✅ passed -
  • output: ✅ INTEGER[] - Parameter accepted, type: integer[]
21 INTERVAL ✅ passed -
  • output: ✅ INTERVAL - Parameter accepted, type: interval
22 JSON ✅ passed -
  • output: ✅ JSON - Parameter accepted, type: json
23 JSONB ✅ passed -
  • output: ✅ JSONB - Parameter accepted, type: json
24 LINE 🦆 DuckDB Limitation 🦆 LINE - DuckDB limitation: The NpgsqlDbType 'Line' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 LINE - DuckDB limitation: The NpgsqlDbType 'Line' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
25 LSEG 🦆 DuckDB Limitation 🦆 LSEG - DuckDB limitation: The NpgsqlDbType 'LSeg' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 LSEG - DuckDB limitation: The NpgsqlDbType 'LSeg' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
26 MACADDR 🦆 DuckDB Limitation 🦆 MACADDR - DuckDB limitation: The NpgsqlDbType 'MacAddr' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 MACADDR - DuckDB limitation: The NpgsqlDbType 'MacAddr' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
27 MONEY 🦆 DuckDB Limitation 🦆 MONEY - DuckDB limitation: 42P01: Failed to prepare statement: Catalog Error: Type with name MONEY does not exist!
  • output: 🦆 MONEY - DuckDB limitation: 42P01: Failed to prepare statement: Catalog Error: Type with name MONEY does not exist!
  • isDuckDBLimitation: True
28 NUMERIC ✅ passed -
  • output: ✅ NUMERIC - Parameter accepted, type: numeric(18, 3)
29 NUMRANGE 🦆 DuckDB Limitation 🦆 NUMRANGE - DuckDB limitation: The NpgsqlDbType 'NumericRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 NUMRANGE - DuckDB limitation: The NpgsqlDbType 'NumericRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
30 PATH 🦆 DuckDB Limitation 🦆 PATH - DuckDB limitation: The NpgsqlDbType 'Path' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 PATH - DuckDB limitation: The NpgsqlDbType 'Path' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
31 POINT 🦆 DuckDB Limitation 🦆 POINT - DuckDB limitation: The NpgsqlDbType 'Point' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 POINT - DuckDB limitation: The NpgsqlDbType 'Point' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
32 POLYGON 🦆 DuckDB Limitation 🦆 POLYGON - DuckDB limitation: The NpgsqlDbType 'Polygon' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 POLYGON - DuckDB limitation: The NpgsqlDbType 'Polygon' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
33 REAL ✅ passed -
  • output: ✅ REAL - Parameter accepted, type: real
34 REGCLASS ❌ failed XX000: Prepared query execution failed: {"exception_type":"Invalid Input","exception_message":"Invalid unicode (byte sequence mismatch) detected in value construction"}
  • output: ❌ REGCLASS - Error: XX000: Prepared query execution failed: {"exception_type":"Invalid Input","exception_message":"Invalid unicode (byte sequence mismatch) detected in value construction"}
35 REGTYPE 🦆 DuckDB Limitation 🦆 REGTYPE - DuckDB limitation: The NpgsqlDbType 'Regtype' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 REGTYPE - DuckDB limitation: The NpgsqlDbType 'Regtype' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
36 SMALLINT ✅ passed -
  • output: ✅ SMALLINT - Parameter accepted, type: smallint
37 TIME ✅ passed -
  • output: ✅ TIME - Parameter accepted, type: time without time zone
38 TIME WITH TIME ZONE ✅ passed -
  • output: ✅ TIME WITH TIME ZONE - Parameter accepted, type: time with time zone
39 TIMESTAMP ✅ passed -
  • output: ✅ TIMESTAMP - Parameter accepted, type: timestamp without time zone
40 TIMESTAMP WITH TIME ZONE ✅ passed -
  • output: ✅ TIMESTAMP WITH TIME ZONE - Parameter accepted, type: timestamp with time zone
41 TSRANGE 🦆 DuckDB Limitation 🦆 TSRANGE - DuckDB limitation: The NpgsqlDbType 'TimestampRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 TSRANGE - DuckDB limitation: The NpgsqlDbType 'TimestampRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
42 TSTZRANGE 🦆 DuckDB Limitation 🦆 TSTZRANGE - DuckDB limitation: The NpgsqlDbType 'TimestampTzRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • output: 🦆 TSTZRANGE - DuckDB limitation: The NpgsqlDbType 'TimestampTzRange' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • isDuckDBLimitation: True
43 UUID ✅ passed -
  • output: ✅ UUID - Parameter accepted, type: uuid
44 XML 🦆 DuckDB Limitation 🦆 XML - DuckDB limitation: 42P01: Failed to prepare statement: Catalog Error: Type with name XML does not exist!
  • output: 🦆 XML - DuckDB limitation: 42P01: Failed to prepare statement: Catalog Error: Type with name XML does not exist!
  • isDuckDBLimitation: True

Array

#Test NameStatusErrorDetails
1 BOOLEAN[] ✅ passed -
  • query: SELECT ARRAY[true,false]::BOOLEAN[] as test_col
  • dataTypeName: boolean[]
  • npgsqlType: System.Array
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
2 INTEGER[] ✅ passed -
  • query: SELECT ARRAY[1,2,3]::INTEGER[] as test_col
  • dataTypeName: integer[]
  • npgsqlType: System.Array
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
3 NUMERIC[] ✅ passed -
  • query: SELECT ARRAY[1.1,2.2,3.3]::NUMERIC[] as test_col
  • dataTypeName: numeric
  • npgsqlType: System.Decimal
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
4 TEXT[] ✅ passed -
  • query: SELECT ARRAY['a','b','c']::TEXT[] as test_col
  • dataTypeName: character varying[]
  • npgsqlType: System.Array
  • readable: True
  • supported: True
  • isDuckDBLimitation: False

Binary

#Test NameStatusErrorDetails
5 BIT ✅ passed -
  • query: SELECT '101'::BIT as test_col
  • dataTypeName: bit
  • npgsqlType: System.Collections.BitArray
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
6 BIT(8) 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Parser Error: Type BIT does not support any modifiers!
  • query: SELECT '10101010'::BIT(8) as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
7 BITSTRING ✅ passed -
  • query: SELECT '10101010'::BITSTRING as test_col
  • dataTypeName: bit
  • npgsqlType: System.Collections.BitArray
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
8 BYTEA ✅ passed -
  • query: SELECT '\x0123456789ABCDEF'::BYTEA as test_col
  • dataTypeName: bytea
  • npgsqlType: System.Byte[]
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
9 VARBIT 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name VARBIT does not exist!
  • query: SELECT '1010'::VARBIT as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
10 VARBIT(16) 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name VARBIT does not exist!
  • query: SELECT '1010101010101010'::VARBIT(16) as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True

Boolean

#Test NameStatusErrorDetails
11 BOOL ✅ passed -
  • query: SELECT 'false'::BOOL as test_col
  • dataTypeName: boolean
  • npgsqlType: System.Boolean
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
12 BOOLEAN ✅ passed -
  • query: SELECT 'true'::BOOLEAN as test_col
  • dataTypeName: boolean
  • npgsqlType: System.Boolean
  • readable: True
  • supported: True
  • isDuckDBLimitation: False

Core

#Test NameStatusErrorDetails
13 BIGINT ✅ passed -
  • query: SELECT '123456789'::BIGINT as test_col
  • dataTypeName: bigint
  • npgsqlType: System.Int64
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
14 BIGSERIAL ✅ passed -
  • query: SELECT 123::BIGINT as test_col
  • dataTypeName: bigint
  • npgsqlType: System.Int64
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
15 DECIMAL ✅ passed -
  • query: SELECT '123.45'::DECIMAL as test_col
  • dataTypeName: numeric(18, 3)
  • npgsqlType: System.Decimal
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
16 DOUBLE PRECISION ✅ passed -
  • query: SELECT '123.456789'::DOUBLE PRECISION as test_col
  • dataTypeName: double precision
  • npgsqlType: System.Double
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
17 INTEGER ✅ passed -
  • query: SELECT '12345'::INTEGER as test_col
  • dataTypeName: integer
  • npgsqlType: System.Int32
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
18 NUMERIC ✅ passed -
  • query: SELECT '123.45'::NUMERIC as test_col
  • dataTypeName: numeric(18, 3)
  • npgsqlType: System.Decimal
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
19 NUMERIC(10,2) ✅ passed -
  • query: SELECT '123.45'::NUMERIC(10,2) as test_col
  • dataTypeName: numeric(10, 2)
  • npgsqlType: System.Decimal
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
20 REAL ✅ passed -
  • query: SELECT '123.45'::REAL as test_col
  • dataTypeName: real
  • npgsqlType: System.Single
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
21 SERIAL ✅ passed -
  • query: SELECT 123::INTEGER as test_col
  • dataTypeName: integer
  • npgsqlType: System.Int32
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
22 SMALLINT ✅ passed -
  • query: SELECT '123'::SMALLINT as test_col
  • dataTypeName: smallint
  • npgsqlType: System.Int16
  • readable: True
  • supported: True
  • isDuckDBLimitation: False

DateTime

#Test NameStatusErrorDetails
23 DATE ✅ passed -
  • query: SELECT '2024-01-15'::DATE as test_col
  • dataTypeName: date
  • npgsqlType: System.DateOnly
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
24 INTERVAL ✅ passed -
  • query: SELECT '1 day'::INTERVAL as test_col
  • dataTypeName: interval
  • npgsqlType: System.TimeSpan
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
25 TIME ✅ passed -
  • query: SELECT '14:30:00'::TIME as test_col
  • dataTypeName: time without time zone
  • npgsqlType: System.TimeOnly
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
26 TIME WITH TIME ZONE ✅ passed -
  • query: SELECT '14:30:00+00'::TIME WITH TIME ZONE as test_col
  • dataTypeName: time with time zone
  • npgsqlType: System.DateTimeOffset
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
27 TIMESTAMP ✅ passed -
  • query: SELECT '2024-01-15 14:30:00'::TIMESTAMP as test_col
  • dataTypeName: timestamp without time zone
  • npgsqlType: System.DateTime
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
28 TIMESTAMP WITH TIME ZONE ✅ passed -
  • query: SELECT '2024-01-15 14:30:00+00'::TIMESTAMP WITH TIME ZONE as test_col
  • dataTypeName: timestamp with time zone
  • npgsqlType: System.DateTime
  • readable: True
  • supported: True
  • isDuckDBLimitation: False

Geometric

#Test NameStatusErrorDetails
29 BOX 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name BOX does not exist!
  • query: SELECT '((0,0),(1,1))'::BOX as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
30 CIRCLE 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name CIRCLE does not exist!
  • query: SELECT '<(0,0),1>'::CIRCLE as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
31 LINE 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name LINE does not exist!
  • query: SELECT '{1,2,3}'::LINE as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
32 LSEG 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name LSEG does not exist!
  • query: SELECT '[(0,0),(1,1)]'::LSEG as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
33 PATH 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name PATH does not exist!
  • query: SELECT '[(0,0),(1,1),(2,0)]'::PATH as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
34 POINT 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name POINT does not exist!
  • query: SELECT '(1,2)'::POINT as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
35 POLYGON 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name POLYGON does not exist!
  • query: SELECT '((0,0),(1,1),(2,0))'::POLYGON as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True

JSON

#Test NameStatusErrorDetails
36 JSON ✅ passed -
  • query: SELECT '{"key": "value"}'::JSON as test_col
  • dataTypeName: json
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
37 JSONB 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name JSONB does not exist!
  • query: SELECT '{"key": "value"}'::JSONB as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True

Network

#Test NameStatusErrorDetails
38 CIDR 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name CIDR does not exist!
  • query: SELECT '192.168.1.0/24'::CIDR as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
39 INET ❌ failed XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name "INET" is not in the catalog, but it exists in the inet extension.
  • query: SELECT '192.168.1.1'::INET as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: False
40 MACADDR 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name MACADDR does not exist!
  • query: SELECT '08:00:2b:01:02:03'::MACADDR as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
41 MACADDR8 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name MACADDR8 does not exist!
  • query: SELECT '08:00:2b:01:02:03:04:05'::MACADDR8 as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True

Numeric

#Test NameStatusErrorDetails
42 FLOAT ✅ passed -
  • query: SELECT '123.45'::FLOAT as test_col
  • dataTypeName: real
  • npgsqlType: System.Single
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
43 FLOAT4 ✅ passed -
  • query: SELECT '123.45'::FLOAT4 as test_col
  • dataTypeName: real
  • npgsqlType: System.Single
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
44 FLOAT8 ✅ passed -
  • query: SELECT '123.45'::FLOAT8 as test_col
  • dataTypeName: double precision
  • npgsqlType: System.Double
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
45 MONEY 🦆 DuckDB Limitation XX000: Failed to prepare statement: Failed to prepare statement: Catalog Error: Type with name MONEY does not exist!
  • query: SELECT '$100.50'::MONEY as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True

Special

#Test NameStatusErrorDetails
46 OID ✅ passed -
  • query: SELECT '12345'::OID as test_col
  • dataTypeName: bigint
  • npgsqlType: System.Int64
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
47 PG_LSN 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name PG_LSN does not exist!
  • query: SELECT '0/12345678'::PG_LSN as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
48 REGCLASS ✅ passed -
  • query: SELECT 'pg_class'::REGCLASS as test_col
  • dataTypeName: bigint
  • npgsqlType: System.Int64
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
49 REGPROC ✅ passed -
  • query: SELECT 'now'::REGPROC as test_col
  • dataTypeName: bigint
  • npgsqlType: System.Int64
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
50 REGTYPE 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name REGTYPE does not exist!
  • query: SELECT 'integer'::REGTYPE as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
51 TSQUERY 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name TSQUERY does not exist!
  • query: SELECT 'fat & cat'::TSQUERY as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
52 TSVECTOR 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name TSVECTOR does not exist!
  • query: SELECT 'a fat cat'::TSVECTOR as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
53 TXID_SNAPSHOT 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name TXID_SNAPSHOT does not exist!
  • query: SELECT '10:20:10,14,15'::TXID_SNAPSHOT as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True
54 XML 🦆 DuckDB Limitation XX000: Schema query failed: C++ API Arrow query failed: Catalog Error: Type with name XML does not exist!
  • query: SELECT '<root>test</root>'::XML as test_col
  • dataTypeName: N/A
  • npgsqlType: N/A
  • readable: False
  • supported: False
  • isDuckDBLimitation: True

String

#Test NameStatusErrorDetails
55 BPCHAR ✅ passed -
  • query: SELECT 'test'::BPCHAR as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
56 CHAR ✅ passed -
  • query: SELECT 'a'::CHAR as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
57 CHAR(10) ✅ passed -
  • query: SELECT 'test'::CHAR(10) as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
58 NAME ✅ passed -
  • query: SELECT 'test_name'::NAME as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
59 TEXT ✅ passed -
  • query: SELECT 'test text'::TEXT as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
60 VARCHAR ✅ passed -
  • query: SELECT 'test'::VARCHAR as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False
61 VARCHAR(50) ✅ passed -
  • query: SELECT 'test'::VARCHAR(50) as test_col
  • dataTypeName: text
  • npgsqlType: System.String
  • readable: True
  • supported: True
  • isDuckDBLimitation: False

UUID

#Test NameStatusErrorDetails
62 UUID ✅ passed -
  • query: SELECT 'a0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11'::UUID as test_col
  • dataTypeName: uuid
  • npgsqlType: System.Guid
  • readable: True
  • supported: True
  • isDuckDBLimitation: False

Basic Prepared Statements

#Test NameStatusErrorDetails
1 Simple arithmetic with INTEGER parameters ✅ passed -
  • query: SELECT $1::INTEGER + $2::INTEGER
  • parameters: [ 5, 3 ]
  • expected: 8
  • actual: 8

Binary Array Types

#Test NameStatusErrorDetails
2 Binary: BOOLEAN[] ✅ passed -
  • query: SELECT $1::BOOLEAN[]
  • dbType: -2147483646
  • valueType: Boolean[]
  • resultType: Array
  • dataTypeName: boolean[]
  • resultValue: System.Boolean[]
3 Binary: DATE[] ✅ passed -
  • query: SELECT $1::DATE[]
  • dbType: -2147483641
  • valueType: DateOnly[]
  • resultType: Array
  • dataTypeName: date[]
  • resultValue: System.DateOnly[]
4 Binary: DOUBLE PRECISION[] ✅ passed -
  • query: SELECT $1::DOUBLE PRECISION[]
  • dbType: -2147483640
  • valueType: Double[]
  • resultType: Array
  • dataTypeName: double precision[]
  • resultValue: System.Double[]
5 Binary: INTEGER[] ✅ passed -
  • query: SELECT $1::INTEGER[]
  • dbType: -2147483639
  • valueType: Int32[]
  • resultType: Array
  • dataTypeName: integer[]
  • resultValue: System.Int32[]
6 Binary: INTEGER[][] (2D) ❌ failed XX000: Unsupported List Datatype List(Field { name: "l", data_type: Int32, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} })
  • query: SELECT $1::INTEGER[][]
  • dbType: -2147483639
  • valueType: Int32[,]
  • exception: PostgresException
  • isPgwireLimitation: True
7 Binary: NUMERIC[] ✅ passed -
  • query: SELECT $1::NUMERIC[]
  • dbType: -2147483635
  • valueType: Decimal[]
  • resultType: Array
  • dataTypeName: numeric[]
  • resultValue: System.Decimal[]
8 Binary: REAL[] ✅ passed -
  • query: SELECT $1::REAL[]
  • dbType: -2147483631
  • valueType: Single[]
  • resultType: Array
  • dataTypeName: real[]
  • resultValue: System.Single[]
9 Binary: TEXT[] ✅ passed -
  • query: SELECT $1::TEXT[]
  • dbType: -2147483629
  • valueType: String[]
  • resultType: Array
  • dataTypeName: character varying[]
  • resultValue: System.String[]
10 Binary: TIMESTAMP[] ✅ passed -
  • query: SELECT $1::TIMESTAMP[]
  • dbType: -2147483627
  • valueType: DateTime[]
  • resultType: Array
  • dataTypeName: timestamp without time zone[]
  • resultValue: System.DateTime[]
11 Binary: UUID[] ✅ passed -
  • query: SELECT $1::UUID[]
  • dbType: -2147483621
  • valueType: Guid[]
  • resultType: Array
  • dataTypeName: uuid[]
  • resultValue: System.Guid[]

Binary Boolean Types

#Test NameStatusErrorDetails
12 Binary: BOOLEAN (false) ✅ passed -
  • query: SELECT $1::BOOLEAN
  • dbType: Boolean
  • valueType: Boolean
  • resultType: Boolean
  • dataTypeName: boolean
  • resultValue: False
13 Binary: BOOLEAN (true) ✅ passed -
  • query: SELECT $1::BOOLEAN
  • dbType: Boolean
  • valueType: Boolean
  • resultType: Boolean
  • dataTypeName: boolean
  • resultValue: True

Binary Data Types

#Test NameStatusErrorDetails
14 Binary: BIT 🦆 DuckDB Limitation XX000: Prepared query execution failed: {"exception_type":"Invalid Input","exception_message":"Invalid unicode (byte sequence mismatch) detected in value construction"}
  • query: SELECT $1::BIT
  • dbType: Bit
  • valueType: BitArray
  • exception: PostgresException
  • isDuckDBLimitation: True
15 Binary: BYTEA ✅ passed -
  • query: SELECT $1::BYTEA
  • dbType: Bytea
  • valueType: Byte[]
  • resultType: Byte[]
  • dataTypeName: bytea
  • resultValue: System.Byte[]

Binary DateTime Types

#Test NameStatusErrorDetails
16 Binary: DATE ✅ passed -
  • query: SELECT $1::DATE
  • dbType: Date
  • valueType: DateTime
  • resultType: DateOnly
  • dataTypeName: date
  • resultValue: 1/15/2024
17 Binary: INTERVAL ✅ passed -
  • query: SELECT $1::INTERVAL
  • dbType: Interval
  • valueType: TimeSpan
  • resultType: TimeSpan
  • dataTypeName: interval
  • resultValue: 1.01:30:00
18 Binary: TIME ✅ passed -
  • query: SELECT $1::TIME
  • dbType: Time
  • valueType: TimeSpan
  • resultType: TimeOnly
  • dataTypeName: time without time zone
  • resultValue: 2:30 PM
19 Binary: TIMESTAMP ✅ passed -
  • query: SELECT $1::TIMESTAMP
  • dbType: Timestamp
  • valueType: DateTime
  • resultType: DateTime
  • dataTypeName: timestamp without time zone
  • resultValue: 1/15/2024 2:30:00 PM
20 Binary: TIMESTAMPTZ ✅ passed -
  • query: SELECT $1::TIMESTAMPTZ
  • dbType: TimestampTz
  • valueType: DateTime
  • resultType: DateTime
  • dataTypeName: timestamp with time zone
  • resultValue: 1/15/2024 2:30:00 PM

Binary JSON Types

#Test NameStatusErrorDetails
21 Binary: JSON ✅ passed -
  • query: SELECT $1::JSON
  • dbType: Json
  • valueType: String
  • resultType: String
  • dataTypeName: json
  • resultValue: {"key": "value", "number": 42}
22 Binary: JSONB ✅ passed -
  • query: SELECT $1::JSONB
  • dbType: Jsonb
  • valueType: String
  • resultType: String
  • dataTypeName: json
  • resultValue: {"key": "value", "number": 42}

Binary Network Types

#Test NameStatusErrorDetails
23 Binary: INET 🦆 DuckDB Limitation The NpgsqlDbType 'Inet' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • query: SELECT $1::INET
  • dbType: Inet
  • valueType: IPAddress
  • exception: NotSupportedException
  • isDuckDBLimitation: True

Binary NULL Types

#Test NameStatusErrorDetails
24 Binary: NULL INTEGER ✅ passed -
  • query: SELECT $1::INTEGER
  • dbType: Integer
  • valueType: DBNull
  • resultType: Int32
  • dataTypeName: integer
  • resultValue:
25 Binary: NULL TEXT ✅ passed -
  • query: SELECT $1::TEXT
  • dbType: Text
  • valueType: DBNull
  • resultType: String
  • dataTypeName: character varying
  • resultValue:
26 Binary: NULL TIMESTAMP ✅ passed -
  • query: SELECT $1::TIMESTAMP
  • dbType: Timestamp
  • valueType: DBNull
  • resultType: DateTime
  • dataTypeName: timestamp without time zone
  • resultValue:

Binary Numeric Types

#Test NameStatusErrorDetails
27 Binary: BIGINT ✅ passed -
  • query: SELECT $1::BIGINT
  • dbType: Bigint
  • valueType: Int64
  • resultType: Int64
  • dataTypeName: bigint
  • resultValue: 123456789
28 Binary: DOUBLE PRECISION ✅ passed -
  • query: SELECT $1::DOUBLE PRECISION
  • dbType: Double
  • valueType: Double
  • resultType: Double
  • dataTypeName: double precision
  • resultValue: 123.456789
29 Binary: INTEGER ✅ passed -
  • query: SELECT $1::INTEGER
  • dbType: Integer
  • valueType: Int32
  • resultType: Int32
  • dataTypeName: integer
  • resultValue: 12345
30 Binary: NUMERIC ✅ passed -
  • query: SELECT $1::NUMERIC
  • dbType: Numeric
  • valueType: Decimal
  • resultType: Decimal
  • dataTypeName: numeric(18, 3)
  • resultValue: 123.450
31 Binary: NUMERIC(10,2) ✅ passed -
  • query: SELECT $1::NUMERIC(10,2)
  • dbType: Numeric
  • valueType: Decimal
  • resultType: Decimal
  • dataTypeName: numeric(10, 2)
  • resultValue: 123.45
32 Binary: REAL ✅ passed -
  • query: SELECT $1::REAL
  • dbType: Real
  • valueType: Single
  • resultType: Single
  • dataTypeName: real
  • resultValue: 123.45
33 Binary: SMALLINT ✅ passed -
  • query: SELECT $1::SMALLINT
  • dbType: Smallint
  • valueType: Int16
  • resultType: Int16
  • dataTypeName: smallint
  • resultValue: 123

Binary String Types

#Test NameStatusErrorDetails
34 Binary: CHAR(10) 🦆 DuckDB Limitation The NpgsqlDbType 'Char' isn't present in your database. You may need to install an extension or upgrade to a newer version.
  • query: SELECT $1::CHAR(10)
  • dbType: Char
  • valueType: String
  • exception: NotSupportedException
  • isDuckDBLimitation: True
35 Binary: NAME ✅ passed -
  • query: SELECT $1::NAME
  • dbType: Name
  • valueType: String
  • resultType: String
  • dataTypeName: character varying
  • resultValue: test_name
36 Binary: TEXT ✅ passed -
  • query: SELECT $1::TEXT
  • dbType: Text
  • valueType: String
  • resultType: String
  • dataTypeName: character varying
  • resultValue: Hello, World!
37 Binary: VARCHAR ✅ passed -
  • query: SELECT $1::VARCHAR
  • dbType: Varchar
  • valueType: String
  • resultType: String
  • dataTypeName: character varying
  • resultValue: Test string

Binary UUID Types

#Test NameStatusErrorDetails
38 Binary: UUID ✅ passed -
  • query: SELECT $1::UUID
  • dbType: Uuid
  • valueType: Guid
  • resultType: Guid
  • dataTypeName: uuid
  • resultValue: 550e8400-e29b-41d4-a716-446655440000

Mixed Type Parameters

#Test NameStatusErrorDetails
39 DATE + INTERVAL ✅ passed -
  • query: SELECT $1::DATE + $2::INTERVAL
  • parameters: [ "2025-09-16T00:00:00+03:00", "1.00:00:00" ]
  • parameterTypes: [ "Date", "Interval" ]
  • result: 9/17/2025 12:00:00 AM
40 REAL * DOUBLE ✅ passed -
  • query: SELECT $1::REAL * $2::DOUBLE PRECISION
  • parameters: [ 2.5, 3 ]
  • parameterTypes: [ "Real", "Double" ]
  • result: 7.5
41 SMALLINT + BIGINT ✅ passed -
  • query: SELECT $1::SMALLINT + $2::BIGINT
  • parameters: [ 10, 1000000 ]
  • parameterTypes: [ "Smallint", "Bigint" ]
  • result: 1000010
42 TEXT || VARCHAR ✅ passed -
  • query: SELECT $1::TEXT || $2::VARCHAR
  • parameters: [ "Hello ", "World" ]
  • parameterTypes: [ "Text", "Varchar" ]
  • result: Hello World

Testing Extended Query Protocol Metadata

#Test NameStatusErrorDetails
1 Extended query protocol works without parameters ✅ passed -
  • output: ✅ Extended query protocol works without parameters
2 TEXT parameter has no size limit (as expected) ✅ passed -
  • output: ✅ TEXT parameter has no size limit (as expected)

Testing Typmod Values in RowDescription Messages

#Test NameStatusErrorDetails
3 Schema implies correct typmod ✅ passed -
  • output:
    • ✅ Schema implies correct typmod: ((10 << 16) | 2) + 4 = 655366
    • ✅ Schema implies correct typmod: ((18 << 16) | 4) + 4 = 1179656

Validating Power BI Critical Scenarios

#Test NameStatusErrorDetails
4 All critical metadata fields present after DISCARD ALL ✅ passed -
  • output: ✅ All critical metadata fields present after DISCARD ALL
5 All values readable as System.Object ✅ passed -
  • output: ✅ All values readable as System.Object
6 Value readable ✅ passed -
  • output:
    • ✅ Value readable: (String)
    • ✅ Value readable: 123.45 (Decimal)
    • ✅ Value readable: 9/16/2025 7:26:32 AM (DateTime)
    • ✅ Value readable: System.Int32[] (Int32[])