Easily find issues by searching: #<Issue ID>
Example: #1832
When generating SQL in the Query Builder we have an option to use Quoted Identifiers. When this option is enabled, the Aqua Data Studio defaulted Quoted Identifier for that database is used. The default value is a value which is determined by AquaFold and is not changable. It is determined in the UtilScript.java. The default value for Sybase ASE, Informix and Generic is EMPTY, meaning we don't use Quote Identifier. So, for Sybase ASE you can enable the option in Query Builder, but no Quote Identifier will appear. Sybase ASE users have never complained because Sybase ASE users don't use Quote Identifiers for object names. Reason we choose empty string for quote identifiers in Sybase ASE is because Sybase ASE has the "set quoted_identifier" option, and also has the _bug_ of messing up the name of an object when using double quotes and the name is too long.
What is fixed for this issue and for what build ? Can you add as a comment ?
In the latest build dev-316, I get an error message for Sybase ASE all the time. See attached
@tariq: you did not include a full screen snapshot. The issue most likely is that you have a different DB as your primary DB and you have not turned on schema qualified & DB qualified options.
@tariq: you did not include a full screen snapshot. The issue most likely is that you have a different DB as your primary DB and you have not turned on schema qualified & DB qualified options.
@sachin: that is not the case. See full screenshot with both options turned on
@sachin: that is not the case. See full screenshot with both options turned on
Found out the QB was creating an upper case SQL with the Format SQL option. Will talk to Asif on this.
Found out the QB was creating an upper case SQL with the Format SQL option. Will talk to Asif on this.
How to verify this issue:
The default value for Sybase ASE, Informix and Generic is EMPTY, meaning we don't use Quote Identifier.
For the above DB connections, the Query > Quote Identifier option will be grayed out in the UI and user will not be able to turn it on.
How to verify this issue:
The default value for Sybase ASE, Informix and Generic is EMPTY, meaning we don't use Quote Identifier.
For the above DB connections, the Query > Quote Identifier option will be grayed out in the UI and user will not be able to turn it on.
Issue #12218 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
relates to #11184
Issue #11184Quote Identifer checkbox is not working in Query Builder of Sybase ASE |
What is fixed for this issue and for what build ? Can you add as a comment ?
In the latest build dev-316, I get an error message for Sybase ASE all the time. See attached