cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-2366) Incorrect EJBQL COUNT translation
Date Sat, 23 Sep 2017 13:46:02 GMT
Andrus Adamchik created CAY-2366:
------------------------------------

             Summary: Incorrect EJBQL COUNT translation
                 Key: CAY-2366
                 URL: https://issues.apache.org/jira/browse/CAY-2366
             Project: Cayenne
          Issue Type: Bug
    Affects Versions: 4.0.B2
            Reporter: Andrus Adamchik
            Assignee: Nikita Timofeev


As a part of 4.0.B2 evaluation, I tried running LinkRest tests on 4.0.B2. I got a few errors
related to EJBQL query with COUNT translation. Consider this query for instance:

{noformat}
select count(a) from E17 a
{noformat}

Previous it generated SQL like this:

{noformat}
SELECT COUNT(*) AS sc0 FROM utest.e17 t0 
{noformat}

Now it generates SQL with an explicit ID inside COUNT, but the alias for the column and the
alias for the table do not match:

{noformat}
SELECT COUNT(t0.id1) AS sc0 FROM utest.e17 t1 
{noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message