Details

    • Type: Bug
    • Status: Closed
    • Priority: 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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: