matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.76k stars 273 forks source link

[Bug]: the `colExpr.Col.ColPos` pushed down to block reader is unset #16807

Open gouhongshen opened 2 months ago

gouhongshen commented 2 months ago

Is there an existing issue for the same bug?

Branch Name

1.2-dev

Commit ID

ae68d55047f1313a05a396d17d4a28cf903980ad

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

see repro

Expected Behavior

see repro

Steps to Reproduce

step to repro:

反复执行下面的 SQL,该问题非必现。

create database if not exists test;
use test;
DROP TABLE IF EXISTS `t_material_board_middle`;
CREATE TABLE `t_material_board_middle` (
  `reel_id` varchar(50)   NOT NULL,
  `bar_code` varchar(255)   NOT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)  
)     COMMENT='唯一码单板绑定详情';

source /Users/ghs-mo/Downloads/etao_001_13507.sql;

etao_001_13507.sql.tar.gz

branch: 1.2-dev commit id: ae68d55047f1313a05a396d17d4a28cf903980ad

related issue: https://github.com/matrixorigin/MO-Cloud/issues/3461

bug case :

image

|

normal case:

image


### Additional information

_No response_
aunjgr commented 2 months ago

on leave

aunjgr commented 2 months ago

not working on it today

aunjgr commented 1 month ago

not working on it today

aunjgr commented 1 month ago

not working on it today

aunjgr commented 1 month ago

not working on it today

aunjgr commented 1 month ago

not working on it today

aunjgr commented 1 month ago

not working on it today

aunjgr commented 3 weeks ago

not working on it today

aunjgr commented 3 weeks ago

not working on it today

aunjgr commented 2 weeks ago

not working on it today

aunjgr commented 1 week ago

not working on it today

aunjgr commented 3 days ago

not working on it today