[MCOL-3239] CS incorrectly pushes function filter predicate into a subquery. Created: 2019-04-08 Updated: 2020-08-25 Resolved: 2019-07-12 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | PrimProc |
| Affects Version/s: | None |
| Fix Version/s: | 1.2.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Roman | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | 2019-05, 2019-06 |
| Description |
|
The inner most query doesn't apply WHERE filters when used in a subquery in a CTE. |
| Comments |
| Comment by Roman [ 2019-05-27 ] |
|
The optimization in derivedTableOptimization pushes the functional filtering predicate into a subquery thus effectively disables the filter. CS incorrectly applies derived table name to that functional predicate saying the predicate belongs to a subquery only. |
| Comment by Daniel Lee (Inactive) [ 2019-07-12 ] |
|
Build verified: 1.,2.5-1 nightly 1.2.5-1 Verified support case |