[MCOL-5116] Detect impossible predicates in WHERE and HAVING filters Created: 2022-06-05 Updated: 2023-12-15 |
|
| Status: | Open |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr, PrimProc |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | Roman | Assignee: | Max Mether |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | Columnstore - Technical debts in Optimizer / Rewriter |
| Description |
|
There are cases when MCS start processing queries with impossible conditions that must return empty set, e.g. SELECT * FROM t1 WHERE t1.c1 = 1 AND t1.c1 = 2. |