[hibernate-dev] any suggestion about how to fix HHH-5992?

[Sanne Grinovero]

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