Sta mi ne valja u GROUP BY ?
Imam naredbu:
SELECT YEAR(vreme) AS YR, MONTH(vreme) AS MNT,
SUM(brojpromena) AS A,
SUM(brojdogadjaja) AS B
FROM MOJATABELA WHERE testflag <> '1'
GROUP BY YR, MNT
ORDER BY YR DESC, MNT DESC
kojom hoću da nađem mesečne zbirove nekih kolona. Upit mi iz Jave na MySQL radi korektno.
Probam isto sa DerbyDB (open source verzija Cloudscape) i javlja mi kroz debugger
Column 'YR' is not in any table in the FROM list or
it appears within a join specification and
is outside the scope of the join specification or
it appears in a HAVING clause and is not in the GROUP BY list.
If this is a CREATE or ALTER TABLE statement then 'YR' is not a column in the target table.
Oči sam izgubio gledajući i ne vidim šta treba da uradim. Možda je doduše bug u derby bazi. Ne znam tačno sta SQL standardi kazu , ali se meni ovo moje čini sasvim korektno.
Da li je dozvoljeno da rezultat neke funkcije bude u GROUP BY, jer pretpostavljam da je to ovde problem ?
 |  |
 |
