[MCOL-3782] 1.4 group by order error - Internal error: IDB-2021: 'ref_genome' is not in GROUP BY clause Created: 2020-02-11  Updated: 2020-11-12  Resolved: 2020-04-30

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.4.2
Fix Version/s: 1.4.3-5, 1.4.4, 1.5.1

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

1um 4 pm

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

 Description   

Customer reported error and Support was able to reproduce on a single server system running 1.4.2. It as customer reported, it did successfully work on 1.2.5.

This issue is within the new 1.4.2 Columnstore/Server instance that does not occur on 1.2.5 Columnstore.

The group by order seems to be handled differently now. Both 1.4.2 and 1.2.5 instances tables are the same, but when the same query is run, it errors on 1.4.2 only.

Data will be in the next comments as confidential

 Comments   
Comment by Daniel Lee (Inactive) [ 2020-04-01 ]

Build verified: 1.4.3-5 hot fix, Azure 20200401.6
MariaDB [sc]> CREATE TABLE `bovine_assay_system` (
-> `platform_id` smallint(6) DEFAULT NULL,
-> `snp_name` varchar(48) DEFAULT NULL,
-> `assay_id` int(11) DEFAULT NULL,
-> `probe_id` int(11) DEFAULT NULL,
-> `ref_genome` varchar(64) DEFAULT NULL,
-> `variant_id` int(11) DEFAULT NULL,
-> `chrom` tinyint(4) DEFAULT NULL,
-> `cchrom` varchar(64) DEFAULT NULL,
-> `position` bigint(20) DEFAULT NULL,
-> `report_strand` tinyint(4) DEFAULT NULL,
-> `strand` tinyint(4) DEFAULT NULL,
-> `flip` tinyint(4) DEFAULT NULL,
-> `allele_group` varchar(7) DEFAULT NULL,
-> `design_allele1` char(1) DEFAULT NULL,
-> `design_allele2` char(1) DEFAULT NULL,
-> `ref` char(1) DEFAULT NULL,
-> `allele_count` tinyint(4) DEFAULT NULL
-> ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.217 sec)

MariaDB [sc]> with parentage as (select distinct variant_id,ref_genome,chrom from sc.bovine_assay_system where ref_genome = 'ARS-UCDv1.2.fasta' and snp_name like '%Parent%' group by variant_id,ref_genome,chrom
-> ) select distinct variant_id,ref_genome,chrom from sc.bovine_assay_system where ref_genome ='ARS-UCDv1.2.fasta' and platform_id!=45 and variant_id not in (select variant_id from parentage)
-> group by variant_id,ref_genome,chrom having count(distinct platform_id)=19;
Empty set (0.205 sec)

Comment by Jose Rojas (Inactive) [ 2020-04-01 ]

https://jira.mariadb.org/browse/MCOL-3828 fix appears to have fixed this issue.

Comment by Daniel Lee (Inactive) [ 2020-04-30 ]

1.4.4-1

/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit 00abe03ad1da3719e06f7112000a331ee2b6786a
Author: Patrick LeBlanc <43503225+pleblanc1976@users.noreply.github.com>
Date: Wed Apr 29 10:00:54 2020 -0500

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit 2b67ac7f3537bd4b4d132c8a6c3a53e4cc63f4a1
Merge: beaac49 23d65dc
Author: benthompson15 <ben.thompson.015@gmail.com>
Date: Tue Apr 28 15:40:45 2020 -0500

1.5.0-1

/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit 25eb50d6c002e987e2d240402391549d408c18d9
Author: Alexey Bychko <abychko@gmail.com>
Date: Thu Apr 23 12:36:13 2020 +0700

commit 6ad38ccc28d31a099d052e5de827543808843a3c
Merge: 658abae bb3e76b
Author: benthompson15 <ben.thompson.015@gmail.com>
Date: Fri Apr 24 14:31:09 2020 -0500

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