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
For example:
SELECT id_product// Some comment FROM ps_product
Unknown column 'id_productFROM' in 'field list'
Warnings: --->
W (1): Unknown column 'id_productFROM' in 'field list'
<---
SELECT id_product // Some comment FROM ps_product
work.
|
|
77 KB
This is probably a JDBC driver specific issue, because I've tested it on ADS with a MySQL connection and both scenarios work as expected (no error). Also, the SQL Log window shows that the comment is not sent to the MySQL server.
The behavior of the "//" comment is configurable in ADS in File->Options->Scripts->MySQL->[Server Side Comment: //]. For MySQL, the default is that it is a client side comment, so it is removed before execution to the server.
The behavior of the "//" comment is configurable in ADS in File->Options->Scripts->MySQL->[Server Side Comment: //]. For MySQL, the default is that it is a client side comment, so it is removed before execution to the server.
This bug would occur with the "//" or the "--" comment block, if the server side option was disabled, and the comment was at the end of a statement separator. The problem was that the comment was consuming the line feed and would cause the statement separator to not be understood.
This bug would occur with the "//" or the "--" comment block, if the server side option was disabled, and the comment was at the end of a statement separator. The problem was that the comment was consuming the line feed and would cause the statement separator to not be understood.
I think it is trivial to fix - just replace comment to space instead of empty string before send query to server, is not?
I think it is trivial to fix - just replace comment to space instead of empty string before send query to server, is not?
Yes, it is fixed in rc-24 to be out on Monday.
Yes, it is fixed in rc-24 to be out on Monday.
Issue #7743 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
relates to #8872
Issue #8872In some cases execution of current statement by Cntrl+Enter runs other statement than under cursor |
This is probably a JDBC driver specific issue, because I've tested it on ADS with a MySQL connection and both scenarios work as expected (no error). Also, the SQL Log window shows that the comment is not sent to the MySQL server.