Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 94b1c249a1
Branches Tags
ydb
/
yql
/
essentials
/
tests
/
postgresql
/
cases
/
select_distinct_on.out

select_distinct_on.out 203 B
History Raw

1234567 
  1. -- bug #5049: early 8.4.x chokes on volatile DISTINCT ON clauses
    2. 

  2. select distinct on (1) floor(random()) as r, f1 from int4_tbl order by 1,2;
    3. 

  3.  r |     f1      
    4. 

  4. ---+-------------
    5. 

  5.  0 | -2147483647
    6. 

  6. (1 row)
    7. 

  7.