the original idea of the native sql approach is to avoid/reduce doing anything magical
with the query since
there is no way to fix these generally without a full sql parser.
So I would say it works as expected.
/max
On Nov 29, 2011, at 11:59, Strong Liu wrote:
T_User
id username
1 stliu
2 gail
for example a native query sql "select v1.username, v2.username from T_User v1,
T_User v2 where v1.id = '1' and v2.id = '2'"
but the query returns ["stliu", "stliu"] instead of the expected
["stliu", "gail"]
this is because hibernate uses column alias (in this case, both are "username")
to get the result from ResultSet, and since the two result in RS are all keyed by
"username"
should we generate a alias for each like hql does?
-------------------------
Best Regards,
Strong Liu <stliu at hibernate.org>
http://about.me/stliu/bio
_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
/max
http://about.me/maxandersen