Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA | swissarmyknife(*) |
| Priority | Low |
| Complexity | Unknown |
| Component | App - FluidShell |
| Version | 14.0 |
occurs in 15.0.0-dev-47 and 14.0.5
in Fluid mode
1. have a .sql file that begins with a commented line like the following
//first line comment
select * from likes
2. use the source command to get this file into the SQL Buffer.
sqlexport -f excel -o C:/12052013export3.xls
3. The sqlexport command will generate a syntax error.
4. However if source is used on the same file followed by "go" no syntax error is generated.
see attached screenshot
The SQL Parser used by Export didn't have any of the server comment script options set. It didn't remove the comment in the script and was passing it to the server, which resulted in a syntax error from the server.
Fixed the Export code to pass in the server comment script options to the SQL Parser. If the server comment options are off, comments in the script won't be sent to the server.
Issue #10971 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 14.0.5-7 |
| No time estimate |
The SQL Parser used by Export didn't have any of the server comment script options set. It didn't remove the comment in the script and was passing it to the server, which resulted in a syntax error from the server.
Fixed the Export code to pass in the server comment script options to the SQL Parser. If the server comment options are off, comments in the script won't be sent to the server.