union_all_incompatible.sql 454 B

1234567891011121314151617181920212223242526
  1. select key from
  2. (
  3. select key, subkey from
  4. (
  5. select 1 as key, "foo" as subkey
  6. union all
  7. select 2 as key, "bar" as subkey
  8. union all
  9. select 3 as key, 123 as subkey
  10. )
  11. )
  12. order by key;
  13. select key from
  14. (
  15. select * from
  16. (
  17. select 4 as key, "baz" as subkey
  18. union all
  19. select 5 as key, "goo" as subkey
  20. union all
  21. select 6 as key, 456 as subkey
  22. )
  23. )
  24. order by key;