[Bug] Comments exported incorrectly

[expired user #11005]'s profile image [expired user #11005] posted 7 years ago in General Permalink

Version 9.4.0.5125

Comments are exported in the following format: /!40000 ALTER TABLE test /; -- HeidiSQL Version: 9.4.0.5125

Running this causes the SQL error "Table doesn't exist"

To resolve: Add a space after the /, example: / !40000 ALTER TABLE test */;

ansgar's profile image ansgar posted 7 years ago Permalink

No, comments are exported with an asterisk after the slash:

/*!40101 SELECT 1 */;

Adding a space turns such a conditional comment into an ordinary comment not being executed on any server:

/* !40101 SELECT 1 */;

Please login to leave a reply, or register at first.