Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-8900

SqlFieldsQuery provides incorrect result when item size exceeds page size

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.7
    • Component/s: sql
    • Labels:
      None

      Description

      Start several server nodes, then start client, execute queries with value range in where clause. Duplicate entries may be found, some entries may be missing.

      Results as an example:

      expected 5 results but got back 3 results (query range 610026643276160000 to 610026643276160004), cache.getAll returned 5 entries.

      expected 8 results but got back 7 results (query range 610026643276160000 to 610026643276160007), cache.getAll returned 8 entries.
      Query results: [610026643276160000, 610026643276160003, 610026643276160004, 610026643276160005, 610026643276160005, 610026643276160006, 610026643276160007]

      Please find reproducer attached.

        Attachments

        1. Node.java
          0.2 kB
          Anton Kurbanov
        2. Main.java
          5 kB
          Anton Kurbanov

          Activity

            People

            • Assignee:
              ilantukh Ilya Lantukh
              Reporter:
              antkr Anton Kurbanov
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 20m
                20m