select_distinct_on.sql « cases « postgresql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/postgresql/cases/select_distinct_on.sql

blob: a59d3e4ff88660494249cfb59388fa208a3e42de (plain) (blame)

1
2

-- bug #5049: early 8.4.x chokes on volatile DISTINCT ON clauses
select distinct on (1) floor(random()) as r, f1 from int4_tbl order by 1,2;