Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 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
    • Fix Version/s: 10.8.3.3, 10.9.2.2, 10.10.1.1
    • Component/s: SQL
    • Environment:
      Windows 7 Netbeans JDBC GUI
    • Urgency:
      Normal
    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Wrong query result

      Description

      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.

      1. wrong_sorting.png
        56 kB
        Vlasov Igor
      2. right_sorting.png
        56 kB
        Vlasov Igor
      3. repro.sql
        0.4 kB
        Knut Anders Hatlen
      4. Helpdesk.zip
        168 kB
        Vlasov Igor
      5. d5933-remap+test.diff
        3 kB
        Dag H. Wanvik
      6. d5933-remap.diff
        0.9 kB
        Knut Anders Hatlen
      7. d5933-pof.diff
        0.8 kB
        Dag H. Wanvik
      8. 5933.log
        193 kB
        Dag H. Wanvik

        Issue Links

          Activity

          Vlasov Igor created issue -
          Vlasov Igor made changes -
          Field Original Value New Value
          Description 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.

           
          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

           
          Vlasov Igor made changes -
          Description 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

           
          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.
              
           
          Vlasov Igor made changes -
          Attachment wrong_sorting.png [ 12545898 ]
          Attachment right_sorting.png [ 12545899 ]
          Vlasov Igor made changes -
          Attachment Helpdesk.zip [ 12546006 ]
          Knut Anders Hatlen made changes -
          Attachment repro.sql [ 12546164 ]
          Knut Anders Hatlen made changes -
          Labels derby_triage10_10
          Affects Version/s 10.8.1.2 [ 12316362 ]
          Affects Version/s 10.7.1.1 [ 12315564 ]
          Affects Version/s 10.6.1.0 [ 12313727 ]
          Affects Version/s 10.5.1.1 [ 12313771 ]
          Affects Version/s 10.4.1.3 [ 12313111 ]
          Affects Version/s 10.3.1.4 [ 12312590 ]
          Affects Version/s 10.2.1.6 [ 11187 ]
          Affects Version/s 10.1.1.0 [ 10993 ]
          Affects Version/s 10.0.2.1 [ 10991 ]
          Urgency Urgent [ 10051 ] Normal [ 10052 ]
          Issue & fix info Repro attached [ 10424 ]
          Dag H. Wanvik made changes -
          Attachment 5933.log [ 12546346 ]
          Dag H. Wanvik made changes -
          Attachment d5933-pof.diff [ 12546395 ]
          Knut Anders Hatlen made changes -
          Attachment d5933-remap.diff [ 12546506 ]
          Dag H. Wanvik made changes -
          Attachment d5933-remap+test.diff [ 12546532 ]
          Dag H. Wanvik made changes -
          Link This issue is related to DERBY-4695 [ DERBY-4695 ]
          Dag H. Wanvik made changes -
          Link This issue is related to DERBY-3023 [ DERBY-3023 ]
          Dag H. Wanvik made changes -
          Link This issue is related to DERBY-4679 [ DERBY-4679 ]
          Dag H. Wanvik made changes -
          Link This issue is related to DERBY-2526 [ DERBY-2526 ]
          Dag H. Wanvik made changes -
          Issue & fix info Repro attached [ 10424 ] Patch Available,Repro attached [ 10102, 10424 ]
          Dag H. Wanvik made changes -
          Issue & fix info Patch Available,Repro attached [ 10102, 10424 ] Repro attached [ 10424 ]
          Dag H. Wanvik made changes -
          Assignee Dag H. Wanvik [ dagw ]
          Dag H. Wanvik made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.10.0.0 [ 12321550 ]
          Resolution Fixed [ 1 ]
          Gavin made changes -
          Workflow jira [ 12726255 ] Default workflow, editable Closed status [ 12801967 ]
          Kathey Marsden made changes -
          Assignee Dag H. Wanvik [ dagw ] Kathey Marsden [ kmarsden ]
          Kathey Marsden made changes -
          Assignee Kathey Marsden [ kmarsden ] Dag H. Wanvik [ dagw ]
          Fix Version/s 10.8.3.1 [ 12323475 ]
          Fix Version/s 10.9.2.2 [ 12323562 ]
          Kathey Marsden made changes -
          Link This issue is related to DERBY-6289 [ DERBY-6289 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Dag H. Wanvik
              Reporter:
              Vlasov Igor
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development