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

        Issue Links

          Activity

            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