ludovicli83 opened a new issue, #12104:
URL: https://github.com/apache/ignite/issues/12104
I describe the problem encountered below.
I create three tables and one view.
create table t_ClientInfo
(
Id char(12) not null,
Type char(1) not null,
Content char(20),
constraint pk_ClientInfo primary key(Id, type)
) with "cache_name=ClientInfo,affinity_key=Id";
insert into t_ClientInfo values ('1', 'a', 'testInfo1');
insert into t_ClientInfo values ('2', 'a', 'testInfo2');
create table t_ClientDep
(
Id char(12) not null,
ClientId char(15) not null,
isActive char(1),
constraint pk_ClientDep primary key(Id, ClientId)
) with "cache_name=ClientDep,affinity_key=Id";
insert into t_ClientDep values ('1', '00001', '1');
insert into t_ClientDep values ('2', '00002', '1');
create table t_ClientInfoDep
(
Id char(12) not null,
DepId char(12) not null,
isActive char(1),
constraint pk_ClientInfoDep primary key(Id, DepId)
) with "cache_name=ClientInfoDep,affinity_key=Id";
insert into t_ClientInfoDep values ('1', '00001', '1');
insert into t_ClientInfoDep values ('2', '00002', '1');
create or replace view v_test as
select a.ClientId, b.Id from
t_ClientDep a, t_ClientInfoDep b
where a.id = b.id and b.isactive = '1';
I can get two records while running below query sql.
select t.* from t_ClientInfo t inner join v_test tv on t.id = tv.id;
1 a testInfo1
2 a testInfo2
I can one record with the specified id.
select t.* from t_ClientInfo t inner join v_test tv on t.id = tv.id where
tv.id = '1';
1 a testInfo1
I can not get any record with below sql.
select t.* from t_ClientInfo t inner join v_test tv on t.id = tv.id where
t.id = '1';
This looks like a bug on view in 2.17 version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@ignite.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
