AppendStruct() and Tuple support

[topofstack]

Hi, looks like AppendStruct API does not support structs with nested fields. Here's an extended version of official example:

type Nested struct {
	Foo int64
}

type Row struct {
	Col1       uint64
	Col4       time.Time
	Col2       string
	Col3       []uint8
	Col5       *Nested
	ColIgnored string
}

func TestAppendStructInsert() {
	conn, err := OpenDB()
	if err != nil {
		log.Fatal(err)
	}

	ctx := context.Background()

	if err := conn.Exec(ctx, `DROP TABLE IF EXISTS example`); err != nil {
		log.Fatal(err)
	}

	if err := conn.Exec(ctx, `
		CREATE TABLE example (
			  Col1 UInt64
			, Col2 String
			, Col3 Array(UInt8)
			, Col4 DateTime
			, Col5 Tuple(Foo Int64)
		) Engine = Memory
		`); err != nil {
		log.Fatal(err)
	}

	batch, err := conn.PrepareBatch(context.Background(), "INSERT INTO example")
	if err != nil {
		log.Fatal(err)
	}

	err = batch.AppendStruct(&Row{
		Col1:       uint64(100),
		Col2:       "Golang SQL database driver",
		Col3:       []uint8{1, 2, 3, 4, 5, 6, 7, 8, 9},
		Col4:       time.Now(),
		ColIgnored: "this will be ignored",
		Col5: &Nested{
			Foo: 1000000,
		},
	})
	if err != nil {
		log.Fatal(err)
	}
}

The message I get says:
clickhouse [AppendRow]: Col5 clickhouse [AppendRow]: converting *main.Nested to Tuple(Foo Int64) is unsupported

Is there any workaround or any future plans to support this feature?

[spaghettifunk]

Having the same issue but with a different error. I receive clickhouse [AppendStruct]: missing destination name <column_name> in *<struct>. However, instead of using a Tuple I use Nested. Did you figure out a workaround?

[mehXX]

@spaghettifunk have you found the solution for this?