Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-2438

Consider assigns when pushing limit with condition into data scan

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: COMP - Compiler
    • Labels:
      None

      Description

      Currently PushLimitIntoPrimarySearchRule stops at assign operators and therefore doesn't not push select condition into data-scan if there's an assign in between. We should fix this to allow such conditions be pushed into data scan.

      Here are example queries:

      Q1:

      select substring(dblpid, 0, 21)
      from DBLP1
      where dblpid > "series"
      limit 1;

      Q2:

      select value t.user.lang
      from TweetMessages t
      where t.user.friends_count between 0 and 150
      limit 2

       

        Attachments

          Activity

            People

            • Assignee:
              dlychagin-cb Dmitry Lychagin
              Reporter:
              dlychagin-cb Dmitry Lychagin
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: