ydb/yql/essentials/tests/postgresql/cases/select_distinct_on.err

Registering pre-existing tables
	int4_tbl
	INT4_TBL
	tmp
<sql-statement>
--
-- SELECT_DISTINCT_ON
--
SELECT DISTINCT ON (string4) string4, two, ten
   FROM tmp
   ORDER BY string4 using <, two using >, ten using <;
</sql-statement>
-stdin-:<main>: Error: Parse Sql

    -stdin-:<main>:6:27: Error: sortby_dir unsupported value: 3
    	   ORDER BY string4 using <, two using >, ten using <;
	                          ^
<sql-statement>
-- this will fail due to conflict of ordering requirements
SELECT DISTINCT ON (string4, ten) string4, two, ten
   FROM tmp
   ORDER BY string4 using <, two using <, ten using <;
</sql-statement>
-stdin-:<main>: Error: Parse Sql

    -stdin-:<main>:4:27: Error: sortby_dir unsupported value: 3
    	   ORDER BY string4 using <, two using <, ten using <;
	                          ^
<sql-statement>
SELECT DISTINCT ON (string4, ten) string4, ten, two
   FROM tmp
   ORDER BY string4 using <, ten using >, two using <;
</sql-statement>
-stdin-:<main>: Error: Parse Sql

    -stdin-:<main>:3:27: Error: sortby_dir unsupported value: 3
    	   ORDER BY string4 using <, ten using >, two using <;
	                          ^
<sql-statement>
-- 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;
</sql-statement>