hibernate - HQL错误:子句引用了两个不同的子句元素

Question

我正在尝试运行此查询，这将使我计数
但它确实有效

def query  = "select count(A.id) from Artifact A "+
             "LEFT JOIN A.classification C on (A.id=C.artifactId) "+
             "where C.id IS NULL";
def tc = Artifact.executeQuery(query);

Answer 1

这可能会有所帮助:

def query  = "select count(A.id) from Artifact A "+
             "LEFT JOIN A.classification C "+
             "where C.id IS NULL";
def tc = Artifact.executeQuery(query);

您无需在此处启用，因为Artifact应该已经通过映射与分类“连接”了。