Single-line SQL comments in Information Link SQL get converted to multi-line format in TIBCO Spotfire Server
Article ID: KB0074712
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All |
Description
One can add comments in the Information Link SQL in two ways:
Single-line comment:
The comment should end in a single line.
Multi-line comment:
Here, a comment can span over multiple lines.
The following screenshot gives an example of both the approaches.
When you write a single-line comment in Information Link SQL, you'll see that the comment is converted to a multi-line format in the SQL sent to the data source, as well in the SQL logs as shown in the screenshots below.
Information Link SQL:
SQL logged in the SQL logs:
Single-line comment:
The comment should end in a single line.
Multi-line comment:
Here, a comment can span over multiple lines.
The following screenshot gives an example of both the approaches.
When you write a single-line comment in Information Link SQL, you'll see that the comment is converted to a multi-line format in the SQL sent to the data source, as well in the SQL logs as shown in the screenshots below.
Information Link SQL:
SQL logged in the SQL logs:
Issue/Introduction
This article briefly explain how single-line comments are converted into the multi-line format, as seen in the SQL logs in TIBCO Spotfire Server.
Environment
All
Resolution
This is done on purpose, to ensure that the generated SQL is more consistent, and using the multi-line(/* */) format since that is a wider supported standard.
Feedback
Yes
No
Powered by
