matrixorigin / matrixone

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

[Bug]: streaming: dynamic table which two source table join results error #13620

Open heni02 opened 10 months ago

heni02 commented 10 months ago

Is there an existing issue for the same bug?

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):3130c7dbfebb84ce5e1642d93b6104238af1fe5f
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

stream_81 and stream_8 column c1 are same data,but dynamic table read c1 has same duplicate data

企业微信截图_1235328e-70f2-4cb5-9f12-09669a957408

two source join results correct

企业微信截图_f5d4e3fd-03a2-4627-916c-b34450f85f86

ddl: create dynamic table dt8 as select a.c1,a.c2,a.c3 from stream_81 a join stream_8 b on a.c1=b.c1;

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

heni02 commented 10 months ago

in subquery also has this problem create dynamic table dt8 as select c1,c3 from stream_81 where c1 in(select c1 from stream_8 where c1<12);

企业微信截图_24e73864-0010-43f8-89b2-5b836f37ad74
gavinyue commented 10 months ago

目前不支持两个source

gavinyue commented 10 months ago

暂时不支持

gavinyue commented 10 months ago

不解决 暂时只支持一个source

gavinyue commented 10 months ago

不支持的feature

gavinyue commented 9 months ago

Pending

gavinyue commented 9 months ago

Pending

qingxinhome commented 9 months ago

Pending

qingxinhome commented 8 months ago

Pending processing

qingxinhome commented 8 months ago

Pending processing

qingxinhome commented 8 months ago

Pending processing

qingxinhome commented 7 months ago

Pending processing

qingxinhome commented 7 months ago

Pending processing

qingxinhome commented 7 months ago

Pending processing

qingxinhome commented 7 months ago

Pending processing

qingxinhome commented 7 months ago

Pending processing

qingxinhome commented 6 months ago

Pending processing

qingxinhome commented 6 months ago

Pending processing

qingxinhome commented 6 months ago

Pending processing

qingxinhome commented 6 months ago

Pending processing

qingxinhome commented 5 months ago

Pending processing

qingxinhome commented 5 months ago

Pending processing

qingxinhome commented 5 months ago

Pending processing

qingxinhome commented 5 months ago

Pending processing

qingxinhome commented 5 months ago

Pending processing

qingxinhome commented 4 months ago

not working on it

qingxinhome commented 4 months ago

not working on it

qingxinhome commented 2 months ago

not working on it

qingxinhome commented 2 months ago

not working on it

qingxinhome commented 1 month ago

not working on it

qingxinhome commented 1 month ago

not working on it

qingxinhome commented 1 month ago

Pending processing

qingxinhome commented 1 month ago

Pending processing

qingxinhome commented 4 weeks ago

Pending processing

qingxinhome commented 4 weeks ago

Pending processing

qingxinhome commented 3 weeks ago

Pending processing

qingxinhome commented 2 weeks ago

Pending processing

qingxinhome commented 1 week ago

Pending processing

qingxinhome commented 1 week ago

Pending processing

qingxinhome commented 1 day ago

Pending processing