Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Not A Bug
-
v2.5.0
-
None
-
None
Description
I have two cubes corresponding to two tables t1 and t2. When I pass the user_Id in t2 to limit the query range of the t1 table, I return an empty result. Then there is data in my t2 table.
我有两个cube分别对应两张表t1和t2。当我通过t2中的user_Id去限制t1表的查询范围时,返回空结果。然后我的t2表里是有数据的。
select * from t1 inner join (select user_id from t2 where EXID='50') t2 on t1.user_id = t2.user_id;
select * from t1 where user_id in (select user_id from t2 where EXID='50');
select * from t1 where user_id in (select '1002001');
The above three statements execution results are returned No Result.
But the following statement execution can return results
select * from t1 where user_id in ('1002001');
=======================================================
Query Id: 4a12730c-5222-b4a9-43fc-282e6bea7b51
SQL: select * from t1 inner join (select user_id from t2 where EXID='50') t2 on t1.user_id = t2.user_id;
User: ADMIN
Success: true
Duration: 0.001
Project: test_project
Realization Names: [CUBE[name=t1_CUBE], CUBE[name=t2_CUBE]]
Cuboid Ids: [3, 63]
Total scan count: 50123
Total scan bytes: 5412669
Result row count: 0
Accept Partial: true
Is Partial Result: false
Hit Exception Cache: false
Storage cache used: true
Is Query Push-Down: false
Is Prepare: false
Trace URL: null
Message: null
============================================================