[MCOL-4942] Different results compared to innodb with union all and subselect with null in select and impossible where condition Created: 2021-12-09 Updated: 2022-01-05 |
|
| Status: | Open |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | 6.4.1 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | Richard Stracke | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
Columnstore throws rows with union all and subselect with null in select and impossible where condition To reproduce:
Result with innodb table:
Result with Columnstore table: ------
------
------ Columnstore throws the same result like innodb, if
|