Hi Team,
We are writing some join Query through Match script and that match script is generating some PostgreSql Join query but while generating it is not inserting double quotes in end of the query. Example query has given below:
Match Script:
JoinQuery query2 = TDMJoinQuery.create(Table.name("students2").PK("ID"), Table.name("Percentage2").FK("ID"));
query2.whereArr(new WClause[]{new WClause("students2", "Name", request_Name)});
Generated Query in Work Station:
SELECT DISTINCT "students2"."ID", "students2"."Name", "students2"."Class", "students2"."Address", "Percentage2"."ID", "Percentage2"."Perce" FROM DBName."students2" INNER JOIN DBName."Percentage2" ON "students2"."ID" = "Percentage2"."ID" WHERE "students2"."Name" = 'sai' AND students2.ID = Percentage2.ID
Error in Logs:
Internal Errororg.eobjects.metamodel.MetaModelException: Could not execute query: ERROR: column students2.id does not exist
Position: 275
If i add double quotes on last two table names "(students2"."ID" = "Percentage2"."ID") and column names it is fetching the values correctly
So Please let me know where i am doing wrong..