Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
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 ;
|
Here is a more simplified query that also crashes the database:
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
|