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

Wrong query verification against asterisk and more expressions in select list

    Details

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

      Description

      Reproduction

      create table lineitem_year_month (
       l_orderkey bigint,
       l_partkey bigint,
       l_suppkey bigint,
       l_linenumber int,
       l_quantity float8,
       l_extendedprice float8,
       l_discount float8,
       l_tax float8,
       l_returnflag text,
       l_linestatus text,
       l_shipdate text,
       l_commitdate text,
       l_receiptdate text,
       l_shipinstruct text,
       l_shipmode text,
       l_comment text
      ) PARTITION BY COLUMN (year TEXT, MONTH TEXT);
      
      $ INSERT INTO lineitem_year_month 
        SELECT *, SUBSTR(l_shipdate, 1,4) as year, SUBSTR(l_shipdate, 6, 2) as month 
        FROM 
        default.lineitem;
      
      ERROR: INSERT has smaller expressions than target columns
      

        Attachments

          Activity

            People

            • Assignee:
              hyunsik Hyunsik Choi
              Reporter:
              hyunsik Hyunsik Choi
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: