Env info:
Dremio dremio-community-15.5.0
DB type: mysql5.7
Table struct:
CREATE TABLE prj_working1 (
PRJ_W_DATE date NULL DEFAULT NULL,
EMP_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
Used sql below to query the mysql table, check the physical plan found filter is not pushed down.
SELECT *
FROM mysql52.test."tb_prj_working"
WHERE PRJ_W_DATE <= LEFT(CAST(DATE_ADD(NOW(), -7) AS DATE), 10)
AND EMP_ID = '7bcfa8e5-7ca1-45df-b371-a7d06bf9b7a9'
Physical plan
00-00 Screen : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 207916.5, cumulative cost = {2515789.65 rows, 1.2302442175815001E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6939
00-01 Project(Fragment=[$0], Records=[$1], Path=[$2], Metadata=[$3], Partition=[$4], FileSize=[$5], IcebergMetadata=[$6]) : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 207916.5, cumulative cost = {2494998.0 rows, 1.2300363010815E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6938
00-02 WriterCommitter(final=[/opt/dremio-community-15.5.0-202105040508160960-dddd4dca/data/pdfs/results/1f54bfcb-2922-1113-a4db-36a2e2baec00]) : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 207916.5, cumulative cost = {2287081.5 rows, 1.23003615553995E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6937
00-03 Writer : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 207916.5, cumulative cost = {2079165.0 rows, 1.22795699053995E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6936
00-04 Project(PRJ_W_ID=[$0], PRJ_W_CONTENT=[$1], PRJ_W_DATE=[$2], ORG_ID=[$3], USER_ID=[$4], EMP_ID=[$5], PRJ_COMMON_ID=[$6], PRJ_ID=[$7], TSK_ID=[$8], APPROVE_FLAG=[$9], EVALUATE_EMP_ID=[$10], EVALUATE_CALCULATE=[$11], USER_RATE=[$12], EVALUATE_DATE=[$13], WORK_TYPE=[$14], CREATED_BY=[$15], CREATION_DATE=[$16], LAST_UPDATED_BY=[$17], LAST_UPDATE_DATE=[$18], LAST_UPDATE_LOGIN=[$19], WORK_IMGS=[$20], ATTRIBUTE1=[$21], ATTRIBUTE2=[$22], ATTRIBUTE3=[$23], ATTRIBUTE4=[$24], ATTRIBUTE5=[$25]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 207916.5, cumulative cost = {1871248.5 rows, 1.22587782553995E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6935
00-05 Project(PRJ_W_ID=[$0], PRJ_W_CONTENT=[$1], PRJ_W_DATE=[$2], ORG_ID=[$3], USER_ID=[$4], EMP_ID=[CAST('7bcfa8e5-7ca1-45df-b371-a7d06bf9b7a9'):VARCHAR(65536) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary"], PRJ_COMMON_ID=[$6], PRJ_ID=[$7], TSK_ID=[$8], APPROVE_FLAG=[$9], EVALUATE_EMP_ID=[$10], EVALUATE_CALCULATE=[$11], USER_RATE=[$12], EVALUATE_DATE=[$13], WORK_TYPE=[$14], CREATED_BY=[$15], CREATION_DATE=[$16], LAST_UPDATED_BY=[$17], LAST_UPDATE_DATE=[$18], LAST_UPDATE_LOGIN=[$19], WORK_IMGS=[$20], ATTRIBUTE1=[$21], ATTRIBUTE2=[$22], ATTRIBUTE3=[$23], ATTRIBUTE4=[$24], ATTRIBUTE5=[$25]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 207916.5, cumulative cost = {1663332.0 rows, 1.22587728495705E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6934
00-06 SelectionVectorRemover : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 207916.5, cumulative cost = {1455415.5 rows, 1.2175601051658E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6933
00-07 Filter(condition=[AND(<=($2, CAST(LEFT(CAST(DATE_ADD(NOW(), -7)):DATE, 10)):DATE), =($5, '7bcfa8e5-7ca1-45df-b371-a7d06bf9b7a9'))]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 207916.5, cumulative cost = {1247499.0 rows, 1.2154809401658E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6932
00-08 Project(PRJ_W_ID=[$0], PRJ_W_CONTENT=[$1], PRJ_W_DATE=[$2], ORG_ID=[$3], USER_ID=[$4], EMP_ID=[$5], PRJ_COMMON_ID=[$6], PRJ_ID=[$7], TSK_ID=[$8], APPROVE_FLAG=[$9], EVALUATE_EMP_ID=[$10], EVALUATE_CALCULATE=[$11], USER_RATE=[$12], EVALUATE_DATE=[$13], WORK_TYPE=[$14], CREATED_BY=[$15], CREATION_DATE=[$16], LAST_UPDATED_BY=[$17], LAST_UPDATE_DATE=[$18], LAST_UPDATE_LOGIN=[$19], WORK_IMGS=[$20], ATTRIBUTE1=[$21], ATTRIBUTE2=[$22], ATTRIBUTE3=[$23], ATTRIBUTE4=[$24], ATTRIBUTE5=[$25]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 415833.0, cumulative cost = {831666.0 rows, 1.0811668811658E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6931
00-09 Jdbc(sql=[SELECT `tb_prj_working`.`PRJ_W_ID`, `tb_prj_working`.`PRJ_W_CONTENT`, `tb_prj_working`.`PRJ_W_DATE`, `tb_prj_working`.`ORG_ID`, `tb_prj_working`.`USER_ID`, `tb_prj_working`.`EMP_ID`, `tb_prj_working`.`PRJ_COMMON_ID`, `tb_prj_working`.`PRJ_ID`, `tb_prj_working`.`TSK_ID`, `tb_prj_working`.`APPROVE_FLAG`, `tb_prj_working`.`EVALUATE_EMP_ID`, `tb_prj_working`.`EVALUATE_CALCULATE`, `tb_prj_working`.`USER_RATE`, `tb_prj_working`.`EVALUATE_DATE`, `tb_prj_working`.`WORK_TYPE`, `tb_prj_working`.`CREATED_BY`, `tb_prj_working`.`CREATION_DATE`, `tb_prj_working`.`LAST_UPDATED_BY`, `tb_prj_working`.`LAST_UPDATE_DATE`, `tb_prj_working`.`LAST_UPDATE_LOGIN`, `tb_prj_working`.`WORK_IMGS`, `tb_prj_working`.`ATTRIBUTE1`, `tb_prj_working`.`ATTRIBUTE2`, `tb_prj_working`.`ATTRIBUTE3`, `tb_prj_working`.`ATTRIBUTE4`, `tb_prj_working`.`ATTRIBUTE5`
FROM `test`.`tb_prj_working`]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 415833.0, cumulative cost = {415833.0 rows, 1.0811658E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 6844
Replace the function LEFT(CAST(DATE_ADD(NOW(), -7) AS DATE), 10) to date_add(CURRENT_DATE(),-7), and run again, check the physical plan found this query can be pushed down.
SELECT *
FROM prj_working1
WHERE PRJ_W_DATE <= date_add(CURRENT_DATE(),-7)
AND EMP_ID = '7bcfa8e5-7ca1-45df-b371-a7d06bf9b7a9'
Physical Plan
00-00 Screen : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 31187.475, cumulative cost = {637265.0724999999 rows, 1.0859793420685375E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7185
00-01 Project(Fragment=[$0], Records=[$1], Path=[$2], Metadata=[$3], Partition=[$4], FileSize=[$5], IcebergMetadata=[$6]) : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 31187.475, cumulative cost = {634146.3249999998 rows, 1.0859481545935374E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7184
00-02 WriterCommitter(final=[/opt/dremio-community-15.5.0-202105040508160960-dddd4dca/data/pdfs/results/1f54bc65-c022-8324-2f0d-9c013b266c00]) : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 31187.475, cumulative cost = {602958.8499999999 rows, 1.085948132762305E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7183
00-03 Writer : rowType = RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition, BIGINT FileSize, VARBINARY(65536) IcebergMetadata): rowcount = 31187.475, cumulative cost = {571771.3749999999 rows, 1.085636258012305E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7182
00-04 Project(PRJ_W_ID=[$0], PRJ_W_CONTENT=[$1], PRJ_W_DATE=[$2], ORG_ID=[$3], USER_ID=[$4], EMP_ID=[$5], PRJ_COMMON_ID=[$6], PRJ_ID=[$7], TSK_ID=[$8], APPROVE_FLAG=[$9], EVALUATE_EMP_ID=[$10], EVALUATE_CALCULATE=[$11], USER_RATE=[$12], EVALUATE_DATE=[$13], WORK_TYPE=[$14], CREATED_BY=[$15], CREATION_DATE=[$16], LAST_UPDATED_BY=[$17], LAST_UPDATE_DATE=[$18], LAST_UPDATE_LOGIN=[$19], WORK_IMGS=[$20], ATTRIBUTE1=[$21], ATTRIBUTE2=[$22], ATTRIBUTE3=[$23], ATTRIBUTE4=[$24], ATTRIBUTE5=[$25]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 31187.475, cumulative cost = {540583.8999999999 rows, 1.0853243832623051E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7181
00-05 Project(PRJ_W_ID=[$0], PRJ_W_CONTENT=[$1], PRJ_W_DATE=[$2], ORG_ID=[$3], USER_ID=[$4], EMP_ID=[$5], PRJ_COMMON_ID=[$6], PRJ_ID=[$7], TSK_ID=[$8], APPROVE_FLAG=[$9], EVALUATE_EMP_ID=[$10], EVALUATE_CALCULATE=[$11], USER_RATE=[$12], EVALUATE_DATE=[$13], WORK_TYPE=[$14], CREATED_BY=[$15], CREATION_DATE=[$16], LAST_UPDATED_BY=[$17], LAST_UPDATE_DATE=[$18], LAST_UPDATE_LOGIN=[$19], WORK_IMGS=[$20], ATTRIBUTE1=[$21], ATTRIBUTE2=[$22], ATTRIBUTE3=[$23], ATTRIBUTE4=[$24], ATTRIBUTE5=[$25]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 31187.475, cumulative cost = {509396.42499999993 rows, 1.08532430217487E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7180
00-06 Project(PRJ_W_ID=[$0], PRJ_W_CONTENT=[$1], PRJ_W_DATE=[$2], ORG_ID=[$3], USER_ID=[$4], EMP_ID=[$5], PRJ_COMMON_ID=[$6], PRJ_ID=[$7], TSK_ID=[$8], APPROVE_FLAG=[$9], EVALUATE_EMP_ID=[$10], EVALUATE_CALCULATE=[$11], USER_RATE=[$12], EVALUATE_DATE=[$13], WORK_TYPE=[$14], CREATED_BY=[$15], CREATION_DATE=[$16], LAST_UPDATED_BY=[$17], LAST_UPDATE_DATE=[$18], LAST_UPDATE_LOGIN=[$19], WORK_IMGS=[$20], ATTRIBUTE1=[$21], ATTRIBUTE2=[$22], ATTRIBUTE3=[$23], ATTRIBUTE4=[$24], ATTRIBUTE5=[$25]) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 31187.475, cumulative cost = {478208.94999999995 rows, 1.085324221087435E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7179
00-07 Jdbc(sql=[SELECT `tb_prj_working`.`PRJ_W_ID`, `tb_prj_working`.`PRJ_W_CONTENT`, `tb_prj_working`.`PRJ_W_DATE`, `tb_prj_working`.`ORG_ID`, `tb_prj_working`.`USER_ID`, CAST('7bcfa8e5-7ca1-45df-b371-a7d06bf9b7a9' AS CHAR(65536)) AS `EMP_ID`, `tb_prj_working`.`PRJ_COMMON_ID`, `tb_prj_working`.`PRJ_ID`, `tb_prj_working`.`TSK_ID`, `tb_prj_working`.`APPROVE_FLAG`, `tb_prj_working`.`EVALUATE_EMP_ID`, `tb_prj_working`.`EVALUATE_CALCULATE`, `tb_prj_working`.`USER_RATE`, `tb_prj_working`.`EVALUATE_DATE`, `tb_prj_working`.`WORK_TYPE`, `tb_prj_working`.`CREATED_BY`, `tb_prj_working`.`CREATION_DATE`, `tb_prj_working`.`LAST_UPDATED_BY`, `tb_prj_working`.`LAST_UPDATE_DATE`, `tb_prj_working`.`LAST_UPDATE_LOGIN`, `tb_prj_working`.`WORK_IMGS`, `tb_prj_working`.`ATTRIBUTE1`, `tb_prj_working`.`ATTRIBUTE2`, `tb_prj_working`.`ATTRIBUTE3`, `tb_prj_working`.`ATTRIBUTE4`, `tb_prj_working`.`ATTRIBUTE5`
FROM `test`.`tb_prj_working`
WHERE `tb_prj_working`.`PRJ_W_DATE` <= DATE '2021-05-17' AND `tb_prj_working`.`EMP_ID` = '7bcfa8e5-7ca1-45df-b371-a7d06bf9b7a9']) : rowType = RecordType(VARCHAR(65536) PRJ_W_ID, VARCHAR(65536) PRJ_W_CONTENT, DATE PRJ_W_DATE, VARCHAR(65536) ORG_ID, VARCHAR(65536) USER_ID, VARCHAR(65536) EMP_ID, VARCHAR(65536) PRJ_COMMON_ID, VARCHAR(65536) PRJ_ID, VARCHAR(65536) TSK_ID, INTEGER APPROVE_FLAG, VARCHAR(65536) EVALUATE_EMP_ID, FLOAT EVALUATE_CALCULATE, DOUBLE USER_RATE, TIMESTAMP(3) EVALUATE_DATE, VARCHAR(65536) WORK_TYPE, VARCHAR(65536) CREATED_BY, TIMESTAMP(3) CREATION_DATE, VARCHAR(65536) LAST_UPDATED_BY, TIMESTAMP(3) LAST_UPDATE_DATE, VARCHAR(65536) LAST_UPDATE_LOGIN, VARCHAR(65536) WORK_IMGS, VARCHAR(65536) ATTRIBUTE1, VARCHAR(65536) ATTRIBUTE2, VARCHAR(65536) ATTRIBUTE3, VARCHAR(65536) ATTRIBUTE4, VARCHAR(65536) ATTRIBUTE5): rowcount = 31187.475, cumulative cost = {447021.475 rows, 1.08532414E8 cpu, 1.0811658E8 io, 1.0811658E8 network, 0.0 memory}, id = 7099