Hi, I am with Apache Ignite V2.9.1.And using .net thin client to perform query on cache. And using cache query as SqlQuery.
here is the query statement: SELECT * FROM "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON".CommonConstruction As t1 INNER JOIN "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_CONSTRUCTIONPROJECTROLE".ProjectsRole AS t2 ON t1.UUID = t2.ProjectId where t2.PersonId = 'a91f8995-2c28-4f33-9587-817749526a55' AND t2.ProjectAccessStatus = 'true' and t2.IsDeleted != 'true' and t1.IsDeleted != 'true' AND t1.TableName='common_project'; Exception: Failed to parse query. Column "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON.COMMONCONSTRUCTION._KEY" not found; SQL statement: SELECT "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON"."COMMONCONSTRUCTION"._KEY, "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_COMMON"."COMMONCONSTRUCTION"._VAL FROM CommonConstruction As t1 INNER JOIN "F2DEDF6E-393E-42BC-9BB3-E835A1063B30_6EFB69B0-269F-4F92-98CF-24BC0D34BA98_CONSTRUCTIONPROJECTROLE".ProjectsRole AS t2 ON t1.UUID = t2.ProjectId where t2.PersonId = 'a91f8995-2c28-4f33-9587-817749526a55' AND t2.ProjectAccessStatus = 'true' and t2.IsDeleted != 'true' and t1.IsDeleted != 'true' AND t1.TableName='common_project' [42122-197] is this issue exists or i commiting mistake somewhere? Can you please give me suggestion. Thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
