In my case, I need to use "For Update" query in a transaction. But when I use "Rows" method,"gorm:query_option" just does not work.
When I use "First" or "Find" method, "gorm:query_option" works very well,but it does not work in Rows method at all.
tx.Model(&model)
.Where("id=?",1622888221580295)
.Set("gorm:query_option","For Update")
.First(&model);
output is : SELECT * FROM 'table_name' WHERE (id='1622888221580295') ORDER BY 'adv_convert'.'id' ASC LIMIT 1 FOR UPDATE
rows,err := tx.Model(&model).Where("id=?",1622888221580295).Set("gorm:query_option","For Update").Rows();
output: SELECT * FROM 'table_name' WHERE (id='1622888221580295')
How can I query a "For Update" query with Rows method