drop schema if exists ztest;

create schema if not exists ztest;

use ztest;

CREATE TABLE `wtest` ( `ddate` date NOT NULL ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;

insert into wtest values (now());

select * from ztest.wtest dd

where

`ddate` between

  case

  when curdate() <= str_to_date(concat(year(curdate()),'-',quarter(curdate()) * 3 - 2,'-10'), '%Y-%c-%d') then

     str_to_date(concat(year(curdate()),'-',quarter(curdate()) * 3 - 2,'-01'), '%Y-%c-%d') - interval 1 quarter

  else

     str_to_date(concat(year(curdate()),'-',quarter(curdate()) * 3 - 2,'-01'), '%Y-%c-%d')

  end

and

  case

    when curdate() <= str_to_date(concat(year(curdate()),'-',quarter(curdate()) * 3 - 2,'-10'), '%Y-%c-%d') then

    str_to_date(concat(year(curdate()),'-',quarter(curdate()) * 3 - 2,'-01'), '%Y-%c-%d') - interval 1 second

  else

    now()

  end;

ERROR 2013 (HY000): Lost connection to server during query

In error log:

220617 21:19:33 [ERROR] mysqld got signal 6 ;

select * from ztest.wtest dd

where

`ddate` between

  case

  when curdate()=now() then

     now()-interval 1 day

  else

     now()

  end

and

  now();

ERROR 2013 (HY000): Lost connection to server during query