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@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev /max http://about.me/maxandersen _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
