The test - org.hibernate.test.unionsubclass.UnionSubclassTest
produces sql that's not supported by ASE. Select from a (compound query with union clause) would require 'as tablename' to work on ASE. The query errors out 'derived table expression is missing a correlation name.

select
count(bid)
from
( select
bid,
ident,
location,
sex,
salary,
null as species,
null as hive,
2 as clazz_
from
employees
union
all select
bid,
ident,
location,
sex,
null as salary,
null as species,
null as hive,
1 as clazz_
from
humans
union
all select
bid,
ident,
location,
null as sex,
null as salary,
species,
hive,
3 as clazz_
from
aliens
)
where
location =?