[Bug]: the runtime filter is misplaced on main branch about matrixone HOT 5 CLOSED

create database iotdemo;
use iotdemo;

CREATE TABLE `sensor_data1` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `device_id` INT NOT NULL,
    `timestamp` TIMESTAMP NOT NULL,
    `value` FLOAT NOT NULL,
    PRIMARY KEY (`device_id`,`id`));

INSERT INTO sensor_data1 (device_id, timestamp, value) select *,NOW(),1.1 from generate_series(1,10000000)g;

from matrixone.

本地测试的结果 : #15767 (comment)

create database iotdemo;
use iotdemo;

CREATE TABLE `sensor_data1` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `device_id` INT NOT NULL,
    `timestamp` TIMESTAMP NOT NULL,
    `value` FLOAT NOT NULL,
    PRIMARY KEY (`device_id`,`id`));

INSERT INTO sensor_data1 (device_id, timestamp, value) select *,NOW(),1.1 from generate_series(1,10000000)g;

from matrixone.

辛苦涛哥跟踪吧, @badboynt1

from matrixone.

mysql> explain insert into sensor_data1 (device_id, timestamp, value) values(1,now(),1);
+-------------------------------------------------------+
| QUERY PLAN |
+-------------------------------------------------------+
| Plan 0: |
| Sink |
| -> Lock |
| -> PreInsert on iotdemo.sensor_data1 |
| -> Project |
| -> Project |
| -> Values Scan "VALUES" |
| Plan 1: |
| Insert on iotdemo.sensor_data1 |
| -> Sink Scan |
| DataSource: Plan 0 |
| Plan 2: |
| Fuzzy Filter for duplicate key |
| Runtime Filter Build: #[0,0] |
| -> Table Scan on iotdemo.sensor_data1 |
| Runtime Filter Probe: __mo_cpkey_col |
| -> Sink Scan |
| DataSource: Plan 0 |
+-------------------------------------------------------+
18 rows in set (0.01 sec)
修改后新的执行计划，已修复

from matrixone.

fixed:

from matrixone.