Question about Statement.table

[YuzuWiki]

GORM Playground Link

https://github.com/go-gorm/playground/pull/1

Description

this issue about Statement.table . in some cases, it can lead to unexpected results.

Other issuse See: https://github.com/go-gorm/gorm/issues/7280

Source Code SEE: LINE 493, https://github.com/go-gorm/gorm/blob/master/statement.go

Example：

• exec sql

  
  db, _ = gorm.Open(mysql.Open(dsn), &config)

use SQL

type OtherTable struct { Name string }

var retSQL OtherTable db.Raw(SELECT name FROM xxx JOIN ..... LIMIT 1;).Scan(&retSQL )

some time, db.statement.table  will  be set to **other_table**.  now, db looks like this

db: { Statement: { Table: "other_table", Model: nil, ........ } }

now，If we continue to execute 

type User struct { ...... }

func (u User ) TableName() string { return "user" }

var u User db.Model(User{}).Where("id =?", uid).Find(&u)

maybe, we will get the following results

SELECT * FROM `database`.other_table WHERE id = ? limit 1;

but our expected result is

SELECT * FROM `database`.user WHERE id = ?;

<!-- Your use case -->