使用MYSQL时，Grails条件查询失败，synatx错误

Question

我有一个查询在应用程序连接到MYSQL实例时失败。当使用H2内存数据库时，查询工作良好。所有其他查询都可以在MySQL中正常工作。

错误html" target="_blank">消息：您的SQL语法有错误；查看与您的MySQL server版本相对应的手册，了解第1行“）”附近使用的正确语法

def index() {
def currentUser = currentUser()
def peopleFollowing = currentUser.following
def c = Post.createCriteria()
    def postList = c.list  {
       'in' ("user", peopleFollowing)
       'order' "dateCreated", "desc"
    }
[postList:postList, user : currentUser, peopleFollowing:peopleFollowing]
}

class Post {


String content
Date dateCreated
User user


static belongsTo = [user : User]

static hasMany = [postComments: PostComment]

static constraints = {
    content (blank: false)
}

static mapping = {
    sort dateCreated:"desc"
    content type:"text"
    postComments sort:"dateCreated",  order:"desc"
}

}

类Post{String content Date dateCreated User用户静态归属=[User:User]静态hasMany=[postComments:PostComment]静态约束={content（blank：false）}静态映射={sort dateCreated：“Desc”内容类型：“Text”postComments排序：“dateCreated”,Order：“Desc”}}类Post{String content Date dateCreated User用户静态归属=[User:User]静态hasMany=[postComments:PostComment]静态约束={content（blank：false）}静态映射=

Answer 1

我通过以下操作修复了该问题：

def postList = Post.findAllByUserInList( peopleFollowing )