Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 27 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/pg/aggregate_factory.sql b/yql/essentials/tests/sql/suites/pg/aggregate_factory.sql
new file mode 100644
index 0000000000..6fbe0119bd
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/pg/aggregate_factory.sql
@@ -0,0 +1,27 @@
+select 
+Pg::string_agg(x,','p)
+from (values ('a'p),('b'p),('c'p)) as a(x);
+
+select 
+Pg::string_agg(x,','p) over (order by x),
+from (values ('a'p),('b'p),('c'p)) as a(x);
+
+$agg_string_agg = AggregationFactory("Pg::string_agg");
+
+select 
+AggregateBy((x,','p),$agg_string_agg)
+from (values ('a'p),('b'p),('c'p)) as a(x);
+
+select 
+AggregateBy((x,','p),$agg_string_agg) over (order by x),
+from (values ('a'p),('b'p),('c'p)) as a(x);
+
+$agg_max = AggregationFactory("Pg::max");
+
+select 
+AggregateBy(x,$agg_max)
+from (values ('a'p),('b'p),('c'p)) as a(x);
+
+select 
+AggregateBy(x,$agg_max) over (order by x),
+from (values ('a'p),('b'p),('c'p)) as a(x);