db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5933) SQL sorting error
Date Tue, 25 Sep 2012 13:54:07 GMT

    [ https://issues.apache.org/jira/browse/DERBY-5933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13462741#comment-13462741
] 

Bryan Pendleton commented on DERBY-5933:
----------------------------------------

Thanks for the pointer to DERBY-3023. It was very helpful to re-read Army's 
comments in that issue, and in the older DERBY-2526. Thank goodness for
6 years of accumulated JIRA discussions to refer back to!

I do wonder if, in some future patch, the logic contained in d5933-remap.diff could be
somehow moved down into the ResultColumn class itself, rather than being
in its caller.

But this is incredibly delicate code and I'm not advocating to expand the
scope of this issue. +1 to the approach outlined in d5933-remap.diff.
                
> SQL sorting error
> -----------------
>
>                 Key: DERBY-5933
>                 URL: https://issues.apache.org/jira/browse/DERBY-5933
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.0.2.1, 10.1.1.0, 10.2.1.6, 10.3.1.4, 10.4.1.3, 10.5.1.1, 10.6.1.0,
10.7.1.1, 10.8.1.2, 10.9.1.0
>         Environment: Windows 7 Netbeans JDBC GUI
>            Reporter: Vlasov Igor
>              Labels: derby_triage10_10
>         Attachments: 5933.log, d5933-pof.diff, d5933-remap.diff, Helpdesk.zip, repro.sql,
right_sorting.png, wrong_sorting.png
>
>
> Hello 
> I have a simple database with 100 records.
> I am running a SQL query from Netbeans GUI though JDBC
> This query was generated by Hibernate ORM.
> In certain circumstances the result rowset is not sorting.
> When I use  condition morefld2_.mf_id in (5) the result is unsortable.
> When I use  condition morefld2_.mf_id in (5,0) the result is sorting properly.
>     
>  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message