You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
08bef648b3
* MCOL-5074 CASE with IN and aggregate asserts gwip-scsp wasn't set and buildPredicateItem() was called which assumes it is set. Added code to set properly in this case
44 lines
1.4 KiB
Plaintext
44 lines
1.4 KiB
Plaintext
#
|
|
# Test based on Jira MCOL-5074
|
|
# Author: dhall, david.hall@mariadb.com
|
|
#
|
|
# A case statement with an IN and an aggregate would cause plugin assert
|
|
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol_5074_db;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE mcol_5074_db;
|
|
USE mcol_5074_db;
|
|
|
|
CREATE TABLE `accnt` (
|
|
`acct_id` varchar(128) NOT NULL DEFAULT 'None',
|
|
`created_dt` datetime NOT NULL,
|
|
`mtn` varchar(21) NOT NULL DEFAULT 'None',
|
|
`accts` tinyint(4) NOT NULL DEFAULT 0
|
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;
|
|
|
|
insert into accnt values
|
|
(1, '2021-12-11', "Partner", 5),
|
|
(2, '2021-12-12', "Retail", 4),
|
|
(1, '2021-12-11', "Partner", 5),
|
|
(3, '2021-12-11', "Mid-Market", 3),
|
|
(5, '2021-12-11', "PFG", 4),
|
|
(5, '2021-12-11', "PFG", 4),
|
|
(5, '2021-12-11', "Person Focal Group", 4),
|
|
(5, '2021-12-11', "Person Focal Group", 4);
|
|
|
|
select
|
|
mtn,
|
|
accts,
|
|
DATE_FORMAT(created_dt, '%Y-%m-%d') act_created_dt,
|
|
case when da.mtn = 'Partner' then count( acct_id) end as Partner_active_accts,
|
|
case when da.mtn = 'Retail' then count( acct_id) end as Retail_active_accts,
|
|
case when da.mtn = 'Enterprise' then count( acct_id) end as ENT_active_accts,
|
|
case when da.mtn in ('PFG','Person Focal Group') then count( acct_id) end +
|
|
case when da.mtn = 'Person Focal Group' then count( acct_id) end as PFG_active_accounts
|
|
from accnt da group by mtn, accts, act_created_dt order by mtn;
|
|
|