search

gogf / gf

GoFrame is a modular, powerful, high-performance and enterprise-class application development framework of Golang.
https://goframe.org
MIT License
11.79k stars 1.61k forks source link

frame/g: The random sorting method in gdb is not compatible with Sqlite #3705

Closed lingcoder closed 2 months ago

lingcoder commented 4 months ago

Go version

go version go1.22.4 windows/amd64

GoFrame version

2.7.2

Can this bug be reproduced with the latest release?

Option Yes

What did you do?

0ad7afa188a91cb40294d9285a59ae3

sqlite中语法是 ORDER BY RANDOM()，mysql语法是 ORDER BY RAND()，goframe的代码里写死了只支持RAND()

What did you see happen?

执行到此会报错

What did you expect to see?

希望从驱动层面支持sqlite的随机排序

flow6979 commented 3 months ago

Hey, i would like to work on this issue. Thanks!!