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