Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.6.3
-
None
-
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 2021hardware: 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
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