-
Notifications
You must be signed in to change notification settings - Fork 320
Closed
Labels
autotest-addedthe case has append to autotestthe case has append to autotestresolveproblem has been fixed by developerproblem has been fixed by developer
Milestone
Description
- dble version: 2.19.5.0
- schema.xml
<schema name="schema1" sqlMaxLimit="100" dataNode="dn1">
</schema>
<schema name="schema3" sqlMaxLimit="100" dataNode="dn2">
</schema>
<schema name="schema2" sqlMaxLimit="100" dataNode="dn3">
</schema>
- steps:
schema1
create table table_a(id int,goods_id varchar(40),city varchar(40));
insert into table_a values(1,"goods","city");
schema2
create table table_b(id int,goods_id varchar(40));
insert into table_b values(2,"goods");
create table table_c(id int,city varchar(50),wid int);
insert into table_c values(3,"city",4);
schema3
create table table_d(id int,name varchar(100));
insert into table_d values(4,"12345AAA") ;
- expect result:
select
dg.id aaaa,
dgw.id bbbb,
ew.id cccc
from schema1.table_a dgw
inner join schema2.table_b dg
on dgw.goods_id = dg.goods_id
left join schema2.table_c dwp
on dgw.city = dwp.city
left join schema3.table_d ew
on ew.id = dwp.wid
where dgw.id = 1
and ew.name regexp 'AAA';
has result - real result:
Empty set (0.89 sec)
Metadata
Metadata
Assignees
Labels
autotest-addedthe case has append to autotestthe case has append to autotestresolveproblem has been fixed by developerproblem has been fixed by developer