Advertisement
Guest User

Untitled

a guest
Jan 20th, 2020
161
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. drop table if exists _tmp_enum8
  2. ;;
  3. create table _tmp_enum8 (
  4. `е` Nullable(Enum8('A' = 1, 'B' = 2))
  5. ) Engine = Log
  6. ;;
  7. insert into _tmp_enum8 (е)
  8. select е from (
  9. select 'A' as e
  10. union ALL
  11. select 'B'
  12. union all
  13. select NULL
  14. )
  15.  
  16.  
  17. SQL Error [62]: ClickHouse exception, code: 62, host: 127.0.0.1, port: 14407; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 25 (line 1, col 25): е)
  18. select e from (
  19. select 'A' as e
  20. union ALL
  21. select 'B'
  22. union all
  23. select NULL
  24. ). Unrecognized token (version 19.16.2.2 (official build))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement