custom int type conversion: unsupported type

[0xh0b0]

type TestEnum int

const (
    TestEnumA TestEnum = iota
    TestEnumB
)
type TestModel struct {
    ID    int
    Field gonull.Nullable[TestEnum]
}

Scan fails with the following error

sql: Scan error on column index 1, name "field": unsupported type conversion

[LukaGiorgadze]

Hey @0xh0b0 Thanks for your feedback!

I just updated/added a test covering your case: 882c001 ✅

---

Are you sure that db returns the number/int?
Can you provide more details?

[0xh0b0]

@LukaGiorgadze
I think you have incorrect assertions in your unit test.
the unit test should be

	type TestEnum float32

	const (
		TestEnumA TestEnum = iota
		TestEnumB
	)

	type TestModel struct {
		ID    int
		Field gonull.Nullable[TestEnum]
	}

	// Simulate the scenario where the SQL driver returns an int64
	// This is common as database integer types are usually scanned as int64 in Go
	//
	// sqlReturnedValue (int64(0)) is convertible to float32.
	// The converted value 0 (as float32) matches TestEnumA, which is also 0 when converted to float32.
	sqlReturnedValue := int64(0)

	model := TestModel{ID: 1, Field: gonull.NewNullable(TestEnumA)}

	err := model.Field.Scan(sqlReturnedValue)
	assert.NoError(t, err, "Scan failed with unsupported type conversion")
	assert.Equal(t, TestEnumA, model.Field.Val, "Scanned value does not match expected enum value")

[LukaGiorgadze]

@0xh0b0 Oh yeh, my bad.
Here's a fix #11 which covers your case.
Thank you!