db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vlasov Igor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5933) SQL sorting error
Date Thu, 20 Sep 2012 12:34:07 GMT

    [ 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 

        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_ 
        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 
        and (
            projecttas0_.sys_end is null
        and (
            morefld2_.mf_id in (
    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:
>         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

View raw message