Symptom
When running certain SQL queries in B1 Client – Query Generator, the queries will fail with a SQL syntax error.
Reproducing the issue
Scenario:
1. Run a SQL query with a BEGIN…END structure in the Query Preview first, for example:
BEGIN /*COMMENTS;*/ /*COMMENTS;*/ select * from cinf; END
2. Run another SQL string with more than one semicolon in it, for example:
/*COMMENTS;*/ /*COMMENTS;*/ select * from cinf;
Expected behavior:
The 2nd SQL query runs successfully.
Actual behavior:
The 2nd SQL query fails with a SQL syntax error.
Solution
SAP intends to provide a feature package or patch to solve the symptom that is described in this SAP Note. The section References below lists the related feature package or patch once they become available. Be aware that References can only be confirmed at feature package or patch release date. SAP delivers feature packages or patches only for selected releases at its own discretion, based on the business impact and the complexity of implementation.