pgxmock rows.Scan() unable to scan into pointer

[ayx-orion]

Writing tests for my implementation, it fails to rows.Scan() value into *time.Time. Put breakpoints on the test and debugger showing that rows.Scan returns an error

The specific line of code in my implementation with the scan:

func (api Api) GetResults(ctx, verificationId) {
        /* truncated */
	row := api.Provider.Db.QueryRow(cctx, sqlQuery, verificationId.String())

	var vr VerificationResult
	var submissionDateTime zeronull.Timestamptz
	var validationDateTime zeronull.Timestamptz
	var scanningDateTime zeronull.Timestamptz

	err := row.Scan(
		&vr.EntityId,
		&vr.AssetType,
		&vr.Progress,
		&submissionDateTime,
		&validationDateTime,
		&scanningDateTime,
	)
        /* truncated */
}

This is the test code where I'm using pgxmock:

	entityId := ulid.Make()
	subTime := time.Date(2023, 9, 14, 12, 27, 42, 234234, time.UTC)
	verTime := subTime.Add(time.Second * 10)
	scanTime := subTime.Add(time.Minute * 3)
	columns := []string{"entity_id", "asset_type", "progress_id", "submission_datetime", "verification_datetime", "scanning_datetime"}
	rows := [6]any{
		entityId.String(), "yxi", "in progress", &subTime, &verTime, &scanTime,
	}
        expectedRows := db.NewRows(columns)
        expectedRows.AddRow(rows...)


	db.ExpectQuery("SELECT v.entity_id").WithArgs(tt.verificationId.String()).WillReturnRows(expectedRows)

        result, err := api.GetResults(ctx, verificationId)   // <-- test fails inside of this method

{
    "level":"error",
    "error":"Scanning value error for column 'submission_datetime': cannot scan *time.Time",
    "time":"2023-09-21T14:15:14-07:00"
}

I'm not sure how to resolve this. The query + scan works when I use pgx.

This is the struct definition for a zeronull.Timestamptz:

We can see that it implements the Scan() function but the receiver is a pointer to a struct.

[pashagolub]

From what I see, you're passing a pointer and trying to read a time.Time. Would you please patch your code with this line:

rows := [6]any{
		entityId.String(), "yxi", "in progress", subTime, verTime, scanTime,
	}