[MDEV-26290] every time when I execute one sql statement mariadb got crashed Created: 2021-08-01  Updated: 2021-08-01

Status: Open
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Affects Version/s: 10.6.3
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: chen Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: crash
Environment:

hardware:
Manufacturer: ASUSTeK COMPUTER INC. Product Name: P11C-M-10G-2T Series, one Intel(R) Xeon(R) E-2236 CPU @ 3.40GHz.
MemTotal: 65755120 kB
MemFree: 5244176 kB
MemAvailable: 52143772 kB
4T SAS hard disk

software:
Linux version 5.4.0-80-generic (buildd@lcy01-amd64-030) (gcc version 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04)) #90-Ubuntu SMP Fri Jul 9 22:49:44 UTC 2021

Attachments: File 1.sql     Zip Archive 1.zip     File my.cnf     Text File mysqld.log    

 Description   

I have a table with data of attachment 1.zip. I can select all rows without any problem.
But every time I execute the follow sql mariadb got crashed(I have try to drop and recreate the table and create the table in other database but without any effect):
SELECT id, createDate,createTime, TYPE, typeName, state, orderInfo, stateInfo, state4Tab ,fromPlanId,money,prize, betConfirmTime
,autoShowPrintedTime
FROM order_orders1 WHERE userId=66668951

AND (
(state4Tab = 40 AND TYPE NOT IN (10,70,80))
OR
(TYPE IN (10,70,80) AND autoShowPrintedTime <= '2021-07-24 15:32:42' )
)

ORDER BY ID DESC
Generated at Thu Feb 08 09:44:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.