autogen_columns_conflict.sql 414 B

1234567891011121314151617181920212223242526272829
  1. /* dq can not */
  2. /* dqfile can not */
  3. /* yt can not */
  4. /* postgres can not */
  5. $src = select <|column0:1|> as x;
  6. $src = select * from $src flatten columns;
  7. select 2, a.* from $src as a;
  8. select 2, 1 as column0;
  9. select 2, 1 as column0
  10. union all
  11. select 4, 3 as column0;
  12. select * from (select 1) as a join (select 1) as b using(column0);
  13. select
  14. 1 as a,
  15. 2 as b,
  16. 3, -- should be column2
  17. 4 as column1;