42028758342

Committed 05 Nov 2026 11:59AM UTC coverage: 93.133% (+0.4%) from 92.771%

Build # 42028758342

Build Type

push

github

Committed by

Giorgi

Commit Message

Load Int128 and UInt128 from a HUGEINT and UHUGEINT vector without a conversion

StorageType of the two columns is Int128 and UInt128, their default types,
where it was the DuckDB structs: the vector holds the 16 bytes of an Int128 on a
little-endian machine. ReadValidValue<Int128> then compares the type and loads
the value (vmovups, unaligned), for GetFieldValue, nullable reads, list items,
map keys and values, struct fields and function inputs. A read of the DuckDB
structs, which lose the fast path, is taken from the vector in GetValidValue, so
it is not boxed through the base class.

Read in the Tier 1 listing of .NET 10.0.14: ReadValidValue<Int128> is inlined
into GetFieldValue<Int128>; on .NET 8 it stays a call. Not measured.

2.0 item 9 (#370).

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01LUiK1oVhhDRogChf6UQbvo

Coverage Stats

2740 of 2995 branches covered (91.49%)

Branch coverage included in aggregate %.

6 of 6 new or added lines in 1 file covered. (100.0%)

55 existing lines in 14 files now uncovered.

4299 of 4563 relevant lines covered (94.21%)

1062879.99 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

98.1

/DuckDB.NET.Data/Extensions/TypeExtensions.cs

using System.Diagnostics.CodeAnalysis;
using System.Runtime.CompilerServices;

namespace DuckDB.NET.Data.Extensions;

internal static class TypeExtensions
{
    private static readonly Dictionary<Type, DuckDBType> ClrToDuckDBTypeMap = new()
    {
        { typeof(bool), DuckDBType.Boolean },
        { typeof(sbyte), DuckDBType.TinyInt },
        { typeof(short), DuckDBType.SmallInt },
        { typeof(int), DuckDBType.Integer },
        { typeof(long), DuckDBType.BigInt },
        { typeof(byte), DuckDBType.UnsignedTinyInt },
        { typeof(ushort), DuckDBType.UnsignedSmallInt },
        { typeof(uint), DuckDBType.UnsignedInteger },
        { typeof(ulong), DuckDBType.UnsignedBigInt },
        { typeof(float), DuckDBType.Float },
        { typeof(double), DuckDBType.Double},
        { typeof(Guid), DuckDBType.Uuid},
        { typeof(DateTime), DuckDBType.Timestamp},
        { typeof(TimeSpan), DuckDBType.Interval},
        { typeof(DateOnly), DuckDBType.Date},
        { typeof(TimeOnly), DuckDBType.Time},
        { typeof(DuckDBDateOnly), DuckDBType.Date},
        { typeof(DuckDBTimeOnly), DuckDBType.Time},
        { typeof(DateTimeOffset), DuckDBType.TimestampTz},
        { typeof(BigInteger), DuckDBType.HugeInt},
        { typeof(Int128), DuckDBType.HugeInt},
        { typeof(UInt128), DuckDBType.UnsignedHugeInt},
        { typeof(string), DuckDBType.Varchar},
        { typeof(byte[]), DuckDBType.Blob},
        { typeof(decimal), DuckDBType.Decimal},
        { typeof(object), DuckDBType.Any},
    };

    [MethodImpl(MethodImplOptions.AggressiveInlining)]
    public static bool IsNull([NotNullWhen(false)] this object? value) => value is null or DBNull;

    [MethodImpl(MethodImplOptions.AggressiveInlining)]
    public static Type UnderlyingTypeOrSelf(this Type type) => Nullable.GetUnderlyingType(type) ?? type;

    [MethodImpl(MethodImplOptions.AggressiveInlining)]
    public static bool IsFloatingNumericType<T>()
    {
        return typeof(T) == typeof(decimal) || typeof(T) == typeof(float) || typeof(T) == typeof(double);
    }

    [MethodImpl(MethodImplOptions.AggressiveInlining)]
    public static bool IsIntegralNumericType<T>()
    {
        return typeof(T) == typeof(byte) || typeof(T) == typeof(sbyte) ||
               typeof(T) == typeof(short) || typeof(T) == typeof(ushort) ||
               typeof(T) == typeof(int) || typeof(T) == typeof(uint) ||
               typeof(T) == typeof(long) || typeof(T) == typeof(ulong) ||
               typeof(T) == typeof(Int128) || typeof(T) == typeof(UInt128) ||
               typeof(T) == typeof(BigInteger);
    }

    public static bool AllowsNullValue(this Type type, out bool isNullableValueType, out Type? underlyingType)
    {
        underlyingType = Nullable.GetUnderlyingType(type);
        isNullableValueType = underlyingType != null;

        var isNullable = isNullableValueType || !type.IsValueType;

        return isNullable;
    }

    // The constructed type of genericDefinition (List<>, Dictionary<,>) that the type is or derives from, or null.
    public static Type? FindGenericBase(this Type type, Type genericDefinition)
    {
        for (var current = type; current != null; current = current.BaseType)
        {
            if (current.IsGenericType && current.GetGenericTypeDefinition() == genericDefinition)
            {
                return current;
            }
        }

        return null;
    }

    public static DuckDBLogicalType GetLogicalType<T>() => typeof(T).GetLogicalType();

    public static DuckDBLogicalType GetLogicalType(this Type type)
    {
        type = type.UnderlyingTypeOrSelf();

        if (type == typeof(decimal))
        {
            return NativeMethods.LogicalType.DuckDBCreateDecimalType(38, 18);
        }

        if (type.IsAssignableTo(typeof(IList)) && type.IsGenericType)
        {
            var genericTypeParameter = type.GetGenericArguments()[0];
            using var nestedType = genericTypeParameter.GetLogicalType();
            return NativeMethods.LogicalType.DuckDBCreateListType(nestedType);
        }

        if (ClrToDuckDBTypeMap.TryGetValue(type, out var duckDBType))
        {
            return NativeMethods.LogicalType.DuckDBCreateLogicalType(duckDBType);
        }

        throw new InvalidOperationException($"Cannot map type {type.FullName} to DuckDBType.");
    }

    public static DuckDBType GetDuckDBType(this Type type) => ClrToDuckDBTypeMap.GetValueOrDefault(type, DuckDBType.Invalid);
}

1	using System.Diagnostics.CodeAnalysis;
2	using System.Runtime.CompilerServices;
3
4	namespace DuckDB.NET.Data.Extensions;
5
6	internal static class TypeExtensions
7	{
8	private static readonly Dictionary<Type, DuckDBType> ClrToDuckDBTypeMap = new()	3 ✔
9	{	3 ✔
10	{ typeof(bool), DuckDBType.Boolean },	3 ✔
11	{ typeof(sbyte), DuckDBType.TinyInt },	3 ✔
12	{ typeof(short), DuckDBType.SmallInt },	3 ✔
13	{ typeof(int), DuckDBType.Integer },	3 ✔
14	{ typeof(long), DuckDBType.BigInt },	3 ✔
15	{ typeof(byte), DuckDBType.UnsignedTinyInt },	3 ✔
16	{ typeof(ushort), DuckDBType.UnsignedSmallInt },	3 ✔
17	{ typeof(uint), DuckDBType.UnsignedInteger },	3 ✔
18	{ typeof(ulong), DuckDBType.UnsignedBigInt },	3 ✔
19	{ typeof(float), DuckDBType.Float },	3 ✔
20	{ typeof(double), DuckDBType.Double},	3 ✔
21	{ typeof(Guid), DuckDBType.Uuid},	3 ✔
22	{ typeof(DateTime), DuckDBType.Timestamp},	3 ✔
23	{ typeof(TimeSpan), DuckDBType.Interval},	3 ✔
24	{ typeof(DateOnly), DuckDBType.Date},	3 ✔
25	{ typeof(TimeOnly), DuckDBType.Time},	3 ✔
26	{ typeof(DuckDBDateOnly), DuckDBType.Date},	3 ✔
27	{ typeof(DuckDBTimeOnly), DuckDBType.Time},	3 ✔
28	{ typeof(DateTimeOffset), DuckDBType.TimestampTz},	3 ✔
29	{ typeof(BigInteger), DuckDBType.HugeInt},	3 ✔
30	{ typeof(Int128), DuckDBType.HugeInt},	3 ✔
31	{ typeof(UInt128), DuckDBType.UnsignedHugeInt},	3 ✔
32	{ typeof(string), DuckDBType.Varchar},	3 ✔
33	{ typeof(byte[]), DuckDBType.Blob},	3 ✔
34	{ typeof(decimal), DuckDBType.Decimal},	3 ✔
35	{ typeof(object), DuckDBType.Any},	3 ✔
36	};	3 ✔
37
38	[MethodImpl(MethodImplOptions.AggressiveInlining)]
39	public static bool IsNull([NotNullWhen(false)] this object? value) => value is null or DBNull;	80,130 ✔
40
41	[MethodImpl(MethodImplOptions.AggressiveInlining)]
42	public static Type UnderlyingTypeOrSelf(this Type type) => Nullable.GetUnderlyingType(type) ?? type;	3,366 ✔
43
44	[MethodImpl(MethodImplOptions.AggressiveInlining)]
45	public static bool IsFloatingNumericType<T>()
46	{
47	return typeof(T) == typeof(decimal) \|\| typeof(T) == typeof(float) \|\| typeof(T) == typeof(double);	517,749 ✔
48	}
49
50	[MethodImpl(MethodImplOptions.AggressiveInlining)]
51	public static bool IsIntegralNumericType<T>()
52	{
53	return typeof(T) == typeof(byte) \|\| typeof(T) == typeof(sbyte) \|\|	4,267,559 ✔
54	typeof(T) == typeof(short) \|\| typeof(T) == typeof(ushort) \|\|	4,267,559 ✔
55	typeof(T) == typeof(int) \|\| typeof(T) == typeof(uint) \|\|	4,267,559 ✔
56	typeof(T) == typeof(long) \|\| typeof(T) == typeof(ulong) \|\|	4,267,559 ✔
57	typeof(T) == typeof(Int128) \|\| typeof(T) == typeof(UInt128) \|\|	4,267,559 ✔
58	typeof(T) == typeof(BigInteger);	4,267,559 ✔
59	}
60
61	public static bool AllowsNullValue(this Type type, out bool isNullableValueType, out Type? underlyingType)
62	{
63	underlyingType = Nullable.GetUnderlyingType(type);	3,124,068 ✔
64	isNullableValueType = underlyingType != null;	3,124,068 ✔
65
66	var isNullable = isNullableValueType \|\| !type.IsValueType;	3,124,068 ✔
67
68	return isNullable;	849,810 ✔
69	}
70
71	// The constructed type of genericDefinition (List<>, Dictionary<,>) that the type is or derives from, or null.
72	public static Type? FindGenericBase(this Type type, Type genericDefinition)
73	{
74	for (var current = type; current != null; current = current.BaseType)	6,290,112 ✔
75	{
76	if (current.IsGenericType && current.GetGenericTypeDefinition() == genericDefinition)	3,105,867 ✔
77	{
78	return current;	2,892,459 ✔
79	}
80	}
81
82	return null;	39,189 ✔
83	}
84
85	public static DuckDBLogicalType GetLogicalType<T>() => typeof(T).GetLogicalType();	762 ✔
86
87	public static DuckDBLogicalType GetLogicalType(this Type type)
88	{
89	type = type.UnderlyingTypeOrSelf();	3,132 ✔
90
91	if (type == typeof(decimal))	3,132 ✔
92	{
93	return NativeMethods.LogicalType.DuckDBCreateDecimalType(38, 18);	138 ✔
94	}
95
96	if (type.IsAssignableTo(typeof(IList)) && type.IsGenericType)	2,994 ✔
97	{
98	var genericTypeParameter = type.GetGenericArguments()[0];	51 ✔
99	using var nestedType = genericTypeParameter.GetLogicalType();	51 ✔
100	return NativeMethods.LogicalType.DuckDBCreateListType(nestedType);	51 ✔
101	}
102
103	if (ClrToDuckDBTypeMap.TryGetValue(type, out var duckDBType))	2,943 !
104	{
105	return NativeMethods.LogicalType.DuckDBCreateLogicalType(duckDBType);	2,943 ✔
106	}
107
UNCOV 108	throw new InvalidOperationException($"Cannot map type {type.FullName} to DuckDBType.");	×
109	}	51 ✔
110
111	public static DuckDBType GetDuckDBType(this Type type) => ClrToDuckDBTypeMap.GetValueOrDefault(type, DuckDBType.Invalid);	177 ✔
112	}

Giorgi / DuckDB.NET / 42028758342

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous