gorm:primaryKey not being taken into consideration by auto migrator

[prajjwaldimri]

Hi.

I am trying to create a table in the clickhouse database using gorm's auto migrator. I have defined the struct as below:

type Cost struct {
	InfraId    string    `json:"infra_id" gorm:"primaryKey,index:idx_primary"`
	Timestamp  time.Time `json:"timestamp" gorm:"primaryKey,index:idx_primary"`
	HourlyCost string    `json:"hourly_cost"`
}

When the automigrator runs, it sends the following SQL statement to the clickhouse DB.

CREATE TABLE `costs`(`infra_id` String,`timestamp` DateTime64(3),`hourly_cost` String  ) ENGINE=MergeTree() ORDER BY tuple()

As you can see, for some reason, it doesn't send any information about the primary keys. I have verified that it actually doesn't create any primary keys on the DB too. Why might this be happening?

Thanks.

[xiyichan]

I have same problem.

[zyjblockchain]

I have same problem

[zyjblockchain]

https://github.com/go-gorm/clickhouse/blob/master/migrator.go#L130

this function alse is a todo list