Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Thu, 20 Sep 2012 23:34:07 +1100 (NCT)
From: "Vlasov Igor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <372991343.102195.1348144447773.JavaMail.jiratomcat@arcas>
In-Reply-To: <1644533331.102159.1348144210677.JavaMail.jiratomcat@arcas>
Subject: [jira] [Commented] (DERBY-5933) SQL sorting error
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Vlasov Igor commented on DERBY-5933:
------------------------------------

The query is 

    select
        projecttas0_.t_id as t1_4_0_,
        project1_.p_id as p1_3_1_,
        morefld2_.mf_id as mf1_2_2_,
        user3_.usr_id as usr1_9_3_,
        morefld4_.mf_id as mf1_2_4_,
        projecttas0_.t_content as t2_4_0_,
        projecttas0_.t_deadline as t3_4_0_,
        projecttas0_.t_hours as t4_4_0_,
        projecttas0_.mf_level as mf9_4_0_,
        projecttas0_.sys_usr as sys10_4_0_,
        projecttas0_.sys_cre as sys5_4_0_,
        projecttas0_.sys_end as sys6_4_0_,
        projecttas0_.sys_upd as sys7_4_0_,
        projecttas0_.owner_id as owner11_4_0_,
        projecttas0_.p_id as p12_4_0_,
        projecttas0_.t_start as t8_4_0_,
        projecttas0_.mf_status as mf13_4_0_,
        projecttas0_.worker_id as worker14_4_0_,
        project1_.mf_level as mf7_3_1_,
        project1_.p_name as p2_3_1_,
        project1_.sys_usr as sys8_3_1_,
        project1_.sys_cre as sys3_3_1_,
        project1_.sys_end as sys4_3_1_,
        project1_.sys_upd as sys5_3_1_,
        project1_.p_start as p6_3_1_,
        morefld2_.dm_id as dm8_2_2_,
        morefld2_.mf_key as mf2_2_2_,
        morefld2_.mf_name as mf3_2_2_,
        morefld2_.sys_usr as sys9_2_2_,
        morefld2_.sys_cre as sys4_2_2_,
        morefld2_.sys_end as sys5_2_2_,
        morefld2_.sys_upd as sys6_2_2_,
        morefld2_.mf_order as mf7_2_2_,
        user3_.usr_blocked as usr2_9_3_,
        user3_.usr_email as usr3_9_3_,
        user3_.usr_fio as usr4_9_3_,
        user3_.if_user as if5_9_3_,
        user3_.last_login as last6_9_3_,
        user3_.usr_login as usr7_9_3_,
        user3_.sys_usr as sys14_9_3_,
        user3_.sys_cre as sys8_9_3_,
        user3_.sys_end as sys9_9_3_,
        user3_.sys_upd as sys10_9_3_,
        user3_.usr_password as usr11_9_3_,
        user3_.usr_rme_code as usr12_9_3_,
        user3_.usr_emailsend as usr13_9_3_,
        user3_.usr_type as usr15_9_3_,
        morefld4_.dm_id as dm8_2_4_,
        morefld4_.mf_key as mf2_2_4_,
        morefld4_.mf_name as mf3_2_4_,
        morefld4_.sys_usr as sys9_2_4_,
        morefld4_.sys_cre as sys4_2_4_,
        morefld4_.sys_end as sys5_2_4_,
        morefld4_.sys_upd as sys6_2_4_,
        morefld4_.mf_order as mf7_2_4_ 
    from
        project_task projecttas0_ 
    inner join
        project project1_ 
            on projecttas0_.p_id=project1_.p_id 
    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
        1=1 
        and (
            projecttas0_.sys_end is null
        ) 
        and (
            morefld2_.mf_id in (
                5
            )
        ) 
    order by
        projecttas0_.t_id desc fetch first 30 rows only

                
> 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
>
> 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.
>  

--
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