Hi,
I am using apache Ignite v2.9.1 as .Net client server.
I have two caches and each cache is belong to separate cache group.
Not working query:
SELECT * FROM
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".CommonConstruction
Where TableName='common_project' AND UUID IN (SELECT ProjectId FROM
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_CONSTRUCTIONPROJECTROLE".ProjectsRole
where PersonId = 'a91f8995-2c28-4f33-9587-817749526a55'
AND ProjectAccessStatus = 'true' and IsDeleted != 'true')
Result:No rows selected
With same query if i am passing subquery result as constants uuid inside IN
operator query working.
for example query:
SELECT * FROM
"F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".CommonConstruction
Where TableName='common_project' AND UUID IN
('de2f8754-e791-4333-87a5-8391146770af');
Result: 1 row selected.
Not getting why not with subquery on different cache not working.
Could please help me where i am doing wrong.
Thanks.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
