I am not able to run:
create table xpivot1
Srcdef='select table_type, left(table_name,1) as FirstLetter , count(table_type) as cnt from tables group by 1, 2';
The query returns an error:
, while root is still connected.
If I run the query from the command line, the same error reveals.