[MCOL-3813] Count with view is incorrect Created: 2020-02-20  Updated: 2020-11-12  Resolved: 2020-06-03

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.4.3
Fix Version/s: 1.4.5, 1.5.1

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2020-4, 2020-5, 2020-6, 2020-7
Epic/Theme: 1.4_regressions

 Description   

queries/working_tpch1_compareLogOnly/misc/bug5764.sql should return 2 for count, yet returns 10.

 Comments   
Comment by Jose Rojas (Inactive) [ 2020-05-09 ]

This is not actually an issue with count, however, it is an issue that pertains to a view used in subquery.

Previously a fix for MCOL-1349 reinstated some code for fix outer joins with views being processed twice. There is a case where a view inside a subquery was not processing it's outer join at all. Added a fix here to allow view in subquery to process outerjoin.

Reinstated regression test that was broken and added a separate regression test related to MCOL-1349 as well

Comment by Daniel Lee (Inactive) [ 2020-06-02 ]

Build verified: 1.5.0-1 (drone 20200602)

Verified count() returned 2.

Comment by Daniel Lee (Inactive) [ 2020-06-03 ]

Build verified: 1.4.5-1 (drone 20200603, engine commit: 89b7e0ad)

Generated at Thu Feb 08 02:45:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.