sql-server - SQL查询当前不支持返回别名

Question

我有这个试图在grails上运行的原始sql

final session = sessionFactory.currentSession;
final  String query  = 'select count(A.*)  from Artifact as A LEFT JOIN classification as C on (A.id=C.artifact_id) where C.id IS NULL OR C.active=0';
final sqlQuery = session.createSQLQuery(query);

def totalunclass =  sqlQuery.with {
                        addEntity(Artifact);                                        
                                }

但是我收到错误 Message: SQL queries do not currently support returning aliases我尝试了另一种方法，但也无法实现结果，请单击 here

Answer 1

尝试将查询行更改为如下所示

 final  String query  = 'select count(*)  from Artifact A LEFT JOIN classification C on (A.id=C.artifact_id) where C.id IS NULL OR C.active=0';