summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/aggregates.sql
AgeCommit message (Expand)Author
2025-04-20Fix issue with ORDER BY / DISTINCT aggregates and FILTERDavid Rowley
2025-03-09Don't try to parallelize array_agg() on an anonymous record type.Tom Lane
2025-02-18Fix poorly written regression testDavid Rowley
2024-12-12Detect redundant GROUP BY columns using UNIQUE indexesDavid Rowley
2024-10-09Consider explicit incremental sort for mergejoinsRichard Guo
2024-10-08Add min and max aggregates for bytea type.Tom Lane
2024-07-11Add min and max aggregates for composite types (records).Tom Lane
2024-06-06Fix asymmetry in setting EquivalenceClass.ec_sortrefAlexander Korotkov
2024-05-18Add test case showing that commit d0d44049d fixed a live bug.Tom Lane
2024-04-18Fix typos and duplicate wordsDaniel Gustafsson
2024-03-27Fix unstable aggregate regression testDavid Rowley
2024-02-23Multiple revisions to the GROUP BY reordering testsAlexander Korotkov
2024-02-19Get rid of pg_class usage in SJE regression testsAlexander Korotkov
2024-02-09Fix usage of aggregate pathkeys in group_keys_reorder_by_pathkeys()Alexander Korotkov
2024-01-24Rename index "abc" in aggregates.sqlAlexander Korotkov
2024-01-21Fix table name collision in tests in 0452b461bcAlexander Korotkov
2024-01-21Explore alternative orderings of group-by pathkeys during optimization.Alexander Korotkov
2024-01-04Fix use of incorrect TupleTableSlot in DISTINCT aggregatesDavid Rowley
2023-04-16Ensure result of an aggregate's finalfunc is made read-only.Tom Lane
2023-03-13Fix failure to detect some cases of improperly-nested aggregates.Tom Lane
2023-02-22Implement ANY_VALUE aggregatePeter Eisentraut
2023-02-13Fix incorrect presorted DISTINCT aggregate if conditionDavid Rowley
2023-01-30Make Vars be outer-join-aware.Tom Lane
2023-01-23Harden new parallel string_agg/array_agg regression testDavid Rowley
2023-01-23Allow parallel aggregate on string_agg and array_aggDavid Rowley
2023-01-17Don't presort ORDER BY/DISTINCT Aggrefs with volatile functionsDavid Rowley
2022-12-20Add enable_presorted_aggregate GUCDavid Rowley
2022-10-03Revert "Optimize order of GROUP BY keys".Tom Lane
2022-08-02Improve performance of ORDER BY / DISTINCT aggregatesDavid Rowley
2022-03-30Optimize order of GROUP BY keysTomas Vondra
2022-02-08Rearrange core regression tests to reduce cross-script dependencies.Tom Lane
2021-08-18Fix check_agg_arguments' examination of aggregate FILTER clauses.Tom Lane
2021-07-14Change the name of the Result Cache node to MemoizeDavid Rowley
2021-04-02Add Result Cache executor node (take 2)David Rowley
2021-04-01Revert b6002a796David Rowley
2021-03-31Add Result Cache executor nodeDavid Rowley
2021-03-15Drop SERIALIZABLE workaround from parallel query tests.Thomas Munro
2021-03-06Add bit_xor aggregate functionPeter Eisentraut
2020-07-22Support infinity and -infinity in the numeric data type.Tom Lane
2020-06-13Fix behavior of float aggregates for single Inf or NaN inputs.Tom Lane
2020-06-11Fix mishandling of NaN counts in numeric_[avg_]combine.Tom Lane
2020-06-11Rework HashAgg GUCs.Jeff Davis
2020-03-24Reduce test time for disk-based Hash Aggregation.Jeff Davis
2020-03-19Introduce "anycompatible" family of polymorphic types.Tom Lane
2020-03-18Disk-based Hash Aggregation.Jeff Davis
2020-01-02Test GROUP BY matching of join columns that are type-coerced by USING.Tom Lane
2019-07-03Don't remove surplus columns from GROUP BY for inheritance parentsDavid Rowley
2019-05-23Fix array size allocation for HashAggregate hash keys.Andrew Gierth
2019-05-20Minimally fix partial aggregation for aggregates that don't have one argument.Andres Freund
2019-02-13Change floating-point output format for improved performance.Andrew Gierth