[MCOL-1833] Select count(*) from table not work correctly Created: 2018-10-25  Updated: 2021-01-15

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: 1.1.6
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Nicola Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Vmware 6.7
2 UM
3 PM



 Description   

Hi,
i've one table with 43008 records but using select count there are about 49152 thousand records.
Why this discrepancy?
SELECT * FROM unified_audit_trail_test
43008 records
SELECT COUNT FROM unified_audit_trail_test
49152 records

SELECT dbid,COUNT FROM unified_audit_trail_test GROUP BY dbid
DBID COUNT
3286457321 42105 records
3257935924 903 records



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-10-25 ]

Can you please provide a test case for this? A schema and data?

Comment by Andrew Hutchings (Inactive) [ 2018-10-25 ]

Also please confirm you are using 1.1.6. This is reminiscent of a bug that was fixed in that version.

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