"The storage engine for the table doesn't support IDB-3009: Unknown column" for complex query with subquery and window functions in infinidb_vtable_mode = 0;

MariaDB [test]> show create table tc\G

*************************** 1. row ***************************

       Table: tc

Create Table: CREATE TABLE `tc` (

  `id` int(11) NOT NULL,

  `cid` int(11) DEFAULT NULL,

  `d` datetime DEFAULT NULL,

  `c` decimal(12,4) DEFAULT NULL

) ENGINE=Columnstore DEFAULT CHARSET=latin1

1 row in set (0,000 sec)

MariaDB [test]> select count(*) from tc;

+----------+

| count(*) |

+----------+

|   131072 |

+----------+

1 row in set (0,029 sec)

MariaDB [test]> set infinidb_vtable_mode = 1;

Query OK, 0 rows affected (0,000 sec)

MariaDB [test]> select cust, week_d, mpp_sum , stddev(mpp_sum) over (partition by cust) as mpp_stdev , avg(mpp_sum) over (partition by cust) as mpp_mean , sum(mpp_sum) over (partition by cust) as glob_mpp_sum,  count(mpp_sum) over (partition by cust) as glob_mpp_count  from  (select distinct cid as cust,  week(d) as week_d , sum(c) over (partition by cid, week(d)) as mpp_sum  from tc  where year(d) = '2018') as inside;

...

|  100 |     16 |  392103.7000 | 21.62676616 | 31.73315079 |    1650.1238 |             52 |

+------+--------+--------------+-------------+-------------+--------------+----------------+

5252 rows in set (0,718 sec)

MariaDB [test]> set infinidb_vtable_mode = 0;

Query OK, 0 rows affected (0,000 sec)

MariaDB [test]> select cust, week_d, mpp_sum , stddev(mpp_sum) over (partition by cust) as mpp_stdev , avg(mpp_sum) over (partition by cust) as mpp_mean , sum(mpp_sum) over (partition by cust) as glob_mpp_sum,  count(mpp_sum) over (partition by cust) as glob_mpp_count  from  (select distinct cid as cust,  week(d) as week_d , sum(c) over (partition by cid, week(d)) as mpp_sum  from tc  where year(d) = '2018') as inside;

ERROR 1178 (42000): The storage engine for the table doesn't support IDB-3009: Unknown column '..week_d'.