I agree we should not do any magic on a native query; but following this reasoning just anything should be possible, and I wouldn't expect Hibernate to apply such magic to the results either. Why is it even looking at names in the resultset? As a user I'd want it to just return the same ordered sequence of values.
I would consider it very important to allow a full "jdbc fallback" experience, otherwise instead of being a nice tool it becomes an impediment and users will rightfully hate you. Sanne On 29 November 2011 15:25, Max Rydahl Andersen <max.ander...@redhat.com> wrote: > 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 > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
