Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5933

SQL sorting error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 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
    • 10.8.3.3, 10.9.2.2, 10.10.1.1
    • SQL
    • Windows 7 Netbeans JDBC GUI
    • Normal
    • Repro attached
    • 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. 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

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

              Dates

                Created:
                Updated:
                Resolved: