can't load rest data after insert blank record

[tablecell]

no-data-after-blank-record.go

package main

import (
	"fmt"
	dbr "github.com/gocraft/dbr/v2"
	_ "github.com/mattn/go-sqlite3"
)

type Item struct {
	ID   int
	Name string
}

func main() {
	// CREATE TABLE `item`(`id` integer DEFAULT (NULL) NOT NULL UNIQUE PRIMARY KEY AUTOINCREMENT, `name` varchar(255));

	sqlite3Session, err := dbr.Open("sqlite3", "item.db", nil)

	sugg := Item{Name: "aaa"}

	sess := sqlite3Session.NewSession(nil)

	res, err := sess.InsertInto("item").
		Columns("Name"). // insert  a blank item     no err report
		Record(&sugg).Exec()
/*
sqlite> select * from item;
1   -
*/
	fmt.Println(res, err)

	sugg = Item{Name: "bbb"}

	res, err = sess.InsertInto("Item").
		Columns("name"). //    add  a  record has field name data
		Record(&sugg).Exec()
	fmt.Println(res, err)
/*
sqlite> select * from item;
1| -
2|bbb
*/

	var items []Item

	sess.Select("name").From("item").Load(&items) // can't load  rest data  after  blank record
	for k, v := range items {
		fmt.Println(k, v)
	}

}

[taylorchu]

0 sql: Scan error on column index 0, name "name": converting NULL to string is unsupported

Please confirm this by checking returning values of Load.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.