[Bug]: Optimizer doesn't support ProjectList in SEMI Join
Is there an existing issue for the same bug?
- [X] I have checked the existing issues.
Branch Name
main
Commit ID
e4c504a606585cb373a5bb7c452e804469716610
Other Environment Information
- Hardware parameters:
- OS type:
- Others:
Actual Behavior
explain analyze select a from tbl order by l2_distance(b, "[1,1,1]") limit 3;
SQL Error [1064] [42000]: SQL parser error: can't find column [11 2] in context's map { [10 3] }
Expected Behavior
Output Query Plan
Steps to Reproduce
-
Build the project with these changes https://github.com/arjunsk/matrixone/pull/90/files
-
Run the SQL
create database a;
use a;
create table tbl(a int primary key, b vecf32(3));
insert into tbl values(1, "[1,2,3]");
insert into tbl values(2, "[1,2,4]");
insert into tbl values(3, "[1,2.4,4]");
insert into tbl values(4, "[1,2,5]");
insert into tbl values(5, "[1,3,5]");
insert into tbl values(6, "[100,44,50]");
insert into tbl values(7, "[100,44,50]");
insert into tbl values(8, "[130,40,90]");
SET GLOBAL experimental_ivf_index = 1;
create index idx using ivfflat on tbl(b) lists=2 op_type "vector_l2_ops";
explain analyze select a from tbl order by l2_distance(b, "[1,1,1]") limit 3;
SQL Error [1064] [42000]: SQL parser error: can't find column [11 2] in context's map { [10 3] }
Additional information
No response
not working on it today
经和龙冉沟通,可以在1.2.1版本周期内解决
not working on it today
not working on it today
not working on it today
not working on it today
not working on it today
on leave
not working on it today
not working on it today
pass it by to @zengyan1
Fixing
In progress
In progress
In progress
In progress
In progress
In progress
In progress
In progress
In progress
In progress
In progress
In progress
In progress
暂无进展,预计2.0不会修复
暂无进展
预计2.0.1完成
进行中
Need design. Cannot finish in 2.0.1