database/gdb: FieldsPrefix generates inconsistent SQL across different database drivers in JOIN queries

[lingcoder]

Go version

go version go1.24 windows/amd64

GoFrame version

v2.9.0

Can this bug be reproduced with the latest release?

Option Yes

What did you do?

I encountered inconsistent SQL generation when using
FieldsPrefix
in JOIN queries across different database drivers. The same GoFrame ORM code generates different field selections between MySQL and PostgreSQL drivers.

What did you see happen?

package main

import (
    "context"
    "fmt"
    "github.com/gogf/gf/v2/database/gdb"
    "github.com/gogf/gf/v2/frame/g"
    "github.com/gogf/gf/v2/os/gctx"
	_ "github.com/gogf/gf/contrib/drivers/pgsql/v2"
)

func main() {
sqlstr, err := gdb.ToSQL(gctx.New(), func(ctx context.Context) error {
	_, err := dao.OpenApp.Ctx(ctx).OmitEmpty().As("t1").
		LeftJoin(dao.MemberInfo.Table(), "t2", "t1.app_id = t2.uid").
		FieldsPrefix("t2", dao.MemberInfo.Columns().Id, dao.MemberInfo.Columns().DisplayName).
		All()
	return err
})
fmt.Println(sqlstr)

Table Structures:

-- Verify search_path is set correctly
SHOW search_path;  -- Should return: abc, public

-- Tables are in 'abc' schema
CREATE SCHEMA abc;
-- open_app table
CREATE TABLE abc.open_app (
    id BIGINT PRIMARY KEY,
    app_id VARCHAR(100),
    deleted_at TIMESTAMP
);

-- member_info table  
CREATE TABLE abc.member_info (
    id BIGINT PRIMARY KEY,
    uid VARCHAR(100),
    display_name VARCHAR(100),
    deleted_at TIMESTAMP
);

Then I see:

SELECT * FROM "open_app" AS t1 LEFT JOIN "member_info" AS "t2" ON (t1.app_id = t2.uid) WHERE "t1"."deleted_at" IS NULL AND "t2"."deleted_at" IS NULL

Issue: The
FieldsPrefix("t2", dao.MemberInfo.Columns().Id, dao.MemberInfo.Columns().DisplayName)
is completely ignored.

Root Cause
GoFrame's
TableFields()
method only searches the public schema, ignoring the configured search_path. When tables are in a different schema (like abc), field validation fails and the query falls back to SELECT *.

Impact
Unnecessary SELECT * queries
Breaks schema-based multi-tenant applications
Workaround
Use explicit
Fields()
:

go
.Fields("t2.id", "t2.display_name")

What did you expect to see?

SELECT t2.id, t2.display_name FROM "open_app" AS t1 
LEFT JOIN "member_info" AS "t2" ON (t1.app_id = t2.uid) 
WHERE "t1"."deleted_at" IS NULL AND "t2"."deleted_at" IS NULL

[lingcoder]

[lingcoder]

pr 4602已经修复了这个问题