db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5933) SQL sorting error
Date Fri, 21 Sep 2012 14:52:07 GMT

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

Knut Anders Hatlen commented on DERBY-5933:
-------------------------------------------

Thanks, Igor. I can reproduce the incorrect ordering on trunk. (I had to disable Derby's authentication
checks to try the database, since it is password protected.)

The consistency checker didn't find any problems with the database.

The incorrect ordering is also seen in this simpler query:

select
        projecttas0_.t_id
    from
        project_task projecttas0_
    inner join
        morefld morefld2_
            on projecttas0_.mf_status=morefld2_.mf_id
    left outer join
        user_ user3_
            on projecttas0_.worker_id=user3_.usr_id
    inner join
        morefld morefld4_
            on projecttas0_.mf_level=morefld4_.mf_id
    where
            morefld2_.mf_id = 5
    order by
        projecttas0_.t_id desc;
                
> 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.9.1.0
>         Environment: Windows 7 Netbeans JDBC GUI
>            Reporter: Vlasov Igor
>         Attachments: Helpdesk.zip, 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