[MCOL-3782] 1.4 group by order error - Internal error: IDB-2021: 'ref_genome' is not in GROUP BY clause - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 1.4.2
Fix Version/s: 1.4.3-5, 1.4.4, 1.5.1
Component/s: None
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

Attachments

Activity

Ascending order - Click to sort in descending order

Daniel Lee (Inactive) added a comment - 2020-04-01 20:48

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)

Daniel Lee (Inactive) added a comment - 2020-04-01 20:48 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)

Jose Rojas (Inactive) added a comment - 2020-04-01 20:53

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

Jose Rojas (Inactive) added a comment - 2020-04-01 20:53 https://jira.mariadb.org/browse/MCOL-3828 fix appears to have fixed this issue.

Daniel Lee (Inactive) added a comment - 2020-04-30 16:13

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

Daniel Lee (Inactive) added a comment - 2020-04-30 16:13 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

People

Assignee:: Daniel Lee (Inactive)

Reporter:: David Hill (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2020-02-11 18:10

Updated:: 2024-07-08 02:12

Resolved:: 2020-04-30 16:13

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB ColumnStore