ReturnedColumn* tmp = derivedColList[sc->colPosition()]->clone();

(gdb) p *sc

$3 = {<execplan::ReturnedColumn> = {<execplan::TreeNode> = {

      _vptr.TreeNode = 0x7fbe9cbfbd78 <vtable for execplan::SimpleColumn+16>, 

      fResult = {intVal = 0, uintVal = 0, origIntVal = 0, dummy = 0, 

        doubleVal = 0, floatVal = 0, boolVal = false, strVal = "", 

        decimalVal = {value = 0, scale = 0 '\000', precision = 0 '\000'}, 

        valueConverted = false}, fResultType = {colWidth = 8, 

        constraintType = execplan::CalpontSystemCatalog::NO_CONSTRAINT, 

        colDataType = execplan::CalpontSystemCatalog::DATETIME, ddn = {

          dictOID = -2147483648, listOID = -2147483648, treeOID = -2147483648, 

          compressionType = 0}, defaultValue = "", colPosition = 16, 

        scale = 0, precision = 10, compressionType = 0, columnOID = 33946, 

        autoincrement = false, nextvalue = 1}, fOperationType = {colWidth = 0, 

        constraintType = execplan::CalpontSystemCatalog::NO_CONSTRAINT, 

        colDataType = execplan::CalpontSystemCatalog::MEDINT, ddn = {

          dictOID = 0, listOID = 0, treeOID = 0, compressionType = 0}, 

        defaultValue = "", colPosition = -1, scale = 0, precision = -1, 

        compressionType = 0, columnOID = 0, autoincrement = false, 

        nextvalue = 0}, fRegex = {px = 0x0, pn = {pi_ = 0x0}}, 

      tmp = '\000' <repeats 311 times>, fDerivedTable = "", fRefCount = 0, 

      fDerivedRefCol = 0x0}, fReturnAll = false, fSessionID = 0, 

    fSequence = -1, fCardinality = 0, fAlias = "", fDistinct = false, 

    fJoinInfo = 0, fAsc = true, fNullsFirst = true, 

    fOrderPos = 18446744073709551615, fColSource = 0, fColPosition = -1, 

    fSimpleColumnList = std::vector of length 0, capacity 0, 

    fAggColumnList = std::vector of length 0, capacity 0, 

    fWindowFunctionColumnList = std::vector of length 0, capacity 0, 

    fHasAggregate = false, fData = "", fErrMsg = "", fInputIndex = 4294967295, 

    fOutputIndex = 4294967295, fExpressionId = 4294967295}, 

  fSchemaName = "finup_core", fTableName = "lend_repay_record", 

  fColumnName = "repaid_time", fOid = 33946, fTableAlias = "lh02", 

  fData = "finup_core.lh02.repaid_time", fIndexName = "", fViewName = "", 

  fIsInfiniDB = true}

SELECT

        lh02.core_lend_request_id,

        max(date(lh02.repaid_time)) AS max_repaid_time,

    lh01.real_due_date AS 'real_due_date'

    FROM

        finup_core.lend_repay_record lh02

    LEFT JOIN (

        SELECT

            core_lend_request_id,

            due_date AS real_due_date

        FROM

            finup_core.lend_repay_record

        WHERE

            TIMESTAMPDIFF(DAY,date(due_date),date("''' + date01 + '''")) =1

    ) lh01 ON lh02.core_lend_request_id = lh01.core_lend_request_id

    WHERE

        TIMESTAMPDIFF(DAY,date(lh02.due_date),DATE("''' + date01 + '''")) >= 0

    AND TIMESTAMPDIFF(DAY,date(lh02.repaid_time),DATE(lh01.real_due_date)) >= 0

    AND lh02.repaid_time IS NOT NULL 

    GROUP BY

        lh02.core_lend_request_id

create table mcol1040 (a int, b datetime, c datetime) engine=columnstore;

select mcol1040.a from mcol1040 left join (select a, c from mcol1040 mc) mcs on mcol1040.a = mcs.a where timestampdiff(DAY, b, mcs.c) >= 0;