SELECT
OrderCode,
CasherId ,
IsReturned
FROM
(
SELECT
bcr.OrganizationId,
bcr.OrderCode,
bcr.ReviewerId as CasherId,
bcr.ReviewerCode,
bcr.ReviewerName,
mco.ComboId,
case when bcr.SaleOrderCode is not null then '是' else '否' end IsReturned
FROM
batchcardrecharges bcr
INNER JOIN batchcardrechargedetails bcrd ON bcr.Id = bcrd.BatchCardRechargeId
INNER JOIN membercombos mco ON bcrd.CardNumber = mco.ComboSaleCardNo
AND mco.SourceType = 35
AND mco.ActivationState = 1
AND bcr.Id = mco.TriggerId
AND bcr.OrderType = 0
WHERE
bcr.OrderState = 1
AND mco.ActivationDate >= '2025-09-01'
AND mco.ActivationDate < '2025-10-01'
AND bcr.TenantId = 2 UNION ALL
SELECT
scr.OrganizationId,
scr.OrderCode,
'' AS CasherId,
'' AS CasherCode,
'' AS CasherName,
null,
'否' as IsReturned
FROM
shopconsumptionrefund scr
WHERE
scr.OrderStatus IN ( 5, 8 )
AND scr.LastUpdatorTime >= '2025-09-01'
AND scr.LastUpdatorTime < '2025-10-01'
AND scr.TenantId = 2
) AS a
INNER JOIN (
SELECT
c.TenantId,
c.Id,
c.`Code`,
c.`Name`,
c.SalePrice
FROM
combo c
) cbo ON cbo.TenantId = 2
AND cbo.Id = a.ComboId
WHERE
cbo.`Code` = '000032'
LIMIT 0,
20;
Oceanbase版本：OceanBase_CE-v4.3.5.1
执行以上SQL就会出现乱码，每次执行产生的乱码还不同。
CREATE_TABLE.txt (13.4 KB)
