MySQL Comments not being parsed correctly (bug?)

Comment that will run queries depending on the version of MySQL being used don't appear to be being parsed correctly at times...of the following 2 lines the first works fine but the second produces an error.

 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT; */
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;


The error for the second command (which executes OK when run directly on the MySQL command line) is as follows...

[2014-08-19 09:51:48] [42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/' at line 1

3 comments
Comment actions Permalink

For me it's the opposite way: the 2nd is always success, the first does not work without selection, but works with Execute Selection action. BTW, you can also try Execute Selection if it helps.

Anyway, created http://youtrack.jetbrains.com/issue/DBE-719, welcome to comment if you like.

Regards,
Alexander.

0
Comment actions Permalink

Fixed already, cool...thanks :-)

Presumably that'll be available in the next update, or are there nightly builds available?

0
Comment actions Permalink

Currently only EAP builds are shared for end users. It should appear in a several weeks or so.

Regards,
Alexander.

0

Please sign in to leave a comment.