Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-830

Some filter conditions with a SUBQUERY are removed by optimizer.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: None
    • Labels:
      None

      Description

      In the case of a next query, "col3 like '1993-11-24%';" condition removed by optimized.

      select a.*
      from (
          select 
          	L_RETURNFLAG as col1, 
          	L_EXTENDEDPRICE as col2, 
          	concat(L_RECEIPTDATE, L_LINESTATUS) as col3 
          from lineitem
      ) a
      where col2 > 0 && col3 like '1993-11-24%';
      

        Attachments

        1. TAJO-830.patch
          51 kB
          Hyoungjun Kim

          Activity

            People

            • Assignee:
              hjkim Hyoungjun Kim
              Reporter:
              hjkim Hyoungjun Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: