Andrey Khitrin created IGNITE-18173: ---------------------------------------
Summary: SQL: implement EVERY and SOME aggregate functions Key: IGNITE-18173 URL: https://issues.apache.org/jira/browse/IGNITE-18173 Project: Ignite Issue Type: Improvement Components: sql Reporter: Andrey Khitrin Aggregate functions EVERY and SOME are part of SQL standard. Unfortunately, they're not implemented in AI3 beta1 yet. Could you please implement them? In AI2, they work in the following manner: {code:sql} create table tmp_table_age_name_wage (key_field INT PRIMARY KEY,AGE INT,field1 VARCHAR,field2 INT); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (1, 42,'John',100000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (2, 43,'Jack',50000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (3, 42,'Jen',30000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (4, 42,'Jim',70000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (5, 41,'Jess',30000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (6, 50,'Joe',40000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (7, 43,'Jeff',20000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (8, 32,'Joel',80000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (9, 33,'Joe',30000); insert into tmp_table_age_name_wage (key_field,AGE,field1,field2) values (10, 41,'Jill',90000); SELECT EVERY(AGE > 20) FROM tmp_table_age_name_wage; --> true SELECT EVERY(AGE > 40) FROM tmp_table_age_name_wage; --> false SELECT SOME(field2 = 90000) FROM tmp_table_age_name_wage; --> true SELECT SOME(field2 <> 90000) FROM tmp_table_age_name_wage; --> true {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)