ERROR #42P01 missing FROM-clause entry for table \"_data\"

[tapir]

I have this struct

type Order struct {
	tableName       struct{} `sql:"orders"`
	ID              string   `sql:"id,pk,type:uuid"`
	Status          string   `sql:"status,type:status"`
	Side            string   `sql:"type:side"`
	BailoutTime     time.Duration
	BailoutPrice    decimal.Decimal `sql:"type:numeric"`
	AveragePrice    decimal.Decimal `sql:"type:numeric"`
	DepositedAmount decimal.Decimal `sql:"type:numeric"`
	FilledAmount    decimal.Decimal `sql:"type:numeric"`
	Balance         decimal.Decimal `sql:"type:numeric"`
	StartingTime    time.Time       `sql:"type:timestamp"`
	EndingTime      time.Time       `sql:"type:timestamp"`
}

I'm doing a bulk update via

db.Model(&orders).Update()

Sql generated is this

UPDATE orders AS "order" 
SET    "status" = _data."status", 
       "side" = _data."side", 
       "bailout_time" = _data."bailout_time", 
       "bailout_price" = _data."bailout_price", 
       "average_price" = _data."average_price", 
       "deposited_amount" = _data."deposited_amount", 
       "filled_amount" = _data."filled_amount", 
       "balance" = _data."balance", 
       "starting_time" = _data."starting_time", 
       "ending_time" = _data."ending_time" 
WHERE  "order"."id" = _data."id" 

any ideas?

thanks

[vmihailenco]

I guess orders are empty?

[brian-freeman]

I get the same error when attempting an Upsert:

_, err := db.Model(&something).
		OnConflict("(foo, bar) DO UPDATE").
		Set("total = something.total + 1").
		Set("updated_at = EXCLUDED.updated_at").
		Insert()

It seems to have something to do with the AS "something" that is being injected by the ORM. If I remove that bit and run the query manually, it works. In other words, if I take the SQL that this go library is generating, and remove the AS . . . clause, and run the query manually in psql, it works.

If it matters, I'm on postgres 10

[vmihailenco]

Can you please provide the query this lib generates and the query that works for you?