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:
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.
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.
Feedback
Yes
No
Powered by
