Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

🪲 Don't push filters past limits #1696

Closed
joocer opened this issue May 28, 2024 · 0 comments · Fixed by #1738
Closed

🪲 Don't push filters past limits #1696

joocer opened this issue May 28, 2024 · 0 comments · Fixed by #1738
Assignees
Labels
Bug 🪲 Something isn't working ⚙️ Query Optimizer Component Label - Optimizer

Comments

@joocer
Copy link
Contributor

joocer commented May 28, 2024

In this example, the LIKE should not have been pushed past the LIMIT

SELECT URL FROM (SELECT URL FROM hits LIMIT 1000000) AS a WHERE URL LIKE '%google%';
└─ EXIT
   └─ PROJECT (URL)
      └─ SUBQUERY AS a
         └─ LIMIT (1000000)
            └─ PROJECT (URL)
               └─ FILTER (URL LIKE '%google%')
                  └─ SCAN (hits) [URL]
@joocer joocer added Bug 🪲 Something isn't working 2️⃣nd Gen Optimizer ⚙️ Query Optimizer Component Label - Optimizer and removed 2️⃣nd Gen Optimizer labels May 28, 2024
@joocer joocer self-assigned this Jun 6, 2024
joocer added a commit that referenced this issue Jun 9, 2024
@joocer joocer mentioned this issue Jun 9, 2024
4 tasks
joocer added a commit that referenced this issue Jun 9, 2024
joocer added a commit that referenced this issue Jun 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug 🪲 Something isn't working ⚙️ Query Optimizer Component Label - Optimizer
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant