[jira] [Created] (IGNITE-18173) SQL: implement EVERY and SOME aggregate functions

["Andrey Khitrin (Jira)" <ji...@apache.org>]

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)