I have defined 2 tables:
CREATE TABLE rules (PK INTEGER PRIMARY KEY, code varchar(255));
CREATE TABLE results (PK INTEGER PRIMARY KEY, rule INTEGER, fulfilled boolean, FOREIGN KEY (rule) references rules(PK));
When I execute following query:
rul1.code AS RULE,
res1.fulfilled AS FULFILLED,
count( res2.PK )
FROM results res2 JOIN rules rul2 ON res2.rule = rul2.PK
WHERE ( rul2.PK = rul1.PK )
FROM results res1 JOIN rules rul1 ON res1.rule = rul1.PK
GROUP BY rul1.code , res1.fulfilled
I receive error:
java.sql.SQLSyntaxErrorException: expression not in aggregate or GROUP BY columns: (100*( COUNT())/(())
This problem appears only on version 2.2.9, on 2.2.8 it works fine. Also, when I run similar query on mysql it also works correctly.
Maybe this problem is somehow related to changes concerning bug with id 3534936.
Log in to post a comment.