ListDistinctSingular.sql 366 B

12345678910111213141516
  1. /* syntax version 1 */
  2. select AGGREGATE_LIST_DISTINCT(x) from
  3. (select [null, null] as x)
  4. flatten list by x;
  5. select AGGREGATE_LIST_DISTINCT(x) from
  6. (select [void(), void()] as x)
  7. flatten list by x;
  8. select AGGREGATE_LIST_DISTINCT(x) from
  9. (select [[], []] as x)
  10. flatten list by x;
  11. select AGGREGATE_LIST_DISTINCT(x) from
  12. (select [{}, {}] as x)
  13. flatten list by x;