When I use >=, there is data query, when I add <=, the query is wrong.
==========================[QUERY]===============================
Query Id: a2095b23-f09c-4cd7-9969-e0ad98746dc3
SQL: SELECT "HYNAME" AS "HYNAME",
SUM(QY_SUM)-SUM(QY_SUM_PRE) AS "FLOW_IN_ENTERPRISE"
FROM
(SELECT CAST(T.PAYMENT_DATE AS DATE) AS CAL_DATE,
CONCAT(CAST(S.CALENDARYEAR AS CHAR(4)),'?') AS CAL_DATE_YEAR,
CONCAT(CAST(S.CALENDARQUARTER AS CHAR(4)),'??') AS CAL_DATE_QUARTER,
CASE
WHEN S.CALENDARMONTH<10 THEN
CONCAT(CONCAT('0',CAST(S.CALENDARMONTH AS CHAR(4))),'?')
ELSE CONCAT(CAST(S.CALENDARMONTH AS CHAR(4)),'?')
END AS CAL_DATE_MONTH,
T.INDUSTRY_CATEGORY_NAME AS HYNAME,
T.COMPANY_CNT AS QY_SUM,
T.COMPANY_CNT_ROW AS QY_SUM_ROW,
T.COMPANY_CNT_BEFORE AS QY_SUM_PRE,
T.COMPANY_CNT_GROWTH_PERCENT AS QY_SUM_PERC,
(T.COMPANY_CNT-T.COMPANY_CNT_BEFORE) AS QY_SUM_GROWTH,
T.SUM_EMNUM AS YG_SUM,
T.SUM_EMNUM_ROW AS YG_SUM_ROW,
T.SUM_EMNUM_BEFORE AS YG_SUM_PRE,
T.SUM_EMNUM_GROWTH_PERCENT AS YG_SUM_PERC,
(T.SUM_EMNUM-T.SUM_EMNUM_BEFORE) AS YG_SUM_GROWTH,
T.SUM_REGISTERED_CAPITAL AS RC_SUM,
T.SUM_REGISTERED_CAPITAL_ROW AS RC_SUM_ROW,
T.SUM_REGISTERED_CAPITAL_BEFORE AS RC_SUM_PRE,
T.SUM_REGISTERED_CAPITAL_GROWTH_PERCENT AS RC_SUM_PERC,
(T.SUM_REGISTERED_CAPITAL-T.SUM_REGISTERED_CAPITAL_BEFORE) AS
RC_SUM_GROWTH,
T.SUM_OPERATING_LIFE AS OL_SUM,
T.SUM_OPERATING_LIFE_ROW AS OL_SUM_ROW
FROM INDUSTRY_RANK T
LEFT JOIN INDUSTRY_RANK_DATE S ON T.SYS_ID=S.SYS_ID) AS expr_qry
WHERE "CAL_DATE" >= TO_DATE('2011-09-20 00:00:00', 'yyyy-MM-dd')
AND "CAL_DATE" <= TO_DATE('2018-09-20 01:33:04', 'yyyy-MM-dd')
GROUP BY "HYNAME"
ORDER BY "FLOW_IN_ENTERPRISE" DESC
LIMIT 10;
User: ADMIN
Success: true
Duration: 0.226
Project: WEIHAI_DEMO
Realization Names: [CUBE[name=Cube_INDUSTRY_RANK]]
Cuboid Ids: [524287]
Total scan count: 0
Total scan bytes: 0
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: false
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
==========================[QUERY]===============================
[email protected]
