Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1432

Run limit query that has only leading PK column filter serially

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.3.0, 3.3.0, 4.2.1, 3.2.1
    • None
    • None

    Description

      If we have a query with a LIMIT clause and either no WHERE clause or a WHERE clause that only filters on the leading PK columns, we should run it serially. Otherwise, we're spawning too many client-side threads that likely won't be required.

      Attachments

        1. PHOENIX-1432.patch
          96 kB
          James R. Taylor
        2. PHOENIX-1432_v1.patch
          74 kB
          James R. Taylor
        3. PHOENIX-1432_v2.patch
          75 kB
          James R. Taylor
        4. PHOENIX-1432_v3.patch
          86 kB
          James R. Taylor

        Activity

          People

            jamestaylor James R. Taylor
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: