Query with join runs forever
Article ID: KB0079947
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | TDV All Versions |
Description
We noticed that a simple inner join query is running endlessly and does not return any result.
Resolution
1.Set the Value as False for "Case Sensitivity" under Studio - Administration - Configuration - Server - SQL Engine - SQL Language
2.Verify Ignore Trailing spaces is matching to the datasource properties.
3.Set Value as TRUE for "Keep Comments“under Studio - Administration - Configuration - Server - SQL Engine - SQL Language
2.Verify Ignore Trailing spaces is matching to the datasource properties.
3.Set Value as TRUE for "Keep Comments“under Studio - Administration - Configuration - Server - SQL Engine - SQL Language
Issue/Introduction
We noticed that a simple inner join query is running endlessly and does not return any result.
Feedback
Yes
No
Powered by
